[Gambas-user] mysql last_insert_id

[Bill-Lancaster]

I have a table (editprojects) with "id" as primary key, serial, integer.
There is only one record at the moment (id = 1)
     hResult = hConn.Exec("SELECT last_insert_id() as id FROM editprojects")
print hResult!id
produces 0 not 1

Obviously my sql query is at fault but where?

I wonder if anyone can help.
-- 
View this message in context: http://old.nabble.com/mysql--last_insert_id-tp34173030p34173030.html
Sent from the gambas-user mailing list archive at Nabble.com.