Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

get a list of stored procedures

Posted on 2008-06-22
3
227 Views
Last Modified: 2013-11-23
get a list of stored procedures to populate a dropdown
0
Comment
Question by:ajb2003
3 Comments
 
LVL 3

Accepted Solution

by:
Mamouri earned 50 total points
ID: 21840771

  ADOConnection1.GetProcedureNames(ComboBox1.Items);

Open in new window

0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 21842059
for what database ?

oracle:
select * from all_procedures
or
select * from user_procedures

mysql
show procedures

mssql
select * from master.sysobjects where type = 'P'
0
 
LVL 2

Expert Comment

by:Ustin19
ID: 21853954
for firebird\interbase
select rdb$procedure_name from rdb$procedures
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question