|
|
|
|
|
|
|
|
|
|
version 11
Beginning with version 11, 4D includes an integrated SQL kernel. The program also includes an SQL server that third-party applications can query (via the 4D OBDC driver).
The different ways of accessing the 4D SQL kernel, the configuration of the SQL server and the description of SQL queries are detailed in a separate manual, the 4D SQL Reference manual.
The "SQL" theme groups together various 4D commands concerning the use of SQL in 4D:
• Control of the SQL server: START SQL SERVER and STOP SQL SERVER
• Use of the integrated SQL kernel: SET FIELD VALUE NULL, Is field value Null, QUERY BY SQL, GET LAST SQL ERROR
• Direct access to SQL external data sources (SQL pass-through): GET DATA SOURCE LIST, Get current data source, Begin SQL, End SQL, USE INTERNAL DATABASE, USE EXTERNAL DATABASE.
|
|
|
|
|
|
|
|
|
|