Rudy,
I use a code fragment that looks a bit like this ["names have been
changed to protect the innocent" ;-) ]
STATUS = SQLExecDirect(HANDLE,"EXEC <Stored proc name> @<Input param
name> = '":<Input param value>:"' ;")
STATUS = SQLBindCol(HANDLE, 1, SQL.B.DEFAULT, <return parameter 1>)
STATUS = SQLBindCol(HANDLE, 2, SQL.B.DEFAULT, <return parameter 2>)
LOOP
WHILE STATUS NE SQL.NO.DATA.FOUND DO
STATUS = SQLFetch(HANDLE)
GOSUB CHECK.SQLERROR
IF ERROR.FLAG THEN RETURN
IF STATUS NE SQL.NO.DATA.FOUND THEN
* The SQL Stored Procedure may return an empty row for 'no hit'
IF <return parameter 1> NE '' THEN
NUM.ROWS += 1
OUTPUT.DATA<1,NUM.ROWS> = TRIM(<return parameter 1>)
OUTPUT.DATA<2,NUM.ROWS> = <return parameter 2>
END
END
REPEAT
Hope this helps
Mike
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy
> Sent: Friday, 12 January 2007 13:21
> To: [email protected]
> Subject: [U2] UV Bci
>
> Hello List,
>
>
> Has anyone called a sql server stored procedure with an
> output parameter from UV using bci and gotten it to work ?
>
> Thx,
>
>
> Rudy Cooper
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
