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... 

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