Mike,
Try this and see what the results are before you set null to ' '
If you are expecting null to be a space, you will be disappointed.
SET VAR vemptyspace TEXT = ''
SET VAR vspace TEXT = ' '
SET VAR vblank TEXT = (CHAR(32))
SET VAR vtest TEXT = ('RBASE' + .vemptyspace + 'ROCKS')
PAUSE 2 USING .vtest
SET VAR vtest TEXT = ('RBASE' + .vspace + 'ROCKS')
PAUSE 2 USING .vtest
SET VAR vtest TEXT = ('RBASE' + .vblank + 'ROCKS')
PAUSE 2 USING .vtest
RETURN
If you want null to be just invisible for display purposes (devoid of
the -0- in fields that are nulls) then set the null character to an
unprintable ascii value like Char(160)
It has been recommended practice for as long as I can remember to set null
to -0- before unloading data.
you can set null to that value by the recommended method of:
set null '-0-'
At the start of an RBase session, I include this:
set null '-0-'
set var vHoldNull = (CVAL('NULL'))
then at the conclusion of the session:
set null .vHoldNull
Then if the session ends back in RBase RDBMS interface, my null setting is
back to the recommended setting for unload. I don't change the null setting
to do ReLoad FWIW.
In your examples, you had null set to Two blanks and Three blanks, but it
doesn't matter, since RBase strips out blanks in an expression as my example
shows.
----- Original Message -----
From: "mike epstein sony viao office" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, April 21, 2012 3:28 PM
Subject: [RBASE-L] - null
: Can anyone clarify the meaning, and usage of
:
:
:
:
:
: Set null ' '
:
:
:
: Set null -0-
:
:
:
: Set var <varname> <vartype> = null
:
:
:
: Does the Set var <varname> <vartype> = null make a variable that has a
: value, change it to ' ' (blank)
:
:
:
:
:
: On a network with 2 workstations Is the setting on the local computers cfg
: file affected by changes in an eep , say that sets null to -0- inserts
or
: updates into a table and then before exiting the eep sets null = ' '.
:
:
:
:
:
: Should the -0- only be used to unload data and structure from a table?
:
: Should the -0- only be used to reload or pack the database ?
:
:
:
: I have set null in the configuration setting to blank from -0- , when I
: close the configuration settings I get an error message that says ' cannot
: save c:\windows\rbengine91_64.cfg. It does not matter if I change the
order
: ie -0- to blank
:
: Either way whatever symbol is input into the null configuration setting
is
: the setting in the application
:
:
:
: I am also experiencing that the -0- all of the sudden appears when the
: application is run while tracing with no change in the ' ' setting by the
: program
:
:
:
:
:
:
:
:
:
:
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
