4D v13.4
Get current data source
- 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
Get current data source
| Get current data source -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| Function result | String |
|
Name of current data source being used | |||||
The Get current data source command returns the name of the current data source of the application. The current data source receives the SQL queries executed within Begin SQL/End SQL structures.
When the current data source is the local 4D database, the command returns the string “;DB4D_SQL_LOCAL;”, which corresponds to the value of the SQL_INTERNAL constant ("SQL" theme).
This command lets you check the current data source, generally before executing an SQL query.
Product: 4D
Theme: SQL
Number:
990
Created: 4D v11 SQL
Begin SQL
End SQL
GET DATA SOURCE LIST
SQL LOGIN
SQL LOGOUT
