Hi Folks,
I was testing a SQL locking issue and found that the revDataFromQuery function
will cause Rev to crash if the query fails due to a locked record. My ODBC
connection specifies "repeatable read" as the default isolation level in the
ODBC DSN configuration. The code is as follows:
on mouseUp
put revOpenDatabase("ODBC","S2K",,"xyz","xyz") into vDB
try
put revDataFromQuery(,,vDB,"SELECT * FROM PUB.Customer") into vResult
answer (line 1 of vResult)
catch vError
answer vError
end try
revCloseDatabase vDB
answer "Done"
end mouseUp
Cheers, Brian
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
