/****** This script was created using the Data Springs Dynamic Forms Update Data SQL Routine ******/ /****** - This SQL Script should be executed as a SQL Completion Event to update data into your custom table. ******/ /****** - You should always review your SQL query created. ******/ /****** - Note: Creating update SQL queries and using SQL events is not required to capture data, your form data is alreay stored in standard related tables. ******/ /****** Inserting data into a custom table should only be used for advanced data manipulation or custom application requirements. ******/ /****** - Example implementations might include insert/update/delete custom workflow implementation requirements, backup log of data, or other related implementations. ******/ Update {databaseOwner}[{objectQualifier}DynamicForms_CustomTable_1197] Set [DSParam1] = '$(DSParam1)', [DSParam2a] = '$(DSParam2a)', [GenHTML] = '$(GenHTML)', [FirstNameonkeyup] = '$(FirstNameonkeyup)', [LastNameonkeyup] = '$(LastNameonkeyup)', [Phone] = '$(Phone)', [FavoriteProduct] = '$(FavoriteProduct)', [New Field] = '$(New Field)', [SQLType] = '$(SQLType)' Where UniqueCompletionID = '$(DSParam1)'