I have used:

uses ib_parse;
....
....

qr_fila.SQLWhereItems.Add('HORAENT>='+get_IBDateLiteral(Trunc(DateTimePicker
1.Date)));


Luiz.

----- Original Message -----
From: Nico Callewaert <ncw@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, May 07, 2001 8:31 AM
Subject: [IBO] SQLWhereItems question


> Hi,
>
> Probably a simple question, but I couldn't solve it. The problem is :
how
> can I add a Date parameter to the SQLWhereItems property ? The value is
> coming from a edit box, that is assigned to a local variable tmpDate. I
> tried it like this :
>
> The value of tmpDate = 31/03/2000, European format.
>
> SQLWhereItems.Add ('DATE_TRANSACTION = ' + #39 + tmpDate + #39);
> (#39 = ' )
>
> I get an error "Conversion Error from string ...". The only way to
assign
> it is like a string, so I'm stuck.
>
> Any idea ?
>
> Thank you,
>
> Nico