|
TDAScript Class |
|
|
|
TDAScript Class |
|
Makes it possible to execute several SQL statements one by one.
For a list of all members of this type, see TDAScript members.
TDAScript = class(TComponent);
Often it is necessary to execute several SQL statements one by one. This can be performed using a lot of components such as TCustomDASQL descendants. Usually it isn't the best solution. With only one TDAScript descedant component you can execute several SQL statements as one. This sequence of statements is called script. To separate single statements use semicolon (;) or slash (/) and for statements that can contain semicolon, (for example, CREATE TRIGGER or CREATE PROCEDURE) only slash. Note that slash must be the first character in line.
Errors that occur during execution can be processed in the TDAScript.OnError event handler. By default, on error TDAScript shows exception and continues execution.