Tuesday, November 30, 2010

Verifying SQL Inserts

There is a new option you can turn on or off in the Global Personalization screen that will "Verify SQL Insert when Adding Records". If this option is turned on, the program will check to make sure the new record has been added successfully before continuing. If the Add action fails, you are left in edit mode and either have to Save again or Cancel. An "ERR_INSERT" text message is created in the main ZPSQL folder as well. This new option should only be used for troubleshooting as it does cause an extra SQL call to the internet each time you add a record to an application database. All of the application databases have been updated to support this new option. The downloads are available now.

No comments:

Post a Comment