timestamp error 1

[bakira4]

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?

 

[mirtheil]

What does the actual SQL statement look like with the values? I'm going to guess that the "Date" field is not in the format PSQL needs.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[bakira4]

It looks like that:

INSERT INTO LIGNE (TypeMouvement, PiecePrefixe, PieceNumero, IP, TypeLigne, CodeArt, Libelle, CDate, Quantite, CodeDepot, Commentaire, QteInventaire)
VALUES (' ','INV','9','1','1','DESK','Beautifull Desk','20/05/2008','15','1','inventaire portable','15')

I trye to insert this into table LIGNE where the date format is like this dd/mm/yy

 

[mirtheil]

The PSQL date format needs to be 'yyyy-mm-dd'. It also needs to include the single quotes. So the statement needs to be:
INSERT INTO LIGNE (TypeMouvement, PiecePrefixe, PieceNumero, IP, TypeLigne, CodeArt, Libelle, CDate, Quantite, CodeDepot, Commentaire, QteInventaire)
VALUES (' ','INV','9','1','1','DESK','Beautifull Desk','2008-05-20','15','1','inventaire portable','15')

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[bakira4]

Thanks a lot, it works!!!
I insert date with 'yyyy-mm-dd' format
and in my row it's automatically converted in the 'dd/mm/yy'.
once again thanks mirtheil

 

[mirtheil]

Glad everything works. Thanks for the star.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com