Solved

Find Record

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
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…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

688 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