Bill The problem started after I repaired the database using the UNLOAD ALL command, run from withing Rbase 9.5 32. Before that day, I had always tried to repair the database using the RELOAD command from within Rbase for DOS. The null was set to -0- before the unload comand and before the code that is treating the letter Y like a blank space. Does the fact that I am running the code from with Rbase for DOS on a database that was created within RBase 9.5 32 cause problems? Mike
________________________________ From: Bill Downall <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, November 30, 2012 6:52:29 AM Subject: [RBASE-L] - Re: Code that quit working Mike, Both this problem and your forms and reports unload problem could be a result of your NULL setting. Is NULL by any chance set to a space? Bill On Fri, Nov 30, 2012 at 12:31 AM, Michael J. Sinclair <[email protected]> wrote: Hi All, >I have an app that was working just fine until recently, and now I can't >figure >out why it is acting differntly. > >I am running this code in Rbase for DOS... > >Here is the code... > >SET VAR vHARDBLANK = (CHAR(255)) >UPDATE tablename SET columnname = (SRPL(columnname,.vHARDBLANK,' ',0)) > >The goal is to clean up the appearance of a report by changing any blanks to a >hard blank. > >The code was working fine until yesterday, and now the above code erases the >letter 'Y' >Why is the letter 'Y' being treated like a blank? > >Thanks >Mike Sinclair >
