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
