in Microsoft OLE DB Provider for ODBC Drivers

[Stolas]

Hello everyone,

I m having a trouble with my code. The folowing error occured when i try to update a record in the table "ETA" of my database  "metroqual" and only in this table.

Échec de la conversion de la date et/ou de l'heure à partir d'une chaîne de caractères. in NI_Database_API.lvlib

This is the first time i get this and the code has been working for several months! I m very confused because the same operation don't generate this error when i try it with another table.

In the "ETA" table I have 45 parameters and the date data is the 6 th. I use a time stamp control with "time unused and system date format" properties.

Does someone knows how to fix this problem? I tried many ways but it still doesn't work. I can do everything but i cannot update datas.

Thanks in adavance!

[mikeporter]

Are you talking to SQL Server? What version? How are you formatting the date information? Did this code work prior to October 1st? If you query this table, what format does the time/date column come out as?

Mike...

[Stolas · Accepted solution]

Thank you mikeporter,

I have already resolved the problem.

There was an error in my code. The value sent to the database was a "number" but in the code I writed that it must be a "date", so this is why the query command generated an error because the statement included a number instead of a date.