Board index » delphi » MS SQL Server and Transactions

MS SQL Server and Transactions

Quote
"Jonny Gibson" <nisof...@singnet.com.sg> wrote in message

news:8nvr4i$s0h$1@coco.singnet.com.sg...

Quote
> the problem seems to manifest it self when opening a query which returns
no
> records - it hangs indefinitely

Just guessing, could it be that you should use exec instead of open on the
query in question?

Svein

 

Re:MS SQL Server and Transactions


Hi

I'm having a bit of a problem.. it seems that StartTransaction doesn't work
properly with MSSQL - its was working ok with Oracle - but seems to hang
with MSSQL.

Does any one have any ideas, or come across this before.

the problem seems to manifest it self when opening a query which returns no
records - it hangs indefinitely

regards

jg

--
--------------------
Jonny Gibson
Software Engineer

NiSoft (UK) Ltd
46 East Coast Road
#04-05 East Gate
Singapore 428766

T: +65 3488985
F: +65 3480691
E: nisof...@singnet.com.sg
I: www.nisoft.com

Other Threads