Hello

When I'm using the SQL TRACE TT_SQL_TRACE=0200 I get the following output in the logfile:

================================================
Fetch times of Query (QID : 21) in SqlBreak :

select tdpur045.*
from tdpur045
where tdpur045._compnr = :loc.comp
and tdpur045._index1 inrange {:orno.f} and {:orno.t}
and (tdpur045.fico = :save.compnr or tdpur045.fico = 0 )
and tdpur045.srnb <> 0


------------------------------------------------
Nr Rows Fetched : 7714
Fetch Time for 1st Row : 0.020 sec
Max Fetch Time : 0.020 sec
Average Fetch Time : 0.000 sec
Average Fetch Time (except Max) : 0.000 sec
================================================

I have checked all the predefined variables but nothing looks like that I want. Also when debugging all the variables (Option L in the debugger) I can not find a variable with this value.

Is it possible to get the valu from the line "Nr Rows Fetched" in the program script? (Baan IV b)

In some cases it would be nice to show the progress based on the number of fetched records.

Thanks

Well I really hope I am wrong about this, but as far as I know using count is the only way. I hope someone posts something I do not know about.

Mark

That's the way I solved it in the past. but.....performance....

Let us see who knows more.

lakoon

Most sessions in BaanV use progress indicators, and they use a query with count to get the total records before the process starts. Sorry.