Rudy,
Looking at your UV BASIC BCI code and stored procedure, I suggest the
following:
A) I noticed that your stored procedure has 9 arguments, not 8 as you've
defined in your BCI code. You've ommitted the most important one - the
output argument. Isn't that what you're asking about?
B) I recommend you to use SQLExecDirect, instead of SQLExecute (see my
example)
C) When using SQLExecDirect, you will first need to define/declare your
stored procedure and argument list using parameter mark characters (?
characters).
That is, do not put the values in the declaration.
For example: MYSPROC = "{sptestproc (?,?,?,?)}".
Secondly, you will need to define all the Input and Output arguments
with SQLBindParameter (see example I posted). Ensure the in correct
sequential order as the stored procedure inputs and outputs them.
Again, look at the example I posted and amend your own source code
appropriately.
Hope this helps.
Regards,
David
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
