I use Paradox table in my program, and I use SQL to do searches.
Problem is this:
Who can i sort the table and query results in DBGrid by one or more fields?
When I try to set the IndexFields, I get error 'no index file for field XXX'
My original table has no index fields set, and even if I set the index property in Database Desktop and move all data to this new table with the index fields set, it won't work.
How do i create these index files etc. ?
SQL line 'ORDER BY <field>' gives the same error message. So there is a problems with the index files..
Help me !