Need Help with Filter Please.

[Mike Buckler]

With advantage and .dbf with .cdx
filt1 = "closesysid = val('"+str(server->sysid)+"') .AND. CAPTURED = .t. .AND. DEBIT = .f."
ADSSetAOF( filt1 , ADS_RESOLVE_IMMEDIATE )
And it works great.
With advantage I made .adt with .adi
The filter no longer works and ADSSetAOF() returns .t.
if I use
set filter to (ckcard->closesysid = server->sysid .AND. CKCARD->CAPTURED .AND. ! CKCARD->DEBIT)
It works.
My Questions Is.
Does set filter to ??? execute as fast with .adt &.adi files.
If Not.
Anybody know what I have wrong in the above ADSSetAOF()
Thanks in Advance.
Mike

[Mike Buckler]

The problem was I made a program that
1) Created an adt file from and existing file.
2) Set the encryption on the file.
3) Indexed the file
4) Appended the old data
Then none of the filters would work.
The problem was-
You must create the adt file, create the index then encrypt the file.
Do not encrypt the file prior to indexing or your filters go crazy.
Hope this helps others.