Smells fishy to me...

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Kevin Stanton" <Kevin.Stanton@...>
To: "IBO List" <IBObjects@yahoogroups.com>
Sent: Thursday, June 27, 2002 6:55 AM
Subject: [IBO] Problem with Dates as Params


> Greetings,
> I have a TIB_Cursor running the following SQL:
>
> select CH.BankNo, B.BankName, CH.SendToName
> >From Check_Hist CH
> Left Outer Join Bank_Master B on CH.BankNo=B.BankNo
> Where
> CH.Company = :Company and CH.Division = :Division and
> CH.CheckNo = :CheckNo and
> CH.CheckDate = :CheckDate and
> F_FIXEDPOINT(CH.CheckAmt, 2) = :CheckAmt
>
>
> When I run this interactively from IBExpert, the Checkdate gets passed as
> '5/15/2002' and the check requested is found.
>
> When I run this from my program using the TIB_Cursor, the Checkdate gets
> passed as '15 May 2002' and the check requested is NOT found.
>
> I've never seen this before and this function used to work at one point in
> time.
>
> I'm using D6, IBO 4.2.Gb
>
> TIA,
> Kevin