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

Reply via email to