Our app has a Reload command block that our offices run about 1x a month. It has been working fine in dozens of offices and mine for a long time.
This office called said it quit working at the place where the Run the Cms.Dat file. Autochk shows No Errors. They sent me the DB and I had the same problem on my computer too. I am not sure if they have the exact version of the below command block but since it failed on my machine too I think it is valid for testing. Even if I did Run Cms.dat and typed in the password by hand it said invalid password So, I unloaded the DB one step at a time at the R>, I didn't use the encryption option, Ran the file to rebuild the DB. Then I ran the same command block below and this time it worked fine. It seems that something did something to something but I do not know where to look or how to prevent it? They had to go back to a "good" backup, it was only 1 day ago so we got lucky. If it would have been several weeks then I would have a very unhappy user on my hands. I am not sure how to check or prevent this from happening again. All I found out so far is Unloading without the encrypt option fixed the DB, but I can't understand why, we have been using the encrypt option for over a year in lots of offices. Any suggestions? Marc SET NULL '-0- ' SET ECHO OFF SET NULL -0- OUTPUT cms.dat encrypt apples44x UNLOAD ALL OUTPUT SCREEN DISCONNECT cms PAUSE 4 USING ' Packing data - Please wait ' + CAPTION 'Working Please Wait' ICON warning OPTION METER_VISIBLE + ON | METER_VALUE 60 |METER_TYPE BAR3D | METER_BACK_COLOR + WHITE | METER_BAR_COLOR BLUE| METER_FONT_COLOR RED | + MESSAGE_FONT_SIZE 12 SET ECHO OFF DELETE cms.rb* RUN viewvar IN prog7.apx SET NULL -0- RUN cms.dat apples44x
