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]] 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
