DOCUMENT:Q194669  18-AUG-1999  [foxpro]
TITLE   :HOWTO: Retrieve Extended Stored Procedures from SQL Server
PRODUCT :Microsoft FoxPro
PROD/VER:MACINTOSH:3.0b; WINDOWS:3.0,3.0b,5.0,5.0a,6.0
OPER/SYS:
KEYWORDS:

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Macintosh, version 3.0b 
 - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0 
-------------------------------------------------------------------------------

SUMMARY
=======

This article shows how to use the stored procedure sp_helpextendedproc to return
information about extended stored procedures when accessing date available from
SQL Server.

MORE INFORMATION
================

The sp_helpextendedproc stored procedure returns a cursor with information
regarding currently defined extended stored procedures and the name of the
dynamic link library to which the procedure belongs.

The columns returned by sp_helpextendedproc are:

Column name          Description
-----------          -----------

NAME                 Name of the stored procedure
DLL                  Dynamic link library to which the stored procedure in
                     the NAME column belongs.

1. Create a program file called "SP_PROCS.PRG" using the following code:

         * Substitute the server name
         #DEFINE Connect_String 'DRIVER={SQL Server};SERVER=MY_SERVER;' + ;
            'DATABASE=PUBS;UID=sa;PWD='
         * Connect to SQL Server
         gnConnHandle=SQLSTRINGCONN(Connect_String)
         IF gnConnHandle>0
            * Create a command to execute the stored procedure
                  SQLCommand="sp_helpextendedproc"
                  * Execute the stored procedure and return data to a cursor
                  testvar=SQLEXEC(gnConnHandle,SQLCommand,'SYS_Procs')
                  ? testvar
                  * Select the cursor
                  SELECT SYS_Procs
                  BROWSE LAST
               =SQLDISCONN(gnConnHandle)
         ENDIF
         CLOSE ALL
         RETURN

2. From the Command window, type "DO SP_PROCS."

REFERENCES
==========

Transact - SQL Reference Help file, search on: "sp_helpextendedproc"

(c) Microsoft Corporation 1998, All Rights Reserved. Contributions by John Desch,
Microsoft Corporation.


Additional query words: kbVFP600 kbVFP500 kbDatabase kbvfp300b kbvfp500a

======================================================================
Keywords          :  
Technology        : kbHWMAC kbOSMAC kbVFPsearch kbAudDeveloper kbVFP300bMac kbVFP300 kbVFP300b kbVFP500 kbVFP600 kbVFP500a
Version           : MACINTOSH:3.0b; WINDOWS:3.0,3.0b,5.0,5.0a,6.0
Issue type        : kbhowto

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1999.