Subject RE: [IBO] To HELEN, SQLWhereItems question
Author Nico Callewaert
Thank you Helen,

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

At 01:31 PM 07-05-01 +0200, you wrote:
> 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 = ' )
>I get an error "Conversion Error from string ...". The only way to
>it is like a string, so I'm stuck.
>Any idea ?
>Thank you,

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 '',


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


All for Open and Open for All
InterBase Developer Initiative ยท

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]