UseDataSource

This command will disable the server's auto processing of SQL statements to determine their correct source and will instead route all SQL traffic to the specified data source. Specifying zero will re-enable the server’s auto processing and let it determine which data connection should receive the SQL statement based on which connection was used to download the table structures.

Group: Database Related Extensions

Syntax:

[bValue =] DB.UseDataSource(vSource)

bValue     (Boolean) Optional – indicates success or failure of the language extension

vSource   (Variant) is the name or number of the data source to which all future SQL traffic will be routed.

Example: