RE: [sqr-users] sql-status

["Turner, Ivan" <Ivan.Turner@qwest.com>]

#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.

-----Original Message-----
From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org
[mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of
George Jansen
Sent: Monday, December 27, 2004 10:12 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] sql-status

Something like this is awfully easy to test, isn't it?

************************************
Begin-Program
Begin-Select
Dummy &dummy
>From Dual
Where Dummy < 'X'
End-Select

Display 'No rows case:'
Display #sql-status

let $bad-identifier = 'SCOTT.123'
Begin-Select On-Error=oops
Nocol &nocol
>From [$bad-identifier]
End-Select

End-Program


Begin-Procedure oops
 Display 'Error case: '
 Display #sql-status
End-Procedure

************************

And yes, the values are database-dependent for the error case.

>>> kommuri@gmail.com 12/26/04 9:50 AM >>>
Hi,

   What will be the value in sql-status i) when no rows are fetched in
the begin-select block ii) when an error occurs in begin-select?

   Does the return value depends on the underlying database? We are on
Oracle.


Thanks,

_______________________________________________
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