Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one question as to how we can execute a stored procedure that returns a resultset (many no. of rows). This has to be stored in to a QVD file.
example
exe mysp par1,par2,par3
returns
val1a,val2a...
val1b,val2a...
.
.
.
I will be including this in my QVD script generation file(QVW)
thanks,
Rajesh Vaswani
once connected, just use:
SQL mysp par1,par2,par3;
that is.
tested on sybase and mssql with success (OLEDB)
be sure you only have one and only one resultset