hi,
I'm very happy to find finnaly an active forum about pervasive programation.
I'have an ODBC database Connexion and I try to request on it with this:
queryInsLigne = "INSERT INTO LIGNE (TypeMouvement, PiecePrefixe, PieceNumero, IP, TypeLigne, CodeArt, Libelle, CDate, Quantite, CodeDepot, Commentaire, QteInventaire) VALUES ('" & rsCType.Fields(0) & "','INV','" & numPiece.Text & "','" & ip & "','1','" & code & "','" & designation & "','" & Date & "','" & qtt & "','" & depot.codeDepot & "','inventaire portable','" & qtt & "')"
but I receive an "invalid date, time or timestamp value" error...
I have already read an another thread about this error in this forum but the given solution doesn't work with me.
Someone can help me?
I'm very happy to find finnaly an active forum about pervasive programation.
I'have an ODBC database Connexion and I try to request on it with this:
queryInsLigne = "INSERT INTO LIGNE (TypeMouvement, PiecePrefixe, PieceNumero, IP, TypeLigne, CodeArt, Libelle, CDate, Quantite, CodeDepot, Commentaire, QteInventaire) VALUES ('" & rsCType.Fields(0) & "','INV','" & numPiece.Text & "','" & ip & "','1','" & code & "','" & designation & "','" & Date & "','" & qtt & "','" & depot.codeDepot & "','inventaire portable','" & qtt & "')"
but I receive an "invalid date, time or timestamp value" error...
I have already read an another thread about this error in this forum but the given solution doesn't work with me.
Someone can help me?