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

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

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