INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Client-Server and ODBC

How to return a value from a server stored procedure by foxdev
Posted: 8 Jun 00

In order to standardize a certain operation and/or enhance security, it is sometimes desirable to invoke a stored procedure on the database server and have that stored procedure return a single value to Visual FoxPro.  Typically, returned results are in the form of a VFP cursor, but this incurs additional overhead in your VFP source, because you must store the result set's value into a memory variable then remember to close the cursor.

ODBC supports output parameters that allows you to receive a return value without using a result set.  For example, say you want to determine if a customer exists in the database server's Customer table, and if so, what that Customer's status is.

The VFP code would be:

cOutParam = ""
sqlexec(nHandle, "{CALL sp_chkcustomer ('12345', ?@cOutParam)}")


An example MS SQL Server stored procedure would be:

create procedure sp_chkcustomer
@cCustID char(10),
@cReturn char(1) OUTPUT
AS
declare @cStatus char(1)
select @cStatus=status from customer
    where CustomerID = @cCustID
if @@rowcount = 0
    set cReturn = "N"
else
    set cReturn = @cStatus
return(0)


Back to Microsoft: Visual FoxPro FAQ Index
Back to Microsoft: Visual FoxPro Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close