>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
You can't support empty datetime on an SQL backend. Either allow it to have nulls (preferred) or pass ^1899/12/30 for empty dates (ugly as there might be real ^1899/12/30 values).
Cetin