Text search in .dbf file

[sameer developer]

Hi there, I am developing an application where I need to search the plain text in .dbf file can you help me for this ?

Thanks,
SS

[Tower]

Maybe you can use ADO Recordset. This is small example

set rec = new ADODB.Recordset
rec.Open ..connection string..
rec.MoveFirst
rec.Find "Field1 = ' " & MySeekString & " ' "




After this code Recordset rec focus on needed row.

[sameer developer]

Thanks Tower,
It works,
The only thing is create a dsn file with foxpro driver as flat format and then we can consider it as an object like table, it works.

SS.