V11 Customizing SQL Insert Update and Delete Statements Part 1
Uploaded on Aug 16, 2013 / 289 views / 614 impressions / 0 comments
Video for ID 78 and SSE12
Alpha Five v11 On before SQL execute 1
In a Grid component that is based on a SQL database, the Insert, Update and Delete SQL statements that are executed when a user inserts, updates or deletes a record are automatically computed by Alpha Five.
In some cases, a user might want more control over how these SQL statements are executed, or might want to use stored procedures to insert, update or delete records.
The onBeforerSQLCommandExecute and onAfterSQLCommandExecute server side events allow you fully customize the SQL statements that the Grid executes in order to insert, update or delete records.
In addition, another common use for these events is to update some other table at the same time as the update is being performed in the tables the Grid is based on. For example, you might want to add a record to a log table.
When you perform updates against some other table as part of our update, insert or delete, you might want to wrap the entire operation into a single transaction. This is easily done by starting a transaction in the onBeforeSQLCommandExecute event and then either committing or rolling back the transaction in the onAfterSQLCommandExecute event.
These videos discuss these new events.