Subject | Understanding the IB_MonitorDialog Output |
---|---|
Author | pmagor2001 |
Post date | 2002-01-17T07:30:55Z |
Hi all
I am using the IB_MonitorDialog to help with the development of a
program and I have question about its output.
The following is in the log
SELECT ALL transtable.*
FROM transtable
WHERE CUSTOMER < ? /* PRM_0 */ /* OLNK_CUSTOMER */
ORDER BY CUSTOMER DESC
, TRANS_ID DESC
, INV_NUMBER DESC
Now I recognise the field names (CUSTOMER, TRANS_ID and INV_NUMBER)
and the table name (transtable) but what I don't recognise is the
condition and the PRM_0 and OLNK_CUSTOMER. Can any one help me to
identify why this query is generated? It's currently slowing down the
program as it can take over a minute to run.
Thanks in advance
Peter Magor
I am using the IB_MonitorDialog to help with the development of a
program and I have question about its output.
The following is in the log
SELECT ALL transtable.*
FROM transtable
WHERE CUSTOMER < ? /* PRM_0 */ /* OLNK_CUSTOMER */
ORDER BY CUSTOMER DESC
, TRANS_ID DESC
, INV_NUMBER DESC
Now I recognise the field names (CUSTOMER, TRANS_ID and INV_NUMBER)
and the table name (transtable) but what I don't recognise is the
condition and the PRM_0 and OLNK_CUSTOMER. Can any one help me to
identify why this query is generated? It's currently slowing down the
program as it can take over a minute to run.
Thanks in advance
Peter Magor