Solved

Find Record

Posted on 2004-08-04
2
149 Views
Last Modified: 2010-04-05
I Need Help again, I am still busy with my program, I have  DBEdit boxes for   adding customer details.this get uploaded to the ADOTable. But when the customer arrives back into  our workshop I don’t want to create a  new record I just want to edit the existing record,by just for example putting in the reg no of the vehicle and then the rest of the details must appear in the other Edit boxes Please could somebody help me with some samples code .I am Using ADO and D7
0
Comment
Question by:faizsnell
  • 2
2 Comments
 
LVL 12

Expert Comment

by:esoftbg
ID: 11719008
 VEHICLE_NUM is the filed into the database,
  Edit_Vehicle_Num is an TEdit component containing searched vehicle num:

  ADOTable.Locate('VEHICLE_NUM', Edit_Vehicle_Num.Text, [loCaseInsensitive, loPartialKey]);
0
 
LVL 12

Accepted Solution

by:
esoftbg earned 250 total points
ID: 11720867
an example with ADOQuery and access database:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21082313.zip
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Virtualstringtree carsh after invalidate for while 5 87
Thread safe  opinion 7 126
oracle global variables 4 63
When i run adoquery my application freezes 26 152
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now