set your null char to whitespace (non visual) for the session.
Here is an example from my startup:
SET NULL '-0-'
SET VAR vHoldNUL = (CVAL('NULL'))
SET VAR vNull = (CHAR(32))
SET NULL .vNull
SET ZERO OFF
SET EQNULL ON
RETURN
at the end of the session set NULL back to original:
SET NULL .vHoldNUL
----- Original Message -----
From: "TOM HART" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, May 27, 2013 11:36 PM
Subject: [RBASE-L] - DB grid question
I am converting a form that I have been using a scrolling for multi rows of
data and when the row shows each column is blank until data is entered. I am
converting it to a DB grid to enter the data(personally it just looks
cleaner), but when a blank row comes up it has null values until data is
entered. Is this just a function of the difference or is there a way to show
blank fields.
Tom Hart
--- 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.
================================================
