Specifies where and how to generate your application’s SQL. Iron Speed Designer automatically generates all the SQL statements required for each database-connected form, web page, table, and report in your application, as well as all the database access logic and storage management code. You do not need to know any SQL to build applications in Iron Speed Designer. The generated SQL is based on your database schema and user interface design. A variety of data filters and navigation components provide your end-users with additional viewing and reporting flexibility.
Iron Speed Designer may not be able to generate stored procedures in all cases, even though you have selected this option. In these cases, Iron Speed Designer will generate inline SQL. For example, Iron Speed Designer cannot generate stored procedures for Microsoft Access databases, a database product which does not support stored procedures. Also, Iron Speed Designer will not generate stored procedures in cases where it detects your database access credentials do not have sufficient permissions to load stored procedures into the database or execute them once there.
Other reasons why Iron Speed Designer can’t generate stored procedures include:
Your database is “read only”. Check your database permissions to see if any setting has changed to make it read-only, which means stored procedures will not be generated.
Your database tables or views are missing primary keys or Virtual Primary Keys. Check if the changes made to your database views render them capable of having stored procedures generated. For example, a view without a Virtual Primary Key cannot have an Update stored procedure generated.
The
Stored Procedures option is set to 'true' in the <App Name>.config
file.
<add key="GenerateStoredProcedures" value="True"
/>
Creating Your First Application