dbfs on Network : wich performance method?

[Silvio.Falconi]

Can you send me the DBF and the CDX to reproduce the problem here, please?

EMG

SENT

[Enrico Maria Giordano]

Ok, thank you. As you can check for yourself, the CDX contains a tag with "id" key. So it's just a corrupted CDX. Please delete it, rebuild it and let me know.

EMG

[Silvio.Falconi]

I erase the cdx.
then I run the test made from James
it create the cdx
then open emagdbu , open customer database
Open the cdx and set the tag id
the same

[Enrico Maria Giordano]

The example from James is not valid for your customer.dbf because it builds the wrong tag:

Code: Select all  Expand view

Index on "id" tag "custno" to customer

Your customer.dbf doesn't have a field named "id".

EMG

[Silvio.Falconi]

yes of cource but...

why the code ( test.prg) compiled create the cdx if is not valid ?
we Know it's is not valid but the exe crete the cdx

[Enrico Maria Giordano]

I don't know, sorry.

EMG

[James Bott]

Sorry if I sent the wrong customer file. It is disconcerting that the CDX was created without any error message. That would be hard to track down as we have just seen.

Silvio, were you able to get the sample to run now?

James

[Silvio.Falconi]

James,

I wanted understand why the command :

Code: Select all  Expand view

Index on "id" tag "custno" to customer

create the cdx and not make error

It seem we can index any field not exist into a dbf ...

[Enrico Maria Giordano]

I just realized that this syntax is uncorrect:

Code: Select all  Expand view

Index on "id" tag "custno" to customer

The correct one is:

Code: Select all  Expand view

Index on id tag "custno" to customer

Or, even better:

Code: Select all  Expand view

Index on FIELD -> id tag "custno" to customer

EMG

[James Bott]

Enrico,

Thanks for finding that.

I did a search of all my source and I did find a couple of other times I used quotes. It would be nice if this generated an error. I must have been going nuts trying to figure out why those indexes weren't working.

Enrico, would this be a (x)Harbour issue. If so, would you mind reporting it?

James

[Enrico Maria Giordano]

This is not a bug. Is perfectly legal to build an index on a constant key:

Code: Select all  Expand view

INDEX ON .T. TO TEST

EMG

[James Bott]

Ok. I am curious of what use that would be?