IBQuery1.SQL.Add('select * from test1 where data>= "'+date2+'")');

[Guest_imported]

URGENT:
This SQL instruction give me an error, and I don't know why... It gives me an error "COLUMN UNKNOWN".

data1:=date;
data2:=formatdatetime('DD-MM-YYYY',data1);
ibquery1.close;
IBQuery1.SQL.Clear;
IBQuery1.SQL.Add('select * from test1 where data>= "'+data2+'&quot');
ibquery1.Open;

Why???

In database the field "data" is type date.
I'm using Interbase.

Table design:

ID | DATA | TIME
1 | 10-10-2001 | 10:00:00
1 | 21-10-2001 | 11:00:00
1 | 12-10-2001 | 15:00:00

HELP!!! NEEDED !!!

 

[Guest_imported]

INSERT have the same problem...
How do I manage date field in interbase???

 

[hilbrink]

Perhaps you could try it without de double quotes around data2. Or replace the double quotes by single quotes.
Not sure if it helps...

 

[spradeepraj]

hi,

Query1.SQL.Add('select * from test where data>=:A');
Query1.ParamByName('A').AsDate := Date;
query1.Open;

It will do for you...

Regards
Pradeep mail me : spradeepraj@dsqsoft.com
Delphidhasan