Mike, Does your table have any computed columns? If so then you need to NOT unload the computed column and then make sure your load has the proper sequence of columns.
Jan -----Original Message----- From: "Mike Dunn" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 13 Jul 2009 08:55:24 -0700 Subject: [RBASE-L] - PROM UNLOAD and LOAD commands This may take somebody with a grey beard, like me, I'm working in Rbase 4.5. Had a major hardware (and software) crash simultaneously four months ago and before I realized that the software had crashed too, I managed to corrupt all recent data backups so I had to revert to restoring with an older one. Temporary computer that was restored with the old backup and on which all recent entries have been made is WIN 98, new is XP Pro (destination) if that makes any difference. Both computers have the identical Data Base except the new is missing all data from 03/01/2009 onward. Attempting to do a PROM UNLOAD and then a PROM LOAD (ASCII) of five data tables from one computer to the other. Have executed the UNLOAD commands successfully within the old computer and transferred them to a Zip Disc for transport. When loading them in to the new computer, the first four load just fine and are usable however, the fifth (and last) one doesn't load and yields the following error message (twice if that means anything) "WARNING COLUMN ID WILL BE TRUNCATED" (column "ID" is one of the columns within the table). These are very small tables, 1KB, 6KB, 10KB, 13KB, 37KB, 39KB. The troublesome one is the largest. Suspecting that I made some type of error when unloading the fifth one, (such as somehow changing the sequence of the columns), i repeated the unload and load with exactly the same result. Anybody have any ideas what should I be looking for in terms of the cause of this error message? Mike
