Page 1 of 1

TDatabase Seek

Posted: Wed Jun 30, 2021 12:29 pm
by 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

Re: TDatabase Seek

Posted: Wed Jun 30, 2021 2:28 pm
by nageswaragunupudi
oDbf:Seek( cCustID )

Re: TDatabase Seek

Posted: Wed Jun 30, 2021 2:32 pm
by Rick Lipkin
Rao .. thanks

Rick Lipkin

Re: TDatabase Seek

Posted: Wed Jun 30, 2021 2:36 pm
by karinha

Re: TDatabase Seek

Posted: Thu Jul 01, 2021 4:50 pm
by 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.

Re: TDatabase Seek

Posted: Thu Jul 01, 2021 9:16 pm
by 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

Re: TDatabase Seek

Posted: Fri Jul 02, 2021 1:10 pm
by 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