Unable to update the transaction record cache

Problem

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.

Solution

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.