Dear all,
How to use MSUpdateSQL1? What is the benefit if using MSUpdateSQL1? Any example?
Thanks!
Timothy
			
									
									
						MSUpdateSQL1 function and example
- 
				AndreyZ
 
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... 
			
									
									
						- 
				AndreyZ
 
Re: MSUpdateSQL1 function and example
If any other questions come up, please contact us.