Karen I would also suggest doing a PACK on the 7.6 database after the reload and before unloading. It has been a while since I had the same problem. I went in and manually removed the SIZE nn from date and integer fields. I never did figure it out why this happened.
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, December 04, 2013 12:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Question about an unload Buddy: The database autochecked and reloaded fine before the unload. And yes, I always do an "unload schema" and "unload data" into separate files, then I split the schema file to do just the table/view creation first. Tracing through the constraint/index file is what enabled me to find the cause of the error. There were "sizes" for dates, integers and text indexes. But not for all of them. Karen -----Original Message----- From: Buddy Walker <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Dec 4, 2013 11:34 am Subject: [RBASE-L] - RE: Question about an unload Karen Before unloading 7.6 database I would suggest reloading and packing. I’m assuming RecDate is a date field and if so the size 1 is saying only index 1 character. The “SIZE” normally only applies to text fields. Since when unloading all index commands are in same area of the file (normally towards the end). I would cut that out of the file and save it separately. Buddy From: [email protected] [mailto:[email protected] <mailto:[email protected]?> ] On Behalf Of Karen Tellef Sent: Wednesday, December 04, 2013 12:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Question about an unload Tomorrow I'll be upgrading a client from 7.6 to 9.5. I'm testing an "unload all" on their database in preparation. I got an error because on several (but not all) of the "create index" commands there was something like this: CREATE INDEX RecDate ON `Recpts` (`RecDate` ASC SIZE 1 ) The "size 1" (there are other sizes on other indexes) produce errors in 9.5. Simple fix, I just erased all the sizes in my unload command. But I'm just curious what made those sizes go in there since I don't remember ever specifying an index "size" at any point. Do those sizes go back to DOS days when someone else had originally created this database? Karen
