Ray,


I'm using a stored procedure with an output parameter.  I've used
SQLBindCol to execute sql directly, but does it also with stored
procedures ?



Thx,



Rudy





<<Date: Sat, 11 Mar 2006 22:45:02 +1000

From: "Ray Wurlod" <[EMAIL PROTECTED]>

Subject: Re: [U2] bci



SQLBindParameter is for binding a variable to a parameter marker in the
query to be executed.

What you really need is SQLBindCol, which binds a variable to a column
in the result set.

If the number of return columns is N, you need N invocations of
SQLBindCol (that is, you must consume all the columns in the result set,
even if the application does nothing with some of them).

You can dynamically determine the number of result columns with
SQLNumResultCols.

HTH>>





Rudy Cooper
Information Technology
Project Technical Lead

Sage Publications
2455 Teller Road
Thousand Oaks, California 91320

Direct (805) 410-7724
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to