Any tips or examples on using SQL Server stored procedures from within Delphi?
Posted on 2004-08-27
I have read and was told by the SQL Server fundies that it is preferrable to use stored procedures to manage (insert, update, delete and select) information in SQL Server.
Aparently this is faster than standard queries and also is more robust if one decides to make the front-end application a web application.
- I would like to know how to go about achieving this.
- Can I still use DB editor controls?
- What would such a front-end look like?
- Will I need to have a TADOStoredProc (or similar) component for each of the stored procedures to insert, update, delete, select one record and select all records?
- Will I still be able to use a DBNavigator?
I was thinking of a screen split in two with the upper part a grid (read only if it must be) and the lower part a panel with all the relevant columns as DB Editor components and a DBNavigator so that I can insert, update and delete using the panel and have the grid automatically maintained.
I got the feeling that this is not the suggested way of handling database access from within Delphi as it seems to me that I will have to write quite a bit of code to accomplish this.
Any comments are welcome and examples even more!
I have allocated the maximum points to this question with the idea of splitting it among all the best answers.
PS I've got a feeling that I might have opened a can of worms here :-)