| Subject | Get the value of generated primary key after an insert |
|---|---|
| Author | Adriano |
| Post date | 2006-05-20T18:54:05Z |
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
Why the GEN_ID is always 0 ?
It should be a very 'silly, elementary' question...
Adriano
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
Why the GEN_ID is always 0 ?
It should be a very 'silly, elementary' question...
Adriano