RE: [sqr-users] -S flag for cursors

[Peter Burton <Peter_Burton@Hyperion.com>]

Yuri,

If you have SQR 8.0 (or higher) from Brio (or Hyperion) you can examine the
SQR resevered variable $SQL-TEXT after a BEGIN-SELECT or BEGIN-SQL block to
see exactly what was sent to the database.

The -S command line flag only shows you the last SQL statement used for all
the cursors when the report terminates.  Note that cursors get reused in
SQR.  If the SQL is dynamic (i.e. bind and/or dynamic variables were used)
then you will see the template.

Peter

> -----Original Message-----
> From: sqr-users-admin@sqrug.org@HYPERION  On Behalf Of Yuri Lakef
> <lakef250@yahoo.com>
> Sent: Tuesday, January 20, 2004 2:44 PM
> To:   sqr-users@sqrug.org
> Subject:      [sqr-users] -S flag for cursors
> 
> 
> Is there a way to view the values of bind variables when using -S flag for
> cursors?
> 
> 
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list.