Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Very simple database problem

Posted on 1998-04-16
2
Medium Priority
?
164 Views
Last Modified: 2010-04-06
When I have a TQuery object with one parameter, how can I use one Field of a record in a TTable as the parameter for this?  I mean, when a TDBGrid's selected record changes, one of the fields of that record has to be passed as parameter to this TQuery object.

Thanks
0
Comment
Question by:Odie
2 Comments
 
LVL 3

Accepted Solution

by:
KE earned 200 total points
ID: 1361614
Set the DataSource property of your query to point at the DataSource for your table.
Write the query SQL like this:
SELECT XXX FROM MYTABLE WHERE XXX=:FIELDNAMEOFTHETABLE

0
 
LVL 1

Author Comment

by:Odie
ID: 1361615
Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

971 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