| Author |
Structural indexes
|
|
| Martin 2007-06-21, 9:55 pm |
| 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
| |
|
| 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/se...e/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/P...3c/ng3f081.html
David A. Smith
| |
| Stephen Quinn 2007-06-21, 9:55 pm |
| 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
| |
| Stephen Quinn 2007-06-21, 9:55 pm |
| 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
| |
| Martin 2007-06-22, 7:55 am |
| I have rebuilt as same name so very puzzled.
| |
| Turan Fettahoglu 2007-06-22, 7:55 am |
| > 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!
| |
| frank van nuffel 2007-06-22, 7:55 am |
| "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
| |
| Stephen Quinn 2007-06-23, 3:55 am |
| 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
| |
|
|
|
|
|
|
|
|
dam-hussein-execution.org/life-of-