Skip to main content
Version: Next

SQL Get current data source

SQL Get current data source -> Function result

ParameterTypeDescription
Function resultString🡐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.

See also​

Begin SQL
End SQL
SQL GET DATA SOURCE LIST
SQL LOGIN
SQL LOGOUT