Hi all,

I receive error messages undefined sqlid (0) on a customized (display-)session. I use query-extends to fetch my records.

How do I trace the sql-id, and the query.extend.where etc values via debugging?


Thanks in advance,

En.

Hi,

Can you give out more info please, I guess there is some problem with the query extend you have written.

Thanks

This is in a display session with different forms, where for each form different data (yet from same table) is being displayed. So in each before.form the query.extend.where is adjusted accordingly, and rebuild.query() -> execute(first.view) are executed.

In the main.table.io there is a manipulation done in order to get cumulatives only (by selecting sums of the selection via an alias of the main table), so there is where it goes wrong somehow.

That's why I asked for the debugging values of sqlid and the query.extend.where etc, so that I can trace those values in debugging mode, and see what goes wrong where...


En.

En,

You can also get debug information from the Baan database driver by using -- -set TT_SQL_TRACE=value (or added values) to get info about Baan SQL queries beeing handled:

value description
000040 show queries wih their QID
000200 show query exec. times
002000 show calls of internal SQL functions, intercept Full Table Scans
004000 show query eval. plan (client+server)
010000 show quey ev. plan (server)
020000 show all full table scans

BLAT stands for Binary Logging And Tracing and is the successor of TT_SQL_TRACE. See e.g. the Performance guide (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7665) for more details.

Kind regards,
Dick