TUniUpdateSQL - usage areas

[ertank]

Hi,

I have never used this component for my needs, so far. I simply do not know what it is for, and how to use it. I could not find some detailed explanation in UniDAC documents.

Since usage may vary on database system, my main database servers currently are MS-SQL Server, FirebirdSQL, SQLite.

I appreciate any help.

[azyk]

You can find the TUniUpdateSQL component description in our online documentation: https://www.devart.com/unidac/docs/?dev ... atesql.htm . You can see a sample of using TUniUpdateSQL in UniDACDemo demo project. The UniDACDemo project is in the folder "Demos\UniDacDemo\" relatively the path where UniDAC demo projects were installed.

[ertank]

Thank you for the link. I see in the document that "You may prefer to use directly SQLInsert, SQLUpdate, and SQLDelete properties of the TCustomDADataSet descendants."

I know that TUniQuery is a TCustomDADataSet descendant. So, question is; Is there any specific/preferred use area for TUniUpdateSQL over TUniQuery?

Thanks.

[azyk]

The TUniQuery->TUniUpdateSQL components binding was used in Delphi versions for compatibility with BDE projects (the TQuery->TUpdateSQL components).

TUniUpdateSQL does not have some advantages comparing with the TUniQuery dataset properties SQLInsert, SQLUpdate... There might be some difference/usability when using specific application business-logic, objects/components structure organization, etc.