Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling a Stored Procedure from VFP9
Message
 
 
À
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:
01552592
Vues:
40
>>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.

Now try running this statement directly in SSMS.

I see that the parameter is @p33, but it should be @p31 instead.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform