Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Direct ODBC calls
Message
De
07/07/2003 11:14:38
 
 
À
07/07/2003 09:56:02
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00802290
Message ID:
00807473
Vues:
22
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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform