Thanks for all the help. I realized afterwards that what I needed to do was change the table col names to existing col names in my destination table so it would truncate the info. That will work. Your explanation of the APPEND and INSERT functions helped me 'get it right'.
Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, March 13, 2009 10:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: append table At 10:49 AM 3/13/2009, Jim Belisle wrote: >I was able to append the information from three tables into >one table. I noticed however that some of the information >from the columns did not append properly. If the destination >col is not wide enough for the appended info, does it not >append at all? Is there a setting that would truncate it so >at least most of it gets into the table? You need to compare the actual tables, matching column names, and data types. If the column name and data types are exactly the same, you should NOT be missing or end up with a truncated values when using the APPEND command. Very Best R:egards, Razzak.
