Difference between revisions of "EXECUTE IMMEDIATE"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| 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 19: | Line 19: | ||
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
| − | |statement||The SQL DELETE, INSERT or UPDATE statement, or | + | |statement||The SQL DELETE, INSERT or UPDATE statement, or Recital command to execute immediately. |
|- | |- | ||
|} | |} | ||
| Line 26: | Line 26: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | EXECUTE IMMEDIATE set deleted off | + | EXECUTE IMMEDIATE set deleted off |
</code> | </code> | ||
Latest revision as of 11:29, 24 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 Recital command to execute immediately. |
Example
EXECUTE IMMEDIATE set deleted off
Products
Recital, Recital Server
