Dear all,
How to use MSUpdateSQL1? What is the benefit if using MSUpdateSQL1? Any example?
Thanks!
Timothy
MSUpdateSQL1 function and example
Re: MSUpdateSQL1 function and example
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.
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
Thanks for information. I downloaded the document and I will study it. I found that I need to learn more functions in SDAC. haha...
Re: MSUpdateSQL1 function and example
If any other questions come up, please contact us.