[Gambas-user] MySQL last_insert_id value

[Keith Clark]

How would I get the MySQL last_insert_id() value into an integer 
variable inside gambas?

I tried with

CurrentID=db.exec("select last_insert_id() as last")

but I get a type mismatch error.  Expecting integer, got result.

Thanks,

Keith