Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Executing a SQL Server stored procedure
Message
From
06/03/2001 07:16:12
 
 
To
06/03/2001 06:05:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00482118
Message ID:
00482163
Views:
14
*-------------------------------------------------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
Previous
Reply
Map
View

Click here to load this message in the networking platform