Rev 2.7 Bug (Crash)

[Brian K. Maher]

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