dbase and indices [SOLVED]

[timcs]

no.  I want you to index on two fields that are string types without any type casting using the plus sign.  It looks like you have two issues right now.
1. building an index with two or more fields
2. building an index using a date field

Yes, you want them all together, but let's at least isolate the two issues.  If you can build the index with two string fields, then we are hald way home.

In that case I can test two fields in the database that are string and set these with the plus sign and then I could try and create a further index just with the date field and see what happens

[Knipfty]

Yes!  Exactly!

[timcs]

Yes!  Exactly!

Okay, I have been able to create an index using two string fields and the plus symbol, I have then tried to create a separate index using the date field and as expected it errors stating the field must be string or float. So the question is, how to create an index with a date field !

[TurboRascal]

Tdbf is actually well documented: http://sourceforge.net/projects/tdbf/files/TDbf%20documentation/TDbf%20documentation%201.1/

There is also a nice demo: http://sourceforge.net/projects/tdbf/files/TDbf%20Demo%20App/

So far I've been able to find everything I needed there. If something happens to be unclear, there is always the source at hand.

[timcs]

Tdbf is actually well documented: http://sourceforge.net/projects/tdbf/files/TDbf%20documentation/TDbf%20documentation%201.1/

There is also a nice demo: http://sourceforge.net/projects/tdbf/files/TDbf%20Demo%20App/

So far I've been able to find everything I needed there. If something happens to be unclear, there is always the source at hand.

Thanks for this TurboPascal - I will read these and hopefully get this  working!

[timcs]

I think one of the first answers here was the answer but I didn't use the DTOS function correctly. so I can do this:

Code: [Select]

   dbf1.Active:=false;
   dbf1.Exclusive:=true;
   dbf1.Open;
   dbf1.AddIndex('custdate','field1+'+'DTOS(datefield)',[ixCaseInsensitive]);
   dbf1.Close;
   dbf1.Exclusive:=false;
   dbf1.Active:=true;     

This appears to work now, thanks for everyone's help here