Brad,
Thanks for the suggestion, but it doesn't work. It appears that the VFP/ODBC driver combo is sending everything in the string delimiter, i.e.,[exec myproc ?x,?y,?@z ] as it is and Sybase is returning errors based on that. For example, prefacing a variable with "?" causes Sybase to return an error stating that the level of precision is incorrect. Using only the "@" causes Sybase to cry that "@MyVariable has not been defined".
However:
SQLExec(nConnection, [declare @NewKey char(8)]+CR_LF+[exec MyProc 'cust_id', @NewKey OUTPUT]+CR_LF+[select @NewKey],'curResult') returns a cursor with the new value.
It's a kludge, but until I can figure out the SQLBindParameter() API call...
Gary
>Hi Gary,
>Try sending all parameters as variables and prefacing them with ?:
>x=1
>y=2
>z=0
>zz=SQLExec(xx,[exec myproc ?x,?y,?@z ])
>or
>zz=SQLExec(xx,[call myproc ?x,?y,?@z ])
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only