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

Click here to load this message in the networking platform