Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How retrive a value from a stored procedure in sql 7.0
Message
From
03/05/1999 17:51:02
Fernando España
Alta Tecnologia En Informatica
Guatemala, Guatemala
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
How retrive a value from a stored procedure in sql 7.0
Miscellaneous
Thread ID:
00214766
Message ID:
00214766
Views:
60
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
Reply
Map
View

Click here to load this message in the networking platform