Clever Geek Handbook

How to update a SQL Server table based on changed values?

I am currently developing an AS3 module that loads content from a SQL Server table in a data grid. Whenever the data grid changes, the changed values ​​must be stored in the database. My question is, is there anyway I can accomplish this with just one SQL query?

I am currently running queries based on changes in each cell which is ineffective.

Thank.

+3


source to share


1 answer


Maybe added a CHANGE event listener on the data grid. Check the updated lines and build the SQL queries in a batch to improve efficiency.



0


source






More articles:


All Articles