URGENT: Can't Insert in Table???

[Guest_imported]

I create a field type "date" and type "time" in my interbase table.
Why can't I insert something to table??? It gives me an error: Column Unknown??? What is that?

 

[StevenK]

Can you extend your problem a little for us ?
Are you using a table component or a query ?
How are you trying to insert the entry into the table ?

Steve

 

[pranavjosh]

Can u just give the code

 

[Guest_imported]

I try this using SQLDialect=1, but don't work, because there
are a field in database that is type "date".

ibQuery1.Close;
ibQuery1.SQL.Clear;
ibQuery1.SQL.Add ('INSERT INTO test2 ("' + edit1.text + '", "' + edit2.text + '&quot');
ibQuery1.ExecSQL;

This don't work because the SQLDialect is 3.
I solve the problem by pass the parameters like this:

ibQuery1.Close;
ibQuery1.SQL.Clear;
ibQuery1.SQL.Add ('INSERT INTO test2 PARAM1, ARAM2)');
ibquery1.params[0].asdate:=edit1.text;
ibquery1.params[1].asstring:=edit2.text;
ibQuery1.ExecSQL;

I expect that this help some of you.