4D v13.4
Begin SQL
- 4D Language Reference
-
- SQL
-
- Overview of SQL Commands
- On SQL Authentication Database Method
- Begin SQL
- End SQL
- Get current data source
- GET DATA SOURCE LIST
- Is field value Null
- QUERY BY SQL
- SET FIELD VALUE NULL
- SQL CANCEL LOAD
- SQL End selection
- SQL EXECUTE
- SQL EXECUTE SCRIPT
- SQL EXPORT DATABASE
- SQL EXPORT SELECTION
- SQL GET LAST ERROR
- SQL GET OPTION
- SQL LOAD RECORD
- SQL LOGIN
- SQL LOGOUT
- SQL SET OPTION
- SQL SET PARAMETER
- START SQL SERVER
- STOP SQL SERVER
- USE EXTERNAL DATABASE
- USE INTERNAL DATABASE
Begin SQL
| Begin SQL | ||||||||
| Does not require any parameters | ||||||||
Begin SQL is a keyword used in the Method editor to indicate the beginning of a sequence of SQL commands that must be interpreted by the current data source of the process (the integrated SQL engine of 4D or any source specified via the SQL LOGIN command).
A sequence of SQL commands started with Begin SQL must be closed with the End SQL keyword.
These keywords work as follows:
- You can place one or more blocks of Begin SQL/End SQL tags in the same method. You can generate methods made up entirely of SQL code or mix 4D code and SQL code in the same method.
- You can write several SQL statements on the same line or on different lines by separating them with a semi-colon “;”. For example, you can write:
Begin SQL
INSERT INTO SALESREPS (NAME, AGE) VALUES (Henry,40);
INSERT INTO SALESREPS (NAME, AGE) VALUES (Bill,35)
End SQLor:
Begin SQL
INSERT INTO SALESREPS (NAME, AGE) VALUES (Henry,40);INSERT INTO SALESREPS (NAME, AGE) VALUES (Bill,35)
End SQLNote that the 4D Debugger will evaluate the SQL code line by line. In certain cases, it may be preferable to use more than one line.
Product: 4D
Theme: SQL
Number:
948
Created: 4D v11 SQL
End SQL
Get current data source
SQL LOGIN
