Hi
What is the adventage of using TMSSQL in place of TMSQuery for INSERT,UPDATE statements ?
Best regards
Bartosz
TMSSQL vs TMSQuery
Re: TMSSQL vs TMSQuery
You can use TMSSQL instead of TMSQuery to execute SQL queries which do not return a result.
In some cases the advantage to use TMSSQL instead of TMSQuery can be execution time of run-time code processing INSERT/UPDATE SQL queries. For example, the difference can become significant when executing a large number of such SQL queries.
Take into account that advantages to use TMSSQL instead of TMSQuery depend on each particular case: on business-logic, specific requirements to user application, etc.
In some cases the advantage to use TMSSQL instead of TMSQuery can be execution time of run-time code processing INSERT/UPDATE SQL queries. For example, the difference can become significant when executing a large number of such SQL queries.
Take into account that advantages to use TMSSQL instead of TMSQuery depend on each particular case: on business-logic, specific requirements to user application, etc.