This is one of the weirdest things I've ever seen. Whenever I try to validate a Db operation the whole thing crashes. As a compiled exe it crashes every time; as code in the IDE it crashes only sometimes (by that I mean some of them validate every time and some of them crash every time). Example:
This crashes...
...
put "UPDATE hardware SET make = '" & tvMake & "', model = '" & tvModel & "', nickname = '" & tvNick & \
"', os = '" & tvOS & "', svcTagSerial = '" & tvTag & "', specLink = '" & tvSpec & "', suptLink = '" & tvSupp & \
"' WHERE idhardware = '" & tvHdwID & "' AND Indeks = '" & tvClientID & "';" into tvSQL
revExecuteSQL gvConnectionID, tvSQL
if the result is a number then
answer info "Record Updated"
else
answer error "Something went wrong." & cr & the result
end if
cmdClearAll
cmdReadyList
cmdPlaceList
end mouseUp
This does not...
I've also tried reversing the check so "if the result is not a number then"...
put "UPDATE hardware SET make = '" & tvMake & "', model = '" & tvModel & "', nickname = '" & tvNick & \
"', os = '" & tvOS & "', svcTagSerial = '" & tvTag & "', specLink = '" & tvSpec & "', suptLink = '" & tvSupp & \
"' WHERE idhardware = '" & tvHdwID & "' AND Indeks = '" & tvClientID & "';" into tvSQL
revExecuteSQL gvConnectionID, tvSQL
cmdClearAll
cmdReadyList
cmdPlaceList
end mouseUp
I've tried "if the result is 1 then"
No matter if it crashes or it doesn't it still does the Db operation just fine. This is happening with SELECT, INSERT INTO, UPDATE, you name it. But if I validate the operation the application crashes with no error message.
Finally... this is new behavior. The app didn't used to do this. So it's something I've done.