Data Generator and Sequences

[TenGor]

Hy,

i like the Data Generator very much, but i had a little suggestion:

i know that i can use the fuction Sequence.
But there is no possibility to use a DB-Sequence.
So if i use the "Data Generator Sequence" my sequence for the table is on the false id.
When i insert some test data by hand i get an error because the PK is already in there...

Ok, i can update the DB-Sequece by hand too, but it would by very nice just using it within Data Generator.

 

[aotte]

That would be a very nice feature indeed!

 

[Marco Kalter]

We'll add a SQL function. You can add any valid SQL expression here, including sequence.nextval.

 

[TenGor]

@marco

this is brilliant ;-))