Re: how to insert a blank field in a date field

2002-08-09 Thread Stephane Legault/Quebec/IBM
>cc : Objet : Re: how to insert a blank field in a date field 09/08/2002 06:24

Re: how to insert a blank field in a date field

2002-08-09 Thread RMD
t;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 2:35 PM Subject: how to insert a blank field in a date field > I'am parsing a text field delimited by ; (see example belown). I split the > file into multiple variable ($) and then execute the request. When

Re: how to insert a blank field in a date field

2002-08-09 Thread David Dooling
On Fri, Aug 09, 2002 at 01:35:03PM -0400, Stephane Legault/Quebec/IBM wrote: > but when de DATE is blank I receive a message from DB telling me > that the format of the date is not good!!! > > Someone can help me??? Test if the variable storing the date field is the empty string. If it is, unse

how to insert a blank field in a date field

2002-08-09 Thread Stephane Legault/Quebec/IBM
I'am parsing a text field delimited by ; (see example belown). I split the file into multiple variable ($) and then execute the request. When the NO is blank: no problem the record is write inside DB but when de DATE is blank I receive a message from DB telling me that the format of the date is no