Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with MySQL Max / SapDB
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement