BLOGS

4D V11 SQL

warning: file_get_contents(http://www.telize.com/geoip/54.81.210.99) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /var/www/www.4d.com/docs/includes/common.inc(1762) : eval()'d code on line 4.

Remote Administration

Reach your admin window remotely, or open it for your users using the OPEN ADMIN WINDOW command. Restart your servers remotely. (After compacting, for example.)

ODBC Import/Export

Import and export data using standard ODBC without writing a single line of extra code.

4D Internet Commands

This plug-in provides support for classic internet protocols for mail (SMTP, POP, IMAP), and transfers via FTP and TCP/IP. As of 4D v11 SQL, it allows the sending of messages in UTF8.

Sort Editor

Define the criteria and sort your data in any way you choose.

Formula Editor

Use the formula editor to carry out complex tasks that require the execution of a statement (query, sort, global update, etc.)

Report Editor

Design and automatically build data reports as tables, graphs or even labels.

Structure Editor

Analyze, model and design the structure of your database thanks to a high-level graphic interface.

Design and model the architecture of your database with ease using the 4D Structure Editor.

 

Structure Editor

 

Just one click
With just one mouse click and the Properties inspector, you can add tables, fields, relations, and change settings on the fly.

Integrated Database

A powerful relational database is fully integrated into 4D.

4D provides a true enterprise-class database, with the capacity to process massive databases while keeping the same responsiveness and performance you've come to expect in 4D. We've shattered all previous database size limits to give both new and existing databases much more breathing room.


It is up to the challenge of even the most demanding projects.
 

Bigger Size

Our expanded capacity lets you serve ever-increasing data storage requirements without a problem.

 

SQL Client

Integrate the power of SQL with 4D's application building tools. The SQL Client lets you have the best of both worlds in a client application.

Take advantage of the SQL engine
The 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 databases
4D natively supports all SQL 92 standards. This allows you to work with both database records (DDL) as well as the structure (DML).

Query by Formula - Standalone

Speed improvements in Query By Formula under 4D v11 SQL.

In 4D 2004, a formula is calculated for each record sequentially.

4D v11 SQL analises formulas beforehand to optimise queries. The syntactic analyzer can identify parts of the formula that can be optimised to reduce the sequential parts of the query.

Our test case involves the georeferencing (location by degree of latitude and degree of longitude) of customers. We’d like to find the customers who are within 10km of a particular point. Say we have a function, "Distance," that returns the number of kilometres (as the crow flies) between two points.