?
Solved

Find Record

Posted on 2004-08-04
2
Medium Priority
?
154 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 total points
ID: 11720867
an example with ADOQuery and access database:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21082313.zip
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month13 days, 4 hours left to enroll

777 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