[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Record count in a LOAD-LOOKUP

OUCH! :)
(The latest version of SQR is not an issue with us.  We are still on
4.3.4.)
Thanks,
Jim 

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of
Alexander, Steven
Sent: Thursday, May 18, 2006 12:49 PM
To: 'This list is for discussion about the SQR database
reportinglanguage from Hyperion Solutions.'
Subject: RE: [sqr-users] Record count in a LOAD-LOOKUP

I don't have the very latest version of SQR, but in earlier versions the
load-lookup command does not tell the programmer how many rows it
loaded.
One (painful) solution is to do the same query again as follows:

Begin-select
Count(*) &count
 From ...
End-select

-----Original Message-----
From: Jim Womeldorf [mailto:jwomeldo@fastenal.com]
Sent: Wednesday, May 17, 2006 9:09 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Record count in a LOAD-LOOKUP

Hi all,
When doing a LOAD-LOOKUP I see the count of the number of records loaded
displayed in the log file.
Does anyone know if this number is available to the program?  I tried
#sql-count but that did not work.
If no rows are loaded I would like to avoid some time consuming code.
Thanks,
Jim

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users