SDAC

TMSScript Class

A component for executing several SQL statements one by one.

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

Unit

MSScript

Syntax

TMSScript = 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 TMSSQL. Usually it is not a good solution. With only one TMSScript component you can execute several SQL statements as one. This sequence of statements is named script. To separate single statements use semicolon (;), slash (/) or keyword 'GO' . 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 TMSScript shows exception and continues execution.

If you need to create several Stored Procedures (Functions) at a single script, use slash (/) to separate commands for creating stored procedures.

Inheritance Hierarchy

TDAScript
   TMSScript

See Also

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