<< Click to Display Table of Contents >> Navigation:  »No topics above this level« DbiOpenSPList

C syntax

DBIResult DBIFN DbiOpenSPList (hdb, bExtended, bSystem, pszQual, phCur );

Delphi syntax

function DbiOpenSPList (hDb: hDBIDb; bExtended: Bool; bSystem: Bool; pszQual: PChar; var hCur: hDBICur): DBIResult stdcall;

Description

The function DbiOpenSPList creates a table containing information about the stored procedures associated with the database. Records in the table are described by SPDesc.

Parameters

hDb                Type: hDBIDb                (Input)
Specifies the database handle associated with the database where the stored procedure exists.

bExtended                Type: BOOL                (Input)
Not currently used.

bSystem                Type: BOOL                (Input)
True to include system procedures

pszQual                Type: pCHAR                (Input)
Must be null.

phCur                Type: phDBICur                (Output)
Pointer to the cursor handle

Completion state

The parameter phCur points to the returned cursor handle. The table contains information about all stored procedures in the database associated with the specified database handle. If the associated database is a standard database, only the stored procedures in the current directory of the database are listed in the table. The record description for the table is SPDesc.