Focal Point
[CLOSED]Difference between &LINES and &RECORDS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7357068976

December 18, 2015, 08:54 AM
Bharathi
[CLOSED]Difference between &LINES and &RECORDS
Can someone quickly explain the difference between &lines and &records and where to use what?

Thank you!

This message has been edited. Last edited by: <Emily McAllister>,
December 18, 2015, 08:58 AM
Squatch
Here is a link:

http://forums.informationbuild...237082416#9237082416

...and here...

http://forums.informationbuild...181090062#2181090062

It looks like &records is how many records you retrieved from the database, and &lines is how many lines ended up in your report. I could be wrong, so I hope someone else will post a more authoritative answer.

This message has been edited. Last edited by: Squatch,


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
December 20, 2015, 03:56 PM
Waz
You are right.

&RECORDS is rows retrieved.

And &LINES is after aggregation and filtering.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!