Thx for the info. But it is multi user and I cannot disable autonum as other things are using it as well.
I wish there was an append nonum option but looks like I will have to unload/load. Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Wednesday, August 19, 2015 12:50 PM To: Dan Goldberg Subject: [RBASE-L] - RE: copy data from table to another table including autonumber Might you: If it isn't a multiuser situation: 1. Disable autonum on the destination table 2. Copy the source data to this destination table 3. Capture the max(autonumbered column) from this updated destination table 4. Re-Enable autonum on the destination table using ( max(autonumbered column) + 1) as the starting value (with NONUM) If it is, I don't know. Bruce Chitiea SafeSectors, Inc. 909.238.9012 mobile From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, August 19, 2015 11:31 AM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - copy data from table to another table including autonumber I want to copy data from one table into another table. The problem is I have one column in the destination that is an autonumber field. I want to put the number from the source table in that autonumber field as I have already captured it using the nextnum function. Other than using unload/load does anybody know a way to achieve this? TIA Dan Goldberg
