Subject | AssignSQLWithSearch problem in 4.3Aa |
---|---|
Author | rihoe |
Post date | 2005-01-08T18:42:29Z |
(Sorry if this appears duplicate)
I finaly thought that it is safe to switch from 4.2Hc to 4.3, but
was sadly wrong :(
I use AssignSQLWithSearch to initialize TIBOQuery (use them in
QuickReport). After installing 4.3Aa I noticed that almost all my
TIBOQuery gave back 0 records. Strangely some smaller queries
(without parameters) worked OK. At first glance it seems that having
parameter in TIB_Query breaks something in SQL transfer.
Sample of non-working query:
TIB_Query->SQL="SELECT NAME , ACCOUNT , COMMENT , DETAILS ,
IACCOUNT, UNAME , BANK , BANKNAME , IBANKNAME , IBANK, BADDRESS ,
CBANKNAME, CBANK, CACCOUNT, CURRENCY, REGNO, BALCODE,
COUNTRY ,BALINFO FROM FOR_CORRESP
WERE UNAME LIKE :FILTER FOR UPDATE"
After reverting back to 4.2H everything works again.
--
Riho-Rene Ellermaa
I finaly thought that it is safe to switch from 4.2Hc to 4.3, but
was sadly wrong :(
I use AssignSQLWithSearch to initialize TIBOQuery (use them in
QuickReport). After installing 4.3Aa I noticed that almost all my
TIBOQuery gave back 0 records. Strangely some smaller queries
(without parameters) worked OK. At first glance it seems that having
parameter in TIB_Query breaks something in SQL transfer.
Sample of non-working query:
TIB_Query->SQL="SELECT NAME , ACCOUNT , COMMENT , DETAILS ,
IACCOUNT, UNAME , BANK , BANKNAME , IBANKNAME , IBANK, BADDRESS ,
CBANKNAME, CBANK, CACCOUNT, CURRENCY, REGNO, BALCODE,
COUNTRY ,BALINFO FROM FOR_CORRESP
WERE UNAME LIKE :FILTER FOR UPDATE"
After reverting back to 4.2H everything works again.
--
Riho-Rene Ellermaa