Parameter substitution

Hello all,

I am trying to call a SQL script (here-after "Inner") from within another SQL script (here-after "Outer"). My problem is with using parameters.

the "Inner" script expects to receive &1 and &2 and the "Outer" script passes two parameters as follows :

    @Inner var1 var2

When "Inner" executes, it receives the values 'Var1' and 'Var2' rather than their values.

My question is how to cause the values of Var1 and Var2 to be used by "Inner", rather than their names.

Thanks in advance,

Ariel Kirson
Ex Libris. Received on Tue Aug 04 1998 - 09:55:40 CDT