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
>
> Why the GEN_ID is always 0 ?
> It should be a very 'silly, elementary' question...
>

Where do you assign the value (of MyVar) to the GEN_ID variable?


--
Aage J.