Greetings, Stan. All I can offer is that we've been doing it this way
since 1991 and version 3.0 without any problems whatever.
Emmitt
This method does not work if the data is INTEGER.
Stan Loo
----- Original Message -----
From: "Emmitt Dove" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, August 09, 2004 8:06 AM
Subject: [RBG7-L] - RE: Copy Report To Another Database
>
> Any UNLOAD DATA FOR tablename will do this for you, using the NULL setting
> for the database. We always set NULL to the dash (CHAR(45)), and have
> since 3.x without any problems.
>
> >I'll wait for a comment from Dr:R: but I certainly feel much safer when
my db
> >has NULL -0- before moving any data at all in any direction. Suspenders
and
> >belt? Probably <g>
> >
> >--- Lawrence Lustig <[EMAIL PROTECTED]> wrote:
> >
> > > > One minor amendment: SET NULL -0- before unloading
> > > > the report data.
> > >
> > > Is this still true in "modern" R:Base? I don't think
> > > any of the form and report tables' columns are every
> > > null. . . Except maybe for the comment, which doesn't
> > > really matter if it gets set to a 0 length string.
> > > --
> > > Larry
> > >
> > >
> >
> >
> >=====
> >Albert Berry
> >Management Consultant
> >RR2 - 1252 Ponderosa Drive
> >Sparwood BC, V0B 2G2
> >Canada
> >(250) 425-5806
> >(250) 425-7259
> >(708) 575-3952 (fax)
> >[EMAIL PROTECTED]
>
> Emmitt Dove
> Manager, DairyPak Business Systems
> Blue Ridge Paper Products, Inc.
> 40 Lindeman Drive
> Trumbull, CT 06611
> (203) 673-2231
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
