Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timeout on requery views
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Timeout on requery views
Miscellaneous
Thread ID:
00149473
Message ID:
00149473
Views:
52
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
Renato Bertuol (EMail:renato.bertuol@elmec.it
Homepage:www.geocities.com/SiliconValley/Horizon/3216)
Elmec Informatica (URL www.elmec.it)
Reply
Map
View

Click here to load this message in the networking platform