timestamp question

[jliang]

Hi,

I have table1, which has a col1 with timestamp(1) data type, and I create another table, tbl2 with a col has same data type timestamp(1). I try to insert data from table1 to tbl2, but I got error message 5407. the insert statement like:

insert into tbl2
select col1 as col
from table1;

Many thanks in advance

Jing

 

[dnoeth]

Do a "Show Table" for both tables and check if the column is really a Timestamp.
If the table was created in QueryMan the datatype is sometimes modified by ODBC.
To solve that problem you'll probably havt to check "allow use of odbc sql extensions in queries" in options -> query.

Dieter