Skip to main content
Version: 20 R7 BETA

SQL Get current data source

SQL Get current data source : Text

ParameterTypeDescription
Function resultText←Name of current data source being used

This command is not thread-safe, it cannot be used in preemptive code.

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