Thank you Helen,

Nico
-----Oorspronkelijk bericht-----
Van: Helen Borrie [mailto:helebor@...]
Verzonden: maandag 7 mei 2001 14:30
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] SQLWhereItems question


At 01:31 PM 07-05-01 +0200, you wrote:

>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

Nico, you need to send the date literal in a format recognised by IB. IB
doesn't recognise 'dd/mm/yyyy'. Catch your user's entry and change tmpDate
to 'dd.mm.yyyy',

then

SQLWhereItems.Add ('DATE_TRANSACTION = ' + QuotedStr(tmpDate));

Cheers,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

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]