How can I store calculated field in ms-sql. Should I use server script on row inserted or row inserting ? any example code ?
store calculated field
-
- User
- Posts: 258
If the field is existing in database table and is in the same table, you can use the Row_Inserting server event to perform the calculation e.g.:
rsnew["<calculatefield>"] = <calculatedvalue>; // Replace <calculatevalue> with actual value, add double quote if it is a string.
Read Server Events and Client Scripts -> Row_Inserting in help file for more details.