Hi,

> table1
> id
> -----
> 100
>
> table2
> id
> -----
> 23
>
>
> ...
> ..
>
> Generators
> gen_table1_id = 0
> gen_table2_id = 0
>
> i want to set all generator values from table id's.

Use the SET GENERATOR statement. You have to figure out the ID
numbers by yourself though, as a "generator" by itself has nothing to do
with a "table".

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com