FiveTech Support Forums

To All

I see Silvo ( seems ) to have a similar problem ...

What is the tDatabase equivalence of :

oDbf:SetOrder( "CustID" ) // understand this already

Set order to tag CustID
Seek cCustID // <----- here

oDbf:Seek cCustID ??

oDBf:GoTop()
oDBf:Find cCustID ??

I would rather use Seek than set a filter .....
Seek in traditional DBFCDX is much faster than using the Find command ..

Thanks

Rick Lipkin

oDbf:Seek( cCustID )

Rao .. thanks

Rick Lipkin

Rick,

You can always look at the source code for TDatabase (xbrowse.prg) to find all the method names and their passed parameters.

James

Thanks .. been using ADO on Sql Databases for years ... the reason I am using DBFCDX is I have a substantial contract to encrypt one of my Billing Apps for SC State gov that uses a MS Access backend ..

In order to create new and existing Invoices .. I have to ( on the fly ) dencrypt the Customer table .. and to do that I am creating a temp .dbf table on the local hard drive .. Since I mixing ADO and DBFCDX .. I pass the table object's between various modules and traditional .dbf syntax just would not work .. hence my interest in tDatabase.

Also ... migrating the application to Sql Server which is much more secure than ms access since Access is a local database that resides on the local un-secure file server.

Thanks

Rick Lipkin