Solved

Find Record

Posted on 2004-08-04
2
150 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

803 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