Hello Everybody !

I want to store data into a "MySQLMax / SAP DB" table via ODBC, but i can't handle empty date fields?????
The field in the table is defined as typ date (not null = no)

*scan my ascii input data file
scan
l_customer = mycustomer
l_enddate = ctod(myenddate)

l_sqlcmd = "insert into xyz (customer,enddate) values(?l_customer,?l_enddate)"

l_error= SQLEXEC(p_connection,l_sqlcmd)

endscan

if myenddate = " " the following error message occurs:
Connectivity-Fehler: [MySQL MaxDB][SQLOD32 DLL] Datetime field overflowdatetime field overflow'

i tried : if empty myenddate
l_enddate = ctod(" ")
l_enddate = " "
l_enddate = "0000-00-00"
l_enddate = "00000000"
l_enddate = " - - "
l_enddate = "0"

no success !! always 'Connectivity-Fehler: [MySQL MaxDB][SQLOD32 DLL] Datetime field overflow'

l_enddate = "2099-01-01" works but this is not what i want !

Any help welcomed

Best regards
Albert