You get this error when running your application:
Microsoft Internet Explorer
Unable to update the transaction record cache.
This error is generally caused by triggers in your application’s underlying database and not by your Iron Speed Designer application itself.
To isolate the problem, insert a record into a table using the Query Analyzer or similar tool and see if it succeeds. If it fails, then there may be several underlying causes:
A database trigger is preventing the record from being inserted or updated. In this case, remove or modify the trigger in your database so that it is no longer problematic.
Your application contains a database view with a LEFT JOIN between two tables. In this case, a Virtual Primary Key or Virtual Foreign Key created in Iron Speed Designer may have been created for a field in the right side of the join. This is problematic because the field can potentially be NULL. You can fix this problem by changing the Virtual Primary Key or Virtual Foreign Key to one that is in the LEFT side of the JOIN.
Part VII: Troubleshooting Applications
Application Runs But No Data is Displayed