Subject | Problem with Dates as Params |
---|---|
Author | Kevin Stanton |
Post date | 2002-06-26T15:31:48Z |
Greetings,
I have a TIB_Cursor running the following SQL:
select CH.BankNo, B.BankName, CH.SendToName
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
I have a TIB_Cursor running the following SQL:
select CH.BankNo, B.BankName, CH.SendToName
>From Check_Hist CHLeft 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