RE: [sqr-users] Global VS parameter list

[Charly Lebrun <calebrun@yahoo.com>]

Dear all,

This is one of the really bad thing with SQR, which as so many qualities on the 
other hand !

First, did anyone mentioned that you can access all globals from a procedure 
with parameters by
calling it with a preceeding '_' character. I did not fully read all the 
answers, please forgive
me if this has been done before. So if somewhere you have a variable called 
&MyValue, you can read
and and assign it in the procedure (with parameters) by calling it &_MyValue. 
This is true for any
kind of variable ($, # and &).

This SQR behavior is so painfull that I limit the use of procedure with 
parameters to small
process with only a local context to use. Mainly I developp all my procedures 
without parameters
and take care to call all my variables with prefix that identify were the 
variable is used,
because I want often to access the cursors values from several points (and I 
cannot pass the full
cursor record as a parameter like in PL/SQL with ROWTYPE).

That's the way it is... Hope this helps anyway. You do really great things with 
Brio once you pass
over this drawback.

Charly 

=====
Charly Lebrun
calebrun@yahoo.com


        

        
                
Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout ! 
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Dialoguez en direct avec vos amis grâce à Yahoo! Messenger !Téléchargez Yahoo! 
Messenger sur http://fr.messenger.yahoo.com

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