Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling a Stored Procedure from VFP9
Message
De
07/09/2012 14:06:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server
Divers
Thread ID:
01552550
Message ID:
01552590
Vues:
36
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform