Have you tried using a non PK field as the target and
making a separate field as PK so you wont have
problems on resetting the generator.

Just a suggestion :)

-rocky

--- phil_hhn <time_lord@...> wrote:

> --- In Firebird-Java@yahoogroups.com, Rocky
> Castaneda
> <rockycastaneda@y...> wrote:
> > Sounds like a migration problem to me, if you want
> an
> > easy way to transfer data from legacy tables to
> > interbase, you can use Interbase Data Pump from
> clever
> > components i think its free.
> >
> > HTH,
> >
> > -rocky
>
> I did actually try that for the migration but didn't
> get very far with
> it. The second stage of the migration (where I'm
> having trouble with
> the initial generator values) is actually a
> significant data massaging
> exercise. Infact the data being massaged is in the
> same database in a
> whole lot of temporary tables (of a different
> structure) so that SQL
> can extract data out of them into the nice new
> normalised tables.
> I found IDP didn't offer me much flexibility in
> migrating data from
> one set of tables in the database to a new set of
> tables in the same
> database. It seemed more suited to getting data from
> an entirely
> different datasource (and type of database) and
> inserting it into a
> firebird database. So I wrote my own drag & drop gui
> with lots of nice
> colours ;-) which works with the database metadata,
> etc....
>
> Anyway, the problem isn't with that, it's with the
> initial few records
> inserted before (which have the correct structure of
> the new database)
> that upset the generator which isn't 'aware' that
> records have been
> inserted behind its back.
>
> Phil
>
>
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail