Or do that.. what you said and what Bill said.. ;-)
----- Original Message -----
From: "Emmitt Dove" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, June 22, 2010 1:42 PM
Subject: [RBASE-L] - RE: NULL setting
OPTION BLANK_IF_ZERO.
It helps to read HELP GATEWAY .
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt
Dove
Sent: Tuesday, June 22, 2010 13:33
To: RBASE-L Mailing List
Subject: [RBASE-L] - NULL setting
Folks,
I'm using 7.6 to do a GATEWAY EXPORT to an XLSW. Our databases run with
the
NULL character set to a single dash, or (CHAR(45)).
In the worksheet I need null columns to be completely empty.
Here's what I've tried:
SET NULL '' -- two quote marks, nothing between them
GATEWAY EXPORT ...
SET NULL '-'
The problem is that the worksheet still contains dashes where the column
was
null.
How do I get those columns to be truly empty?
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
