• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

Find Record

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
faizsnell
Asked:
faizsnell
  • 2
1 Solution
 
esoftbgCommented:
 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
 
esoftbgCommented:
an example with ADOQuery and access database:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21082313.zip
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now