Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #5076 > unrolled thread

VERY STUPID Question

Started byMartin <spam@spam.spam>
First post2013-04-17 17:16 +0100
Last post2013-04-18 16:53 +0100
Articles 5 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#5076 — VERY STUPID Question

FromMartin <spam@spam.spam>
Date2013-04-17 17:16 +0100
SubjectVERY 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]


#5077

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-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]


#5079

FromMartin <spam@spam.spam>
Date2013-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]


#5087

Fromdlzc <dlzc1@cox.net>
Date2013-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]


#5090

FromMartin <spam@spam.spam>
Date2013-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