SQLEXEC and RETURN from Stored Procedure

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQLEXEC and RETURN from Stored Procedure

Message

16/03/2006 08:35:14

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

SQLEXEC and RETURN from Stored Procedure

Versions des environnements

Visual FoxPro:

VFP 8 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

MS SQL Server

Divers

Thread ID:

01104848

Message ID:

01104848

Vues:

Hello,

For example I have stored procedure o SQL Server 2000:

CREATE PROCEDURE spTemp_Return (@TempIn integer)
AS
RETURN @TempIn * (-1)

Is it possible to get value from SP using SQLEXEC function? Or I have to modify my SP to use OUTPUT variables?

Thanks,

Giedrius