Skip to main content
Version: 21 R3

SQL Get current data source

SQL Get current data source : Text

ParameterTypeDescription
Function resultText←Name of current data source being used
History
ReleaseChanges
19 R5Renamed
11 SQLCreated

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 safeno