SQL Get current data source

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

4D Language Reference
- SQL
- - Overview of SQL Commands
  - On SQL Authentication Database Method
  - Begin SQL
  - End SQL
  - 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 current data source
  - SQL GET DATA SOURCE LIST
  - 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

Home

4D v20 R7

4D Language Reference

SQL

SQL Get current data source


SQL Get current data source -> Function result

Parameter	Type	Description
Function result	String	Name of current data source being used

Description

The SQL 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.