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 2James
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