BLOGS

4D V11 SQL

Explorer

View every element of your application at a glance.

The Explorer is the 'nerve center' of your application development process. It's a powerful, in-depth tool that lets you look at your entire database and access each element in the blink of an eye.

 

Explorer - Methods

Menu Editor

Use this tool to create drop-down menus and sub-menus for your applications.

Menus are a critical tool in all professional applications. 4D has created a powerful editor to help you build them as easily as possible.


Menus… à la carte!
You can set up all of the menus for your application, as well as their related sub-menus, using a single screen.

 

Picture Management

A centralized library to help you organize all the pictures and graphics used in your application.

Pictures used in 4D maintain their original format and type for both display and storage.


Native support
4D supports a number of picture formats natively (JPEG, PNG, BMP, GIF, TIF, and PICT) without requiring QuickTime. In addition, EMF is natively supported on Windows, and PDF on Mac.

Maintenance & Security Center

A toolset for 4D database monitoring, maintenance, optimization, and backups. Can be run manually or automatically.

4D provides an integrated Maintenance and Security Center (MSC) that makes running and managing your databases much simpler and easier.

 

Database administrators (and, if you wish, users) now have access to a fully functional graphic toolset for 4D database maintenance, optimization, and backups.

 

4D Plug-in SDK

The open source 4D Plug-in SDK is an essential tool that simplifies the task of developing 4D plug-ins. It writes the code 4D needs to correctly load a plug-in, allowing you to concentrate on your own code.

One of the strongest points in 4D is its ability to integrate plug-ins, written in C or C++ language. Plug-ins add to the richness of the 4D language and interface.


Add new commands
Although the 4D language already contains one thousand commands, developers can use C or C++ to come up with more ways to enhance and extend its functionality. These plug-ins allow 4D applications to meet business-specific needs or to achieve complex integration with other environments.

4D ODBC Driver

Access your database from other applications via the ODBC protocol.

Thanks to the 4D ODBC driver, any application able to “speak” ODBC can access the data in your 4D databases.


This makes it easy to produce graphs and reports using your data with Crystal Reports or Microsoft Excel, or even to create a Microsoft Word report, merge it with a set of contacts, and e-mail everyone the resulting documents.

 

More openness
With ODBC is supported in both Windows and Mac OS, you can run fully cross-platform applications using these functions.

 

4D v11 SQL in a Real Application

4D v11 SQL performance tests under real-world conditions.

 

Is the whole greater than the sum of its parts?

 

This is the question we had in mind when creating some of the new algorithms in 4D v11 SQL. Although every command has received individual attention, and while we know how to assess their improvements through unit tests, it’s the perception of the user that determines the total improvement in performance.

 

Web Services Server

4D has one-click integration with Web Services, making it easy to take advantage of the Web's openness in a 4D application.

Web Services Wizard

For developers new to Web Services, this wizard sets them up for you.

Form Wizard

Lets you generate user-friendly dialog boxes to display your data.