On Tue, 2012-07-17 at 04:14 -0700, Bill-Lancaster wrote: > 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. Bill, AFAIK in mysql last_insert_id is session and connection based, from the limited info you give, it looks like you are trying to get the last insert id outside a session or connection. If so you could try "SELECT MAX(id) as last_insert_id FROM editprojects". If not, then a short trip down the web history of this totally bungled concept from mysql....
Bruce ------------------------------------------------------------------------------ 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