4D v14.3
USE EXTERNAL DATABASE
- 4D Language Reference
-
- SQL
-
- Overview of SQL Commands
- On SQL Authentication Database Method
- Begin SQL
- End SQL
- Get current data source
- GET DATA SOURCE LIST
- Is field value Null
- QUERY BY SQL
- SET FIELD VALUE NULL
- SQL CANCEL LOAD
- SQL End selection
- SQL EXECUTE
- SQL EXECUTE SCRIPT
- SQL EXPORT DATABASE
- SQL EXPORT SELECTION
- SQL GET LAST ERROR
- SQL GET OPTION
- SQL LOAD RECORD
- SQL LOGIN
- SQL LOGOUT
- SQL SET OPTION
- SQL SET PARAMETER
- START SQL SERVER
- STOP SQL SERVER
- USE EXTERNAL DATABASE
- USE INTERNAL DATABASE
USE EXTERNAL DATABASE
| USE EXTERNAL DATABASE ( sourceName {; user ; password} ) | ||||||||
| Parameter | Type | Description | ||||||
| sourceName | String |
|
Name of ODBC data source to connect to | |||||
| user | String |
|
User name | |||||
| password | String |
|
User password | |||||
This command has been replaced by the SQL LOGIN command starting with version 11.3 of 4D. It has been kept for compatibility reasons only and will not be maintained in future versions of the program.
If the command is executed correctly, the OK system variable is set to 1. Otherwise, it is set to 0 and an error is generated.
Product: 4D
Theme: SQL
Number:
959
Created: 4D v11 SQL
Get current data source
GET DATA SOURCE LIST
USE INTERNAL DATABASE
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
