Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #5076 > unrolled thread
| Started by | Martin <spam@spam.spam> |
|---|---|
| First post | 2013-04-17 17:16 +0100 |
| Last post | 2013-04-18 16:53 +0100 |
| Articles | 5 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
VERY STUPID Question Martin <spam@spam.spam> - 2013-04-17 17:16 +0100
Re: VERY STUPID Question D.J.W. van Kooten <public@ic2remove.this.com> - 2013-04-17 18:44 +0200
Re: VERY STUPID Question Martin <spam@spam.spam> - 2013-04-18 09:33 +0100
Re: VERY STUPID Question dlzc <dlzc1@cox.net> - 2013-04-18 08:03 -0700
Re: VERY STUPID Question Martin <spam@spam.spam> - 2013-04-18 16:53 +0100
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-04-17 17:16 +0100 |
| Subject | VERY STUPID Question |
| Message-ID | <_Uzbt.9399$pP5.6468@fx24.fr7> |
How do I close an index without closing the DBF? Yes over 25 years and I cannot find how to do this! Embarrassed Martin
[toc] | [next] | [standalone]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-04-17 18:44 +0200 |
| Message-ID | <l6ktm85knu2d88oki04clgf6ih6ipqmndo@4ax.com> |
| In reply to | #5076 |
On Wed, 17 Apr 2013 17:16:06 +0100, Martin <spam@spam.spam> wrote: >How do I close an index without closing the DBF? > Hello Martin, Nothing stupid. Anything that you don't do daily can sometimes be hard to find! See : DBServer:SetIndex() Method "If no argument is passed, all currently opened indexes are closed, and the server reverts back to sequential access based on record number (natural order). This is equivalent to ClearIndex()." The question is why you want to do that? It gives the risk that you make changes which are not reflected in the index. Do you mabe just want a Setorder(0) to have the file in natural order? Dick
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-04-18 09:33 +0100 |
| Message-ID | <tdObt.9853$5w6.7572@fx05.fr7> |
| In reply to | #5077 |
No it is that I open via a class the index name is different to that of the DBF. Very old file, structure is never changed since 5.2e days, last change was moving to CDX a LONG time ago. I remember finding a bug in the 5.2 CDX RDD, had to move some code to a standalone system and it crashed, had to do an emergency NTX back convert. AXS 3.x worked, 5.3 BTW worked fine. What I am doing is. Check structure Field is too short Rename file Create new with bigger field Open up using standard method Now want to close it Append in the old file. Contents should be identical apart from one field I may just modify the open method to take a flag to not open the CDX Thanks Martin -------- Original Message -------- Subject: Re: VERY STUPID Question Date: Wed, 17 Apr 2013 18:44:27 +0200 From: D.J.W. van Kooten <public@ic2remove.this.com> Organisation: IC2 Newsgroups: comp.lang.clipper.visual-objects References: <_Uzbt.9399$pP5.6468@fx24.fr7> On Wed, 17 Apr 2013 17:16:06 +0100, Martin <spam@spam.spam> wrote: >How do I close an index without closing the DBF? > Hello Martin, Nothing stupid. Anything that you don't do daily can sometimes be hard to find! See : DBServer:SetIndex() Method "If no argument is passed, all currently opened indexes are closed, and the server reverts back to sequential access based on record number (natural order). This is equivalent to ClearIndex()." The question is why you want to do that? It gives the risk that you make changes which are not reflected in the index. Do you mabe just want a Setorder(0) to have the file in natural order? Dick
[toc] | [prev] | [next] | [standalone]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2013-04-18 08:03 -0700 |
| Message-ID | <dbd52744-5be7-4dfc-8c75-bc7f7ba8866a@googlegroups.com> |
| In reply to | #5079 |
Dear Martin: On Thursday, April 18, 2013 1:33:44 AM UTC-7, Martin wrote: ... > I may just modify the open method to take a flag > to not open the CDX In (x)Harbour we have SET AUTOPEN OFF, so that any DBFs opened will not have the associated indexes opened. Global flags are their own hell however, but so are undocumented changes to source. Good luck. Sounds like it is time to update the index name file now. David A. Smith
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-04-18 16:53 +0100 |
| Message-ID | <DFUbt.11482$FR3.2513@fx30.fr7> |
| In reply to | #5087 |
I just modded the opening routine to set a flag, 'N' for no index and 'R' for rebuild index On 18/04/2013 16:03, dlzc wrote: > Dear Martin: > > On Thursday, April 18, 2013 1:33:44 AM UTC-7, Martin wrote: > ... >> I may just modify the open method to take a flag >> to not open the CDX > > In (x)Harbour we have SET AUTOPEN OFF, so that any DBFs opened will not have the associated indexes opened. Global flags are their own hell however, but so are undocumented changes to source. > > Good luck. > > Sounds like it is time to update the index name file now. > > David A. Smith >
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web