Hi!
I found the mistake myself:
In my script is the code
handleRevDBerror tTmp
if the result is not empty then
answer warning the result
end if
but I forgot the handler:
on handleRevDBerror p
switch
case item 1 of p is "revdberr"
return "revDB Error: " & p
break
case "syntax error" is in p
return "Database Error: " & p
break
end switch
end handleRevDBerror
The result wasn't empty, but Revolution did not know what to do.
Thanks
Reinhold
I store text (Karten_Daten) and images in two different tables of a
SQLite-Database.
I need the ID of the last stored record of the text to allocate the
images.
Therefore I use "SELECT MAX(KartenID) FROM Karten_Daten"
Somethimes I get a number, the ID, but sometimes I get "false".
I tested a lot of code and then I found this strange thing:
When send the following code twice on after another to my database I
got different answers:
put "SELECT MAX(KartenID) FROM Karten_Daten" into tSQL
put revdb_querylist(,,gConID,tSQL) into tlastCDimp1
answer tlastCDimp1
put "SELECT MAX(KartenID) FROM Karten_Daten" into tSQL
put revdb_querylist(,,gConID,tSQL) into tlastCDimp2
answer tlastCDimp2
in the first case tlastCDimp contains a number, but in the second
time tlastCDimp: "false"
The most strange experience is, that among the hundreds of test I
made, there had been about two or three where tLastCDimp shows a
number in both cases. :-(
I do not understand it!
Reinhold
PS: I use a Mac with Snow Leopard. Do this has any influence?
_______________________________________________
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
