OUTPUT myfile.all UNLOAD ALL FOR mytable OUTPUT SCREEN This will output the entire table structure and data. Be advised there is a line that I normally need to remove before inputting into the new database because you get a second version of the old database with one table.
It's located about 12 lines down in the file you just created CREATE SCHEMA AUTHOR mydatabase PUBLIC rem that line out and you should be good to go. Jan -----Original Message----- From: DAVID <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 18 Jul 2008 14:08:30 -0400 Subject: [RBASE-L] - RE: COPY TABLE BILL, I ALSO HAVE WINDOWS VERSION 7.1 CAN I COPY THIS TABLE IN THAT WITH LESS HASSLE THANKS, DAVE On 7/18/08, Bill Eyring <[EMAIL PROTECTED]> wrote: > Dave, > > In version 6.5 you have to unload structure and data separately. > Here's how; > > Make sure that there is no table name in the target database with the same > name of the table you want to move over. > > You need to create 2 files, 1 for the structure and 1 for the data. > > From the R:>Prompt for the source database; > > Out TBLNAME.STR > Unload structure for TBLNAME > Out Screen > > Out TBLNAME.DAT > Unload data from TBLNAME using all > Out screen > > Edit the TBLNAME.STR file and take out the following lines; > 1. the line that says DISCONNECT > 2. the line that says SET STATICDB OFF (leave in if the target database > hase staticdb ON) > 3. the line that says SET ROWLOCKS ON > 4. the line that starts with "Create Schema" and save the file. > > > Copy the 2 files to your target database directory. > > Connect the target database > > Make sure that the character settings in the TBLNAME.STR file matches the > character settings in the target database. > > Make sure you are the only user connected to the target database. > > At the R>prompt type in INPUT TBLENAME.STR [Enter] > At the R>prompt type in INPUT TBLENAME.DAT [Enter] > > When finished I suggest you reload the database and then do an autochk full. > > > Help that helps. > > Bill Eyring > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID > Sent: Friday, July 18, 2008 10:37 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - COPY TABLE > > I HAVE FORGOTTEN HOW TO COPY A TABLE FROM 1 DATABASE TO ANOTHER I AM USING > RB 6.5++ FOR DOS > > DAVE > > >
