Hi,
I have tried the code below but I still get connection busy on line delete for
Can you help ?
Thanks
SELECT SELECT(1)
USE Jwiplab
=CURSORSETPROP('FetchSize',-1)
GO TOP
DELETE FOR job = curjob
=TABLEUPDATE(.t.,.t.)
>Xavier,
>
>ODBC only allows one command to execute at a time over a single connection. If you're using views and you have the FetchSize for the view set to anything other than -1 you can get into a situation where one view is not done requerying when you try to requery or update another view. The easiest thing to do is to just set the FetchSize for each view to -1.
>
>>Hi there,
>>
>>I am using ODBC to SQL Server to update a few tables. When i run my update prog. I get this error message after a while connection ... is busy. What does it mean and how can I avoid that.
>>
>>Many thanks
>>
>>Xavier
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement