Skip to main content
Version: Next

SQL Get current data source

SQL Get current data source : Text

ParameterTypeDescription
Function resultTextName 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

Properties

Command number990
Thread safe