Specifies where and how to create your application’s SQL. Iron Speed Designer automatically creates 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 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 create stored procedures in all cases, even though you have selected this option. In these cases, Iron Speed Designer will create inline SQL. For example, Iron Speed Designer cannot create stored procedures for Microsoft Access databases, a database product which does not support stored procedures. Also, Iron Speed Designer will not create 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 create 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 created.
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 created. For example, a view without a Virtual Primary Key cannot have an Update stored procedure created.
The Stored Procedures option is set to 'true' in the <App Name>.config file.
<add key="GenerateStoredProcedures" value="True" />
Iron Speed Designer creates stored procedures using the user name you provide to log into the database. We recommend you select the final user name you want to use in production. For example, this is frequently ‘dbo’ for Microsoft SQL Server databases.
Iron Speed Designer generates dynamic SQL and Stored procedures to supports optimistic concurrency. I.e. if record has been changed after it was opened in the browser data access layer will prevent it from saving and give user a warning. You can override this behavior for dynamic SQL and force Data Access layer to save record without checking by setting SupportConcurrency key to False in the web.config.
Creating Your First Application