Alternatively, push it up a level - to it at the application layer, rather
than the DB layer:

Nige

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Alan McDonald
Sent: Tuesday, 7 November 2006 5:16 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Problem calling set generator...

> Hi, (This is Firebird 1.5.3)
> I have an 'empty' database with a 'prefs' table which has a pk
> 'prefs_sn', and a generator 'gen_prefs' which is initially set to 1.
> I have a routine which copies all rows of the prefs table from one DB
> into another (ALL columns, including the pk's).

a better idea is to NOT include the PK field in the copy process. The PK
will be re-generated - no need to fiddle any more
Alan

>Recent Activity

16New Members
Visit Your Group
SPONSORED LINKS
Computer telephony
Portable computer
Technical support software
Technical support
Computer telephony integration
New web site?
Drive traffic now.
Get your business
on Yahoo! search.
Sell Online
Yahoo! e-commerce
comes with 24 hour
phone support.
In Year 2020
Where Will You Be?
The Yahoo! Time
Capsule Project.


__________ NOD32 1.1856 (20061106) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com