Board index » delphi » BDE Bug: TQuery Master/Detail not working for MSSQL 7 SQLLinks driver

BDE Bug: TQuery Master/Detail not working for MSSQL 7 SQLLinks driver

When using the SQLLinks MSSQL 7 driver (new 5.01), a TQuery Master/detail
relationship will give an error "Connection is in use by another statement"
when the second TQuery opens.  This problem can be duplicated using the pubs
database that comes with SQL 7.

Drop 2 TQueries and a datasource on a form, with your TDatabase that is
connected to a MSSQL alias pointing to the pubs database.

set:
Query1.SQL = 'SELECT * from authors'
Query2.SQL = 'SELECT * FROM titleauthor where au_id = :au_id'
Datasource1.Dataset = Query1
Query2.Datasource = Datasource1

Open Query1
Open Query2 -- BOOM...That's where the exception is raised.

(This can all be done in the IDE)
With a ODBC alias this will work.  This only seems to occur with the new
MSSQL for SQL7.

Help.  Any work arounds??

Thanks.

 

Re:BDE Bug: TQuery Master/Detail not working for MSSQL 7 SQLLinks driver


Hi Matt!

On Mon, 28 Jun 1999 15:12:04 -0700, "Matt Peebles"

Quote
<m...@collinscomputing.com> wrote:
>When using the SQLLinks MSSQL 7 driver (new 5.01), a TQuery Master/detail
>relationship will give an error "Connection is in use by another statement"

The same exception raises with MS SQL 6.5 if in your alias you have
"SQLPASSTHRU MODE" = "NOT SHARED", so change that parameter in BDE.

tomi.

Other Threads