Icon View Incident Report

Serious Serious
Reported By: Chris Holland
Reported On: 4/24/2007
For: Version 4.25 Build 4
# 2350 Updating a Timestamp Column using ODBC.NET Data Provider Not Working Properly

I am having trouble updating a TimeStamp field via the ODBC driver. If I try and update a TimeStamp Field using the following nothing gets saved to the table.

LogCommand.SQL = "INSERT INTO EventLog (LogDate,Message) VALUES(?,?)";
LogCommand.Parameters.Add("LogDate", OdbcType.DateTime); // Changed to DateTime
LogCommand.Parameters.Add("Message", OdbcType.VarChar, 50);
LogCommand.Parameters["LogDate"].Value = DateTime.Now;  // Include Time with Date
LogCommand.Parameters["Message"].Value = "Test Message";
LogCommand.ExecuteNonQuery();



Resolution Resolution
Fixed Problem on 5/2/2007 in version 4.25 build 5


Products Affected Products Affected
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial

Image