Page 1 of 1

MSUpdateSQL1 function and example

Posted: Sun 26 May 2013 10:42
by tcflam
Dear all,

How to use MSUpdateSQL1? What is the benefit if using MSUpdateSQL1? Any example?

Thanks!

Timothy

Re: MSUpdateSQL1 function and example

Posted: Mon 27 May 2013 08:35
by AndreyZ
Hello,

The TMSUpdateSQL component is used to provide DML statements for the dataset components that return read-only result sets. The same task can be achieved by using the SQLInsert, SQLUpdate, SQLDelete, SQLRefresh, and SQLLock properties of any SDAC dataset (TMSQuery, TMSTable, TMSStoredProc). It is up to you to decide which way is more appropriate for you.
For more information about all components and properties listed above, please refer to the SDAC documentation.

Re: MSUpdateSQL1 function and example

Posted: Mon 27 May 2013 09:21
by tcflam
Thanks for information. I downloaded the document and I will study it. I found that I need to learn more functions in SDAC. haha... :D

Re: MSUpdateSQL1 function and example

Posted: Mon 27 May 2013 11:07
by AndreyZ
If any other questions come up, please contact us.