Board index » delphi » Problems with SQL 7 & Delphi SQL Links

Yiannis Alexopoulo

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Problems with SQL 7 & Delphi SQL Links

we have two queries for selecting data from a database (either on the same

table or on different tables does not change anything). When you execute the

first query fetches his results but when you execute the second query

fetches the first query results and then the second one.

Any suggestions

Thanks

 
Steve Koters

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problems with SQL 7 & Delphi SQL Links


On Wed, 14 Jul 1999 14:04:51 +0300, "Yiannis Alexopoulos"

Quote
<yiann...@microsoft.com> wrote:
>we have two queries for selecting data from a database (either on the same
>table or on different tables does not change anything). When you execute the
>first query fetches his results but when you execute the second query
>fetches the first query results and then the second one.

Um ... you include far too little information for anyone to be of much
help.

Are you using the same TQuery for both SQL statements? If so, are you
programmatically changing the SQL? If so, are you properly clearing out the
SQL statement in the TQuery before adding the new statement? How are you
putting the statements into the TQuery?

What programing tool are you using? Given the newsgroup, I would assume
Delphi. Version?

How is the database being accessed? With the BDE native SQL Links driver,
an ODBC driver, ADO, some third-party database engine, or ... ? If the BDE
is involved, what version are you using?

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski         "Television is a medium because anything well done
Felton, CA             is rare."
                                                 -- Fred Allen (1894-1956)

Other Threads

1. MS SQL Server 6.5/Delphi 1/SQL Links/Batch Move Problems

2. MS SQL Server/Delphi 1/SQL Links/Batch Move Problems

3. Sql Anywhere & Sql Links

4. SQL Links problem with MS SQL Server

5. Problem with SQL Links / SQL Server - datetime format

6. Sybase SQL Anywhere, SQL Links and Delphi 2.0

7. Connecting Delphi to SQL Server with SQL Links from BC4.51

8. Delphi 2.0 & SQL*Links

9. SQL Links for MSSQL & Delphi 5

10. DELPHI/BDE/SQL Links Service Application Problem