Structural indexes - Clipper

Dear Martin:

On Jun 21, 7:02 am, "Martin" <spams...@spam.spam> wrote:
> Hello
>
> I am moving from different named DBFs and CDXs
> to same name so I do not have to do ORDLISTADD()
>
> I can't get my programme to do auto open, any
> ideas on what to look for,
> 5.3B ADS7.1 and DBFCDX

There is a bit in the header that must be set, in order to auto open.
http://ulisse.elettra.trieste.it/ser.../DBFstruct.htm

If the database engine tries to open the dbf and the cdx is not
present, the bit is turned off.

You might try noting the "orderbags" in the index, "set order to",
then recreate the index.

http://www.itlnet.net/Programming/Pr...c/ng3f081.html

David A. Smith

Martin

If the DBF and CDX don't have the same name
Eg
FRED.DBF
FRED.CDX

then you need to use
SET INDEX TO whatever
ie the same as you'd use for NTX

Autoopen only works when both have the same name.

--
CYA
Steve

Martin

That should be

If the DBF and CDX have the same name then autoopen works
Eg
FRED.DBF
FRED.CDX

If the DBF and CDX don't have the same name
Eg
FREDDO.DBF
FRED.CDX

then you need to use
USE FREDDO
SET INDEX TO 'FRED.CDX'
ie the same as you'd use for NTX

Autoopen only works when both have the same name.

--
CYA
Steve

I have rebuilt as same name so very puzzled.

> If the DBF and CDX don't have the same name
> Eg
> FREDDO.DBF
> FRED.CDX
>
> then you need to use
> USE FREDDO
> SET INDEX TO 'FRED.CDX'

Tell me one reason why the .DBF and the .CDX should have a different name!

"Turan Fettahoglu" wrote in message news:f5gf98$tgd$1@svr7.m-online.net...
> Tell me one reason why the .DBF and the .CDX should have a different name!

perhaps, when one doesn't want the index to be structural?

f

On Jun 22, 3:02 am, "Martin" <spams...@spam.spam> wrote:
> I have rebuilt as same name so very puzzled.

Have you tried this:
http://www.ousob.com/ng/ads/ng274d.php
.... more generally
http://www.ousob.com/ng/ads/

I don't know if "5.5" is close enough to your "7.1" to matter...

Best of luck. (I don't use ADS, and never have.)

David A. Smith

Turan

> Tell me one reason why the .DBF and the .CDX should have a different name!

It's up to the developer what he/she names the index.

I'm just pointing out that structural indices must have the same name as the DBF if AutoOpen is to
work for them

--
CYA
Steve