[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] sql-status
- Subject: RE: [sqr-users] sql-status
- From: "George Jansen" <GJANSEN@aflcio.org>
- Date: Thu, 06 Jan 2005 09:14:26 -0500
- Delivery-date: Thu, 06 Jan 2005 09:16:03 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Perhaps you are thinking of #sql-count?
#sql-status will reliably report status for queries. With Oracle, it
will give a 0 for successful queries and a negative number for errors. A
query retrieving no rows is successful, for an empty relation is as we
all recall a legitimate relation.
>>> Ivan.Turner@qwest.com 1/5/2005 5:48:17 PM >>>
#sql-status is only good for begin-sql blocks it is not intended for
begin-select. For begin-select, you must use a switch/counter
variable
that is initialized before the select.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users