Kbase P51042: Is it required to have a line break after a SQL statement ending with
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Is it required to have a line break after a SQL statement ending with " ; " in SQLExplorer?
FIX:
SQLExplorer requires a line break after a statement (ending with " ; ")
This is an SQLExplorer requirements not SQL syntax requirement.
For example:
INSERT into pub.customer (name, custnum) values('King, the', 88); INSERT into pub.customer (name, custnum) values('John Johnsen', 879);
Commit work;
=> will fail with syntax error.
While this will work:
INSERT into pub.customer (name, custnum) values('King, the', 88);
INSERT into pub.customer (name, custnum) values('John Johnsen', 879);
Commit work;