Re: Retrieving by program the parameter list of a stored procedure ?

From: Mike Collier (mike_at_adoanywhere.com)
Date: 01/16/04 

Date: Fri, 16 Jan 2004 11:01:34 -0000

> I know how to retrieve programmatically the list of all stored procedures
in an ADO
> database (ADOConnection.GetProcedureNames), but is it possible to know the
list
> ofparameters of a given store procedure by program?

Possibly, depends on the OLEDB Provider you are using.

Have a search in google for OpenSchema. This is the call the Delphi was
making to get your procedure names. I don't have a code example for
procedure parameters.

To find out quickly what calls are supported by OpenSchema on your system,
check out the OpenSchema GUI built into adoanywhere, currently it's FREE. 

-- 
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
http://www.adoanywhere.com/forum

Relevant Pages

  • Re: Error 0x800A0BB9 When Reconnecting in same process instance
    ... Here is the connect/disconnect methods. ... If I comment out the OpenSchema ... catch(_com_error& err) ... The database cannot be converted to 2003 because it cannot be opened in ...
    (microsoft.public.data.ado)
  • Re: OpenSchema SQLite/dhRichClient3 VB6
    ... wrapper found in cConnection. ... I took the suggestion to look into ADO to see if I ... When I tried that solution (OpenSchema), ... locate the cConnection class, it shows one of its members as ...
    (microsoft.public.vb.database)
  • Re: ANN: AnySQL Maestro (freeware cross-database tool)
    ... Also OpenSchema knows nothing about DBMS specific objects, such as tablespaces, jobs, partitions, full-text catalogs, etc. ... Also AnySQL Maestro strongly depends from OLE DB Provider / ODBC Driver you have installed. ... Do you have a product like AnySQL where I can connect to a variety of database vendors and have full database management? ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ADO AV
    ... > That is possible I have not used openSchema with any datbases that are ... Obviously the older database is not 100% ADO compliant. ...
    (borland.public.delphi.database.ado)
  • Can I get the fields in an Access table using just an SQL statement?
    ... I know I can get the fields using openschema via ADO, but for various reasons I could really do with getting the fields in table "x" with a simple sql statement. ... Any advice? ...
    (microsoft.public.access.queries)