Why not add the new columns to the old database, that's the way I have done it Tom Hart
On Aug 13, 2017 9:55 AM, "karentellef via RBASE-L" <[email protected]> wrote: > I think what I'd do is project a temporary table, do the "unload all / > noschema" on the temp table, run the file in the new database, and then > append to the permanent table > > Karen > > > > -----Original Message----- > From: Buddy Walker <[email protected]> > To: rbase-l <[email protected]> > Sent: Sat, Aug 12, 2017 8:08 pm > Subject: RE: [RBASE-L] - Default to FILL for UNLOAD DATA > > Larry > Maybe I’m missing the point but why not > > LOAD table FROM filename USI columnListHere > > Just make sure to exclude computed/autonum and any new columns. > > Buddy > > > *From:* 'Lawrence Lustig' via RBASE-L [mailto:[email protected] > <[email protected]?>] > *Sent:* Saturday, August 12, 2017 12:26 PM > *To:* [email protected] > *Subject:* [RBASE-L] - Default to FILL for UNLOAD DATA > > I'm trying to migrate a database which involves doing UNLOAD DATA from the > load database and running the resulting files into a new database. > > In some tables, the new database tables have a few fields added at the end > of the table. R:Base is refusing to load these tables because, when the > unloaded files are created, they do not include the FILL statement to > populate "extra" columns on the LOAD. > > Is there a way to either: > > 1. Tell R:Base to include FILL in the UNLOAD DATA command OR > 2. Tell R:Base that, when processing a LOAD command, if neither FILL > or NOFILL is specified the default should be FILL instead of NOFILL? > > > -- > Larry > > -- > For group guidelines, visit http://www.rbase.com/support/ > usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- > For group guidelines, visit http://www.rbase.com/support/ > usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > > -- > For group guidelines, visit http://www.rbase.com/support/ > usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
