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]
