wiyono wrote:

> sorry many questions,
> if there is a function ROWNUM in oracle (no serial record) if the firebird what functions the same

No, but you can easily get it via EXECUTE BLOCK, or by using this trick
with context variables:

http://www.firebirdfaq.org/faq343

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================