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 use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution