Hi Bhavbhuti,

> Yes I had but ran into issues, see my recent thread
> http://tech.groups.yahoo.com/group/firebird-support/message/100703
>
> Thus, I have reverted to using real table.

Right :-)

Then I'd say, use an ID column which you populate from a generator.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com

> Thanks and regards
> Bhavbhuti
>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...>
> wrote:
>> Ever looked into temporary tables?
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>