[Lazarus] Returning value from a Firebird (embedded) generator into Lazarus code

[brian]

Hi folks, 

Can someone please give me a hint with this problem. I'm new to
Firebird, but I needed a database which could be used in embedded
fashion, and seemed to have a choice of one under Linux. 

What I need to do is to return a value generated by a Firebird
generator into my Pascal code. Doing it what seemed to me to be the
obvious way returns zero rows, do I need to update an interim table
and then query that table? Or is there some other method which I've
missed? 

Brian.