Andreas,

Thanks for your help, but that's not really the answer. I know how to
work with Params [x].Asxxx. The problem is the SQLWhereItems property,
that parameter is provided with a local variable (see code below), I tried
the double quotes as well (#34), doesn't work.

Nico
-----Oorspronkelijk bericht-----
Van: Andreas Pohl [mailto:apohl@...]
Verzonden: woensdag 16 mei 2001 13:38
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] SQLWhereItems question


Nico,

try to use double quotes " instead or use Params, then ibo will do the
rest,
e.g.

where date=:date

params.ByName('date').AsString:=edit1.text;

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Nico Callewaert" <ncw@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, May 07, 2001 1:31 PM
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
>
>
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>


Yahoo! Groups Sponsor



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]