how to index records deleted?

[JAOS]

Hello everyone!
How I can create a normal or production index for deleted records of lianja table?
I tried this:
index on deleted() to adu_del
index on deleted() tag adu_del
but in both cases I get error:
"Datatype not supported in index expressions"
Thank you for your help.
JAOS

[davefoss]

Indexing on a logical is not allowed for performance reasons. What are you trying to accomplish?

[davefoss]

By the way, if you really need to build the index you can convert the logical to a string, but we don't recommend it unless there's really no other way around it.

[JAOS]

In VFP I have no problem to create this index, but well, take your advice and will look for another way.
Thank you so much, Dave.

[barrymavin]

Try this.

index on etos(deleted()) to adu_del

[HankFay]

I think Jaos may be trying to solve an issue that exists in VFP indexing (where failure to have an index on deleted() can in certain circumstances lead to non-optimized queries: http://msdn.microsoft.com/en-US/libr...(v=vs.80).aspx

Hank

[JAOS]

indeed, Hank, that's what I'm looking for. Thanks for refer to the MSDN help

[HankFay]

Hi Jaos,

And I don't know whether that's an issue for Lianja queries. This issue had to do with Rushmore, and from what I remember, Lianja does it differently.

Hank