Hi to all,
I've a remote view based on a Oracle SELECT ... FOR UPDATE statement,
before to requery my view for a record, I've locked that record by SELECT ... FOR UPDATE on the server (it's Oracle8)... I think there isn't a timeout value, my view waits & waits forever until I commit or rollback the record on the server.
I've tried to set the view timeout before to requery using these commands :
LOCAL lnConnectHandle
lnConnectHandle = CURSORGETPROP('ConnectHandle', (THIS.xcCursorName))
SQLSETPROP(lnConnectHandle, 'QueryTimeOut', 10)
=REQUERY( THIS.xcCursorName)
but it doesn't works, wait forever too.
What can I do ?
TIA
Renato