TDatabase Seek

[Rick Lipkin]

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

[nageswaragunupudi]

oDbf:Seek( cCustID )

[Rick Lipkin]

Rao .. thanks

Rick Lipkin

[karinha]

https://wiki.fivetechsoft.com/doku.php?id=fivewin_class_tdatabase

Regards.

[James Bott]

Rick,

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

[James Bott]

Rick,

Since you seem to be new to using OOP, may I recommend by two articles on OOP. They are somewhat dated since I wrote them 10 years ago, but still helpful to someone just getting started with OOP.

Introduction to Object-Oriented Programming Part 1 & Part 2

James

[Rick Lipkin]

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