Subject Re: [firebird-support] Get the value of generated primary key after an insert
Author Radu Sky
Post date 2006-05-20T20:42:53Z
Adriano wrote:
> Hi,
> as read on FB faq i use:
> Dim GEN_ID As Integer
> query = "SELECT GEN_ID(GEN_PRATICHE_IDPRATICA, 1) AS MyVar FROM RDB$DATABASE"
> cn.Execute query
> MsgBox GEN_ID
>

Shouldn't be MsgBox MyVar ?
Just a shot in the dark...

Radu