how to use complex index with dbase table

[N/A]

hello, i need help !

i use a dbase table with 3 float fields
and two of them together makes a record unique.
how to build a unique index based these two fields (with database desktop or from code)
how to find record in this table with locate - or any other - method

regards,
Tom

[N/A]

When you setting up the indexes of this table , you can choose that the indexed field be unique, there is a option there. I use it all the time, when you try to duplicate a record it won't be succesfull.. as for the locate function it's easy : Locate('searchtext',Table['field'],[loCaseInsensitive])

Neeltampa@hotmail.com