SQL

Take advantage of the new SQL engine

The new native SQL engine in 4D allows developers to implement industry-standard SQL within their 4D applications. Learning the 4D language is no longer a requirement to building an application with 4D.

Manage all of your database

4D now natively supports all SQL 92 standards. This allows you to work with both database records (DDL) as well as the structure (DML).

One standard, many options

Because every developer has different needs, we've created a number of ways to integrate SQL into 4D.

The two most common methods are the IMMEDIATE EXECUTE command for basic queries, or the START SQL / END SQL command for more advanced code.

Complete 4D integration

• Seeing a SQL Query in 4D

Native integration of SQL in 4D is so complete that not can you use the two languages within a single method, but you can also use the results of SQL queries in 4D objects (such as variables, fields, or controls like a ListBox).

Here’s a simple example: viewing the result of a request in an array is as easy as 1-2-3.

1) Place a ListBox in a form

2) Add your query in the execution script of a button

3) Run it and see the result

4D automatically created the necessary columns and headers for you before filling the ListBox with data.

Communicate with remote sources

Integrating SQL support also means that 4D can more easily communicating with external data sources. This includes other 4D databases as well as Oracle, MySQL, or other external databases. A SINGLE line of code allows you to redirect your request to external data sources.

Now you can adapt to a changing environment without having to rewrite your application!

<< Web Services

Back to the feature list

4D ODBC Driver >>