Difference between revisions of "EXECUTE IMMEDIATE"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
| − | Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital | + | Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command |
| Line 12: | Line 12: | ||
==Description== | ==Description== | ||
| − | The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital | + | The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command. |
| Line 26: | Line 26: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | EXECUTE IMMEDIATE set deleted off | + | EXECUTE IMMEDIATE set deleted off |
</code> | </code> | ||
Revision as of 15:54, 22 December 2009
Purpose
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command
Syntax
EXECUTE IMMEDIATE <statement>
See Also
Description
The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command.
| Keywords | Description |
|---|---|
| statement | The SQL DELETE, INSERT or UPDATE statement, or 4GL command to execute immediately. |
Example
EXECUTE IMMEDIATE set deleted off
Products
Recital, Recital Server
