Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Direct ODBC calls
Message
From
07/07/2003 11:14:38
 
 
To
07/07/2003 09:56:02
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00802290
Message ID:
00807473
Views:
21
This message has been marked as the solution to the initial question of the thread.
Hi Gary,
Perhaps this is a driver or precision issue in the procedure. What version of Sybase are you using? What version is the driver? What is the parameters section of the procedure look like?
I am using Sybase 11 with driver version 3.11.00.01 and the following code works fine:

connstr="DRIVER=Sybase System 11;UID=user;password=password;DB=db;SRVR=sybase11"

TEXT TO proccode noshow
create procedure addervarchar
@mult1 varchar(8), @mult2 varchar(8), @result varchar(16) output
as
select @result = (@mult1 + @mult2)
ENDTEXT

MESSAGEBOX(proccode)

xx=SQLSTRINGCONNECT(connstr)
yy=SQLEXEC(xx,proccode)
IF yy<0
=AERROR(lar)
MESSAGEBOX(lar[2])
ENDIF
x="Hi! "
y="Gary "
z=SPACE(16)
zz=SQLExec(xx,[exec addervarchar ?x,?y,?@z ])
MESSAGEBOX(z)

=SQLDISCONNECT(xx)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform