MSUpdateSQL1 function and example

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tcflam
Posts: 62
Joined: Tue 01 Jan 2013 10:48

MSUpdateSQL1 function and example

Post by tcflam » Sun 26 May 2013 10:42

Dear all,

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

Thanks!

Timothy

AndreyZ

Re: MSUpdateSQL1 function and example

Post by AndreyZ » Mon 27 May 2013 08:35

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.

tcflam
Posts: 62
Joined: Tue 01 Jan 2013 10:48

Re: MSUpdateSQL1 function and example

Post by tcflam » Mon 27 May 2013 09:21

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

AndreyZ

Re: MSUpdateSQL1 function and example

Post by AndreyZ » Mon 27 May 2013 11:07

If any other questions come up, please contact us.

Post Reply