UniDAC

TUniScript Class

A component for executing several SQL statements one by one.

For a list of all members of this type, see TUniScript members.

Unit

UniScript

Syntax

TUniScript = class(TDAScript);

Remarks

Often it is necessary to execute several SQL statements one by one. Known way is using a lot of components such as TUniSQL. Usually it is not a good solution. With only one TUniScript component you can execute several SQL statements as one. This sequence of statements is named script. To separate single statements use semicolon (;), slash (/) ,and for PL/SQL in Oracle - only slash,also keyword 'GO' for SQL Server and DELIMITER for MySQL server. Note that slash must be the first character in line.

Errors that occur while execution can be processed in the TDAScript.OnError event handler. By default, on error TUniScript shows exception and continues execution.

Inheritance Hierarchy

TDAScript
   TUniScript

See Also

© 1997-2020 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback