Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Arggh Newbie can not get SP value back to VFP
Message
De
09/10/2003 10:48:26
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Arggh Newbie can not get SP value back to VFP
Divers
Thread ID:
00836870
Message ID:
00836870
Vues:
42
I just cant figure how to get the SP to return data to VFP

When I try to call the SP from VFP I get a -1 error returned
see below code for what I have tried
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO


ALTER   PROCEDURE sp_getpersonaldatastring

            @StrAppdi varchar(50)

AS


DECLARE @string varchar(4000)
SET @string = ''

SELECT @string = @string + CHAR(13) + dbo.DataClass.DataClassDesc
FROM  dbo.SysDataClass INNER JOIN
      dbo.DataClass ON dbo.SysDataClass.DataClassID = dbo.DataClass.DataClassID
WHERE (dbo.SysDataClass.SystemID = @StrAppdi)
ORDER BY dbo.SysDataClass.SystemID



return  @string



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
I am trying to call the SP with a parameter of '421' and I want my conatenated string returning in lcRetval
and in VFP
lcretval=''
strAppid='421'

? SQLExec(lnHandle,"EXEC getpersonaldatastring ?@lcRetVal ?StrAppdi")
? SQLExec(lnHandle,"EXEC getpersonaldatastring '421'")

they both return -1 :(
Please just alter the SP for me so it works and give me the correct way to call it with a parameter from VFP before I go quite mad :(
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform