Re: [Gambas-user] MySQL last_insert_id value

2012-01-20 Thread tobias
On 20.01.2012 23:46, Keith Clark wrote: > On 12-01-20 05:14 PM, tobias wrote: >> hi, >> >>> 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 mismatc

Re: [Gambas-user] MySQL last_insert_id value

2012-01-20 Thread Keith Clark
On 12-01-20 05:14 PM, tobias wrote: > hi, > >> 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. >> >> Thank

Re: [Gambas-user] MySQL last_insert_id value

2012-01-20 Thread tobias
hi, > 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 > i suppose CurrentID is an integer

[Gambas-user] MySQL last_insert_id value

2012-01-20 Thread 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 -