| Author | Thread |
|
|
06/10/2007 06:13:11 PM · #1 |
Run into something i have never done before. I think it would be easier for me todo in SQL because I know how todo a query to come up with one result.
Im programming in object pascal doesnt really matter, but id like todo this with a Paradox database i might use local SQL.
Basically what i need todo
4 drop down combo's Year Make Model Engine. When all 4 are selected it pulls "Data Card" and displays it. ALl it really is is information stored into the database.
Im not sure the general method for storing data to be retrieved with only 1 matching record. The only thing i can think of is to have all 4 combos add up to a reference number and the database stores the reference number int he first coloumn of the row of data. |
|
|
|
06/10/2007 07:07:03 PM · #2 |
I'm not sure I completely understand your question but if you're trying to retrieve a recordset from a table based on certain fields having certain values, the simplest query would look like;
SELECT * FROM
WHERE = , = , ...
I don't know about the SQL flavor Paradox uses, but it shouldn't be significantly different, if at all, to T-SQL. |
|
|
|
06/10/2007 07:13:26 PM · #3 |
Alright thanks the SQL Query you wrote out ive never tried before or seen. But it makes sense to me.
Ive never done any SQL work in Object Pascal. But i have in PHP so i have knowledge on both sides.
Cool thanks. |
|
|
|
06/10/2007 07:50:30 PM · #4 |
Originally posted by Tycho:
I'm not sure I completely understand your question but if you're trying to retrieve a recordset from a table based on certain fields having certain values, the simplest query would look like;
SELECT * FROM
WHERE = , = , ...
I don't know about the SQL flavor Paradox uses, but it shouldn't be significantly different, if at all, to T-SQL. |
I shouldn't open my mouth after midnight when my brain stops functioning. Query should read;
SELECT * FROM
WHERE = AND = AND ... |
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 09/14/2025 11:38:38 AM EDT.
