If they are NOT NULL, try setting a default in case it is null, using a ridiculous date such as '02/28/1601' which will allow you to find the bad rows and correct the dates and times later.
"Richard A. Starkey" <[EMAIL PROTECTED]> wrote: >Chuck, > >Check to see if the columns are set for NOT NULL ? >This may be the problem > >Rich Starkey > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On >Behalf Of Chuck Finley >Sent: Monday, November 04, 2002 6:02 PM >To: '[EMAIL PROTECTED]' >Subject: Load Command Fails on Null Values in Date & Currency > > >Thanks to all that helped with my width command and 'cmd' files. Another >problem has cropped up after my unload/load. It now seems that when I do >a >load command and one of the variables is null (a date variable/column >and/or >a currency variable/column) the load command fails. If I set the >variable to >anything but null is completes correctly. Text columns work fine..... >Any >Ideas? >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
