[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Setting Variable Procedure Names
- Subject: Setting Variable Procedure Names
- From: "Paul O'Riordan" <Paul_O'Riordan@AVERYDENNISON.COM>
- Date: Tue, 9 Oct 2001 11:59:16 +0100
Hi there all,
I'm new to this list and decided to post a question. Does anyone know
if it is possible to assign a Value to a variable and then call that
veriable as a procedure:
for example, in my error-handling I want to display all of the variables
that I was trying to insert or update when I caused and error. I have
created a "Show" procedure for each of my Insert procedures but I don't
want to hard-code the search for which procedure erred out. (Laziness).
Also each procedure is seperate and unique so it is not as if I can pass
parameters
"Do show_procedure($whatever)". Below is what I want to do, sort of, but
it doesn't work. Has anyone tried anything similar and succeeded?
If #sql-status = -9
!Duplicates on insert
Else
Show 'Error in Procedure : ' $proc
Show 'SQL-Error = ' $Sql-Error
Show 'SQL-Status = ' #SQL-Status
Let $procedure = 'Show_' || $proc
Do $procedure
End-if
Thanks and regards,
Paul
-------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.