ms access query with ado...

> i connect my mdb databse with ado component.
> my mdb table has 3 field. these are:
> time:date number:number name:string

> adoquery1.sql.add('select * from table where
> time='+edit1.text+' and
> number='+edit2.text);

> when this code runs delphi give a error
> message:"syntax error in number in
> query time=10.12.2001 and number=5"

> i write to edit1.text 10.12.2001 and
> edit2.text 5.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!