Hi I am trying to update my users to 7,6 and I thought I would Unload Data for Table Using ..... for all the data tables then load them into a blank 7.6 DB. Some of my users haven't updated my app for years and and I thought this would be a good way to make sure they had the exact same structure I had. I have dozens of out of state users.
I did not get any errors but to double check the data I did a Unload All on the original DB and the new 7.6 DB after I loaded the data. Then I compared the 2 files to see if the data matched and it did Not? In the first example you can see the 2 was changed to a 3... very strange. In the second example, don't worry I changed the name and numbers with fake data But you can see on the second line a -0- was replaced with a SS number from the first line You can see that they have "dell" for the name so I wonder if that is the problem. Also I noticed sometimes they have\ Smith, Jr in the last name on some customers but sometimes there is no strange " or , in the data and the data after the load is different. This makes me real nervous about sending out my update. neb',-0-,'244999999','3','N','N','N','IN',0,'Same','1','318 Valley Stream+ --- original file neb',-0-,'344999999','3','N','N','N','IN',0,'Same','1','318 Valley Stream+ -- after Load 9444',-0-,11/12/1967,'Y','243089000','F','5','M','L','1','Sam O''dell',+ --- original file -0-,-0-,'3','N','Y','N','IN',0,'Eddie, Kryan','2','3400 Fixcraft Road','Char+ 9444',-0-,11/12/1967,'Y','243089000','F','5','M','L','1','Sam O''dell',+ --- after Load -0-,'243089000','3','N','Y','N','IN',0,'Eddie, Kryan','2','3400 Fixcraft Roa+ Any suggestions? Marc

