Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How retrive a value from a stored procedure in sql 7.0
Message
De
03/05/1999 17:51:02
Fernando España
Alta Tecnologia En Informatica
Guatemala, Guatemala
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
How retrive a value from a stored procedure in sql 7.0
Divers
Thread ID:
00214766
Message ID:
00214766
Vues:
59
How can I do for retrive a value from a store procedure from a sql 7.0 stored procedure

example

SQL 7.0 Store Procedure****

Create procedure sp_calculo @valor int,
@fecha datetime,
@valor_retorno int output as
begin
insert transaccion (valores,fechas)
values(@valor,@fecha)

select @valor_retorno = @@identity

return

end

VFP program for get the @valor_retorno value

a=sqlconnect("coneccion")
if a>0
b=sqlprepare(a,"exec sp_calculo 10,[01/01/1999] ","mycursor")
c=sqlexec(a)
else
wait window "Error de Conexion"
endif

this do not work bacouse i have not the @valor_retorno

what is bad or how can I do for get the return value, please help me
Fernando España
SQL Server Specialist
Répondre
Fil
Voir

Click here to load this message in the networking platform