| Subject | Re: [firebird-support] Get the value of generated primary key after an insert |
|---|---|
| Author | Adriano |
| Post date | 2006-05-20T20:55:50Z |
Hi Radu & Aage,
query = "SELECT GEN_ID(GEN_PRATICHE_IDPRATICA, 1) as MYVAR FROM RDB$DATABASE;"
cn.Execute query
MsgBox Myvar
Returns Always 0
It's darker than before ..
Some more light ?
Thanks
Adriano
>Shouldn't be MsgBox MyVar ?Dim MyVar as Integer
>Just a shot in the dark...
query = "SELECT GEN_ID(GEN_PRATICHE_IDPRATICA, 1) as MYVAR FROM RDB$DATABASE;"
cn.Execute query
MsgBox Myvar
Returns Always 0
It's darker than before ..
Some more light ?
Thanks
Adriano