Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling a Stored Procedure from VFP9
Message
From
07/09/2012 14:06:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server
Miscellaneous
Thread ID:
01552550
Message ID:
01552590
Views:
35
>There is a call to your SP in that screen shot - the one that starts with declare @p33. See the whole code if you highlight this entry at the bottom pane. Copy the whole code and post here.
>
>In the event selection keep only RPC:Completed and add a filter by ApplicationName like '%FoxPro%'. This way you will only see calls to your SP.
declare @p33 varchar(8000)
set @p33=''
exec sp_executesql N'Execute dbo.InsertMaster @P1 , @P2 , @P3 , @P4 , @P5 , @P6 ,  @P7 , @P8 , @P9 , @P10 , @P11 , @P12 , @P13 , @P14 , @P15 , @P16 , @P17 , @P18 , @P19 , @P20 ,  @P21 , @P22 , @P23 , @P24 , @P25 , @P26 ,  @P27 , @P28 , @P29 , @P30 ,@P31 OUTPUT ',N'@P1 varchar(2),@P2 varchar(1),@P3 varchar(5),@P4 varchar(25),@P5 varchar(25),@P6 varchar(1),@P7 varchar(51),@P8 varchar(1),@P9 varchar(18),@P10 varchar(22),@P11 varchar(21),@P12 varchar(29),@P13 varchar(2),@P14 varchar(1),@P15 varchar(8),@P16 varchar(3),@P17 char(19),@P18 varchar(3),@P19 char(19),@P20 varchar(1),@P21 float,@P22 float,@P23 float,@P24 float,@P25 float,@P26 float,@P27 float,@P28 float,@P29 float,@P30 varchar(3),@P31 varchar(8000) OUTPUT','40','C','20   ','MAINTAIN                 ','CONSTANT                 ','C','He told me to maintain my speed.  What should I do?','','speed up sometimes','slow down occasionally','keep a constant speed','get there as soon as possible','16','K','110022  ','   ','                   ','   ','                   ','T',-0.40000000000000002,0.17000000000000001,-1.8100000000000001,-2.25,0.45000000000000001,0,0,0,0,'   ',@p33 output
select @p33
That's all of it.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform