I read a bunch of posts on this group about the TIMESTAMP issue, and
tried fixing my problem but with no success. Here is what I have.

I have created a table called PEOPLE in my embedded firebirdsql database

CREATE TABLE PEOPLE(
FIRSTNAME BLOB SUB_TYPE 1,
LASTNAME BLOB SUB_TYPE 1,
RECORD_TIMESTAMP TIMESTAMP
);

I am trying to add records to it using the following in C# .NET 2.0

commandToDb = string.Concat("INSERT INTO ",
conf.Configuration.databaseInfo.tableName, " VALUES
('abc','xyz','07/19/2007 14:42:02.000')");
FbCommand cmd = new FbCommand(commandToDb, dbConn);
try
{
cmd.ExecuteNonQuery();
}

I get the following error on the ExecuteNonQuery line
"Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 1,
char 255\r\nNo"

I get the feeling that I am not specifying the time right.

Anybody knwo what I am doing wrong?

Thanks in advance,
AM