Greetings,
I have recently upgraded from 4.2Gb to 4.5B and have found some of my
reports using TIBOQuery no longer have detail records.
I am using FB 1.03. Worked perfectly in 4.2Gb.

Any help would be greatly appreciated. It's currently looking like I need
to go back to 4.2Gb.



Master SQL:

SELECT
R.ID, R.USERID, R.COMPANY, R.DIVISION, R.INVLOC, R.INVCOST,
R.PAIDNOTRECAMT, R.PREINVAMT, (R.OPENORDERAMT * -1) as OPENORDERAMT,
PI.INVNAME, PI.INVMANTDR,
T.FULLNAME
FROM RPT_PI_ANALYSIS R
LEFT OUTER JOIN PI_MASTER PI ON R.INVLOC=PI.INVLOC
LEFT OUTER JOIN VW_TRADERS T ON PI.INVMANTDR = T.USERID
WHERE R.USERID = :USERID AND R.COMPANY = :COMPANY AND R.DIVISION = :DIVISION
ORDER BY
PI.INVNAME




Detail SQL:

SELECT
R.ID, R.USERID, R.COMPANY, R.DIVISION, R.INVLOC, R.ORDERNO,
R.SUFFIX, R.ORDERID, R.RECTYPE, R.ORDERAMT, OH.ESTAR, OH.CUSTSHIPDUE,
OH.SELLER, C.CUSTNAME, OH.ESTMARGIN
FROM RPT_PI_ANALYSIS_DTL R
LEFT OUTER JOIN ORD_HDR OH ON R.ORDERID = OH.ID
LEFT OUTER JOIN CUSTOMERS C ON OH.CUSTNO = C.CUSTNO
WHERE
R.USERID = :USERID AND R.COMPANY = :COMPANY AND R.DIVISION = :DIVISION AND
R.INVLOC = :INVLOC
ORDER BY
R.ORDERNO, R.SUFFIX



IBO Monitor:
/*---
FETCH
STMT_HANDLE = 20815000
FIELDS = [ Version 1 SQLd 12 SQLn 12
RPT_PI_ANALYSIS.ID = 12002266 <==== master
record looks great
RPT_PI_ANALYSIS.USERID = 'KEVIN'
RPT_PI_ANALYSIS.COMPANY = '01'
RPT_PI_ANALYSIS.DIVISION = '01'
RPT_PI_ANALYSIS.INVLOC = '1448'
RPT_PI_ANALYSIS.INVCOST = 53044.39
RPT_PI_ANALYSIS.PAIDNOTRECAMT = 0
RPT_PI_ANALYSIS.PREINVAMT = 0
[OPENORDERAMT] = -66807.52
PI_MASTER.INVNAME = 'COOLEY RELOAD'
PI_MASTER.INVMANTDR = <NULL>
VW_TRADERS.FULLNAME = <NULL> ]
----*/



PREPARE STATEMENT
TR_HANDLE = 20817256
STMT_HANDLE = 20815888

SELECT
R.ID, R.USERID, R.COMPANY, R.DIVISION, R.ORDERNO, R.SUFFIX,
R.VNDNO, V.VNDNAME, R.APAMT
FROM RPT_PI_ANALYSIS_AP R
LEFT OUTER JOIN VENDORS V ON R.VNDNO = V.VNDNO
WHERE
R.USERID = ? /* USERID */ AND R.COMPANY = ? /* COMPANY */ AND R.DIVISION
= ? /* DIVISION */ AND R.INVLOC = ? /* INVLOC */
ORDER BY R.VNDNO ASC
, R.ORDERNO ASC
, R.SUFFIX ASC

PLAN SORT (JOIN (R INDEX (RPT_PI_ANALYSIS_AP_IDX1),V INDEX
(RDB$PRIMARY313)))

FIELDS = [ Version 1 SQLd 9 SQLn 150
RPT_PI_ANALYSIS_AP.ID[ID] = <NIL>
RPT_PI_ANALYSIS_AP.USERID[USERID] = <NIL>
RPT_PI_ANALYSIS_AP.COMPANY[COMPANY] = <NIL>
RPT_PI_ANALYSIS_AP.DIVISION[DIVISION] = <NIL>
RPT_PI_ANALYSIS_AP.ORDERNO[ORDERNO] = <NIL>
RPT_PI_ANALYSIS_AP.SUFFIX = <NIL>
RPT_PI_ANALYSIS_AP.VNDNO = <NIL>
VENDORS.VNDNAME = <NIL>
RPT_PI_ANALYSIS_AP.APAMT[APAMT] = <NIL> ]

SECONDS = 0.016
----*/
/*===
//>>> STATEMENT PREPARED <<<//
TIB_Statement.API_Prepare()
TIBOInternalDataset: "qryAPDtl.IBOqrqryAPDtl" stHandle=20815888
====*/
/*---
DESCRIBE INPUT
STMT_HANDLE = 20815888
PARAMS = [ Version 1 SQLd 4 SQLn 4
< SQLType: 448 SQLLen: 15 > = <NIL>
< SQLType: 449 SQLLen: 5 > = <NIL>
< SQLType: 449 SQLLen: 10 > = <NIL>
< SQLType: 449 SQLLen: 5 > = <NIL> ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 20817256
STMT_HANDLE = 20815888
PARAMS = [ Version 1 SQLd 4 SQLn 4
[USERID] = <n> '' <========= Why is this <n> '' ????
Should be 'KEVIN' from master
[COMPANY] = '01'
[DIVISION] = '01'
[INVLOC] = '1448' ]
----*/



Thanks,
Kevin