Hi,

> My query is how do access this from my application or IbConsole
>
> Using
>
> SELECT ID FROM TESTPROC
>
> activates the procedure and increments the generator but I get null as a
> result.

If you want to use it SELECT-able, then include the
keyword "SUSPEND" to return a row to the procedure
caller.

If not, then use EXECUTE PROCEDURE ... RETURNING_VALUES ...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com