Iron Speed Designer creates the following stored procedures for each database table and database view used in your application:
Transact-SQL Stored Procedures |
Purpose |
<PREFIX>Add |
Insert a single record in the table. |
<PREFIX>Delete |
Delete a single record from the table. |
<PREFIX>DeleteRecords |
Delete a set of records based on search criteria. |
<PREFIX>DrillDown |
Get a list of distinct column values based on search criteria. |
<PREFIX>Export |
Export records from the table based on search criteria. |
<PREFIX>Get |
Get a single record from the table. |
<PREFIX>GetList |
Get a list of records based on search criteria. |
<PREFIX>GetStats |
Get summarized or calculated information from a table based on search criteria. Several possibilities include counting records, summing or averaging values. |
<PREFIX>Update |
Update a single record in the table. |
Each procedure is uniquely named because Microsoft SQL Server (Transact-SQL) does not have the concept of a package. Each stored procedure name is prefixed with:
p<APP NAME><TABLE>
<APP NAME> is the name you assigned to the application when you created it.
<TABLE> is the name of the table upon which the procedure operates.
For example, the Add procedure for an Employee table in an application whose name is HR is named:
PHREmployeeAdd
Please note that if two developers are building applications using the same physical database on the same server, then they must use different application names for their respective applications. If the two names are the same, possibly because they are both working on the same application, then the stored procedures will have the same names and will be constantly overwriting each other's stored procedures. Iron Speed Designer does not generate Stored Procedures for dynamic queries used by QuickSelector, Charts and aggregate controls and uses instead inline code. If your application requires only using stored procedures without exceptions do not use these controls.
There is a 4K limit on parameters passed to stored procedures in Microsoft SQL Server.
Add Transact-SQL Stored Procedure
Delete Transact-SQL Stored Procedure
DeleteRecords Transact-SQL Stored Procedure
DrillDown Transact-SQL Stored Procedure
Export Transact-SQL Stored Procedure
Get Transact-SQL Stored Procedure
GetList Transact-SQL Stored Procedure