Clarion - How to detect a SQL record lock?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to detect a SQL record lock?

peter.wensink@loparex.com

2006-06-17, 7:56 am

Hi All,

On this moment we have a VB program which locked a record from an
SQL-table,
in my Clarion (V5.5) i like to detect if this record has been locked, i
am
using this SQL-table by ODBC.

It seems that executing the GET (locked record) statement keeps waiting
until this records has been unlocked, when i use this same technique
with
TPS-files then it is works fine.

What is wrong using this technique ? Is there somewhere a default wait
timer
for the GET statement to wait ? Are there settings at ODBC level
required ?

Thanks,

Peter.

Sponsored Links