Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Executing a SQL Server stored procedure
Message
De
06/03/2001 07:16:12
 
 
À
06/03/2001 06:05:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00482118
Message ID:
00482163
Vues:
12
*-------------------------------------------------Code start--------------
a=sqlconnect("Acc")
cGroup = "'Furniture & Fixtures'"
cMasterGroup = "'ASSET'"
ZZZ = 0

=SQLEXEC(a,'EXEC Insert_In_Group' + (cGroup)+','+ (cMasterGroup)+ ',' +str(ZZZ)), 'MyCursor')
=aerror(lArray)
Disp memo like lArray
*---------------------------------------------------Code End--------------
Hi Sanjay,

I suspect this will not work anyway.
If you look at what the Exec statement evaluates to it looks wrong.
EXEC Insert_In_Group'Furniture & Fixtures','ASSET',0
It's so long since i've used Exec i can't remember the syntax but shouldn't there be a space after the word Group?

HTH
Will Jones
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform