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.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
