1

I am trying to display T-SQL of stored procedure in my delphi application.

I have no idea whether it is possible using ADO or Firedac components. I am able to get list of stored procedures using firedac but not sql.

Need to be pointed to the right direction so that i can add this feature in my application.

Improve this question
7
  • 1
    There's no native FireDAC API way. Use one of the suggested T-SQL ways. Commented May 1, 2018 at 8:57
  • 1
    In addition to what @Victoria said, you might take a look at this SO q:stackoverflow.com/questions/467482/… Commented May 1, 2018 at 9:45
  • 1
    The sys.* views contain object information including source in sys.sql_modules and a list of procedures in sys.procedures. Commented May 1, 2018 at 12:51
  • Why are you showing the contents of your stored procedures in an application? Most of the time this is a very bad idea. Commented May 1, 2018 at 14:29
  • @Sean, very bad idea in what exactly? I would say, if you want to show DDL in your application, you have a reason. For the rest are user rights. If somebody fails at managing them is administrator's responsability. Commented May 1, 2018 at 21:38
Related questions
7
Delphi: How to get the value of an output parameter of a stored procedure?
0
Passing parameter values from Delphi to a SQL Server stored procedures by name
3
What is the proper way to dynamically create and call a stored procedure in Delphi using FireDac?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.