Xailer & OZ Software

[Solved it!]
Strangely enough does the lAutoOrder not working any more with ADS. When I switch back to TCdxDataSource it is working again, go back to TAdsDataSource it stops working?
Ow, it is still working for 2 tables, but for the rest not?
Someone any idea?
[edit]
If I zap the database, it works again.
If I try to re-index with ADA, I get the following message:
Encryption is not enabled.
Mhhh... probably something from my .add testing?
Problem solved.

Maarten,

The lAutoOrder feature is done generating a temporary index file on the table, so is supposed to be used only with the table data fields. In case you need to order by any other field I suggest the following:
1) Retrieve the data using a SQL expression on ADS using the ORDER clause.
2) Use a TMemDataset data control
3) Move the data to un array and use a tArrayBrowse control
Options 2 and 3 should be used only if you are not retrieving thousands of records.
Best regards,