Subject Problem with Dates as Params
Author Kevin Stanton
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