Thanks Javier That is very old code I found somewhere so he forms did not display –0-. I need to look into this for future updates.
Marc From: Javier Valencia Sent: Thursday, March 17, 2011 3:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Data corruption Marc, As other have mentioned, I would be very hesitant to change the NULL setting as it is global and as soon as you change it, it affects every other user. If you want to store blank spaces instead of “-0-“ you can always do it with code, just use ‘ ‘ (quote-blank-quote) rather than NULL defined as a blank space; keep in mind that using blanks (instead of a true NULL value) can create other problems as well. A NULL value, i.e. absence of data and a blank space are not the same thing; there have been several threads in the past on this issue. Also, if you do not want to display “-0-‘ in reports, all the newer versions allow you to define a default format for the filed/column such as “N.A.”; so, at least in reports, this is no longer an issue. In the code itself, the SET NULL command after the “IF SQL…” is redundant. Also I would code SET NUL ‘-0-‘ (with quotes) instead of SET NULL -0- (without quotes). Javier, Javier Valencia, PE 913-
