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

2002-08-09 Thread Stephane Legault/Quebec/IBM
"RMD" <[EMAIL PROTECTED]Pour :Stephane Legault/Quebec/IBM@IBMCA

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