Feature List

We've provided below a comprehensive list including what's new and improved in the 4D v11 SQL product line. For a detailed list of what's new in the latest releases by version, please see the Release Notes.

Running Applications
Interpreted	Run your applications in interpreted mode when you want to edit them on-the-fly.
Compiled	Compiled mode lets you protect your code and optimize running speed.
Integrated database	A powerful relational database is fully integrated into 4D. Learn more
4DLink in XML	Easily automate connections with your 4D applications using 4DLink files in XML format.
Design Environment
Explorer	View every element of your application at a glance. Learn more
Structure Editor	Analyze, model and design the structure of your database thanks to a high-level graphic interface. Learn more
Index Explorer	View every index in your application at a glance. Learn more
Form Editor	Design the dialog boxes for your application and directly integrate database fields. Insert native system objects by drag and drop. A magnetic grid can be used in order to maintain interface standards.
Method Editor	Write both 4D and SQL code in the same intuitive and user-friendly editor. Learn more
Debugger	A suite of integrated code debugging tools. Learn more
Spellcheck	An integrated spellchecker for your data, with support for most common languages and custom dictionaries.
User and Group Editor	4D user and group security lets you lock down access to all or parts of your application. You can also use it to control collaborative development permissions.
Menu Editor	Use this tool to create drop-down menus and sub-menus for your applications. Learn more
Help Tips Editor	A built-in pop-up tooltips editor that lets you improve the user experience with helpful text.
Picture Management	A centralized library to help you organize all the pictures and graphics used in your application. Learn more
List Editor	Helps you manage and edit all lists within your application.
Resource Explorer	Manage your image and text resources for localization. Add, and distribute your resources to all your clients - live - without restarting the server. Learn more
Style Sheet Editor	A useful tool to help you implement a consistant visual style across your entire application. Style sheets can be customized per-operating system to present a more uniform interface.
Filter and Format Editor	This editor lets you define filters and formats to increase consistancy in data entry and display.
Syntax Check	Checks the syntax of your code to make sure you are ready to compile your application.
Compiler	A cross-platform compiler. Compiled code runs faster and is more secure.
Remote Compilation	Remotely compile your applications from the client end using 4D Team Developer Professional, without having to stop the server.
Application Builder	The builder walks you through all the steps to finalize your application and bundle it up for deployment. Entirely script-driven, this tool can also be automated for greater productivity. Learn more
Integrated Backup	Run backups of your data, as well as a tool to restore data from an archive. All the parameters can be set programmatically to fully automate the backup system.
Find and Replace	Take advantage of this powerful application-wide search and replace tool. You can automatically rename or prefix variables, project methods and forms. Learn more
Object Library	You can store objects and other code snippets to easily reuse them or share them with other developers.
4D Plug-in SDK	The 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. Learn more
Maintenance and Security Center (MSC)	A toolset for 4D database monitoring, maintenance, optimization, and backups. Can be run manually or automatically. Learn more
Wizards
Form Wizard	Lets you generate user-friendly dialog boxes to display your data.
Web Services Wizard	For developers new to Web Services, this wizard sets them up for you. Learn more
Servers
Data Server	Publish your database in client/server mode and allow multiple users to access it via a network.
Application Server	For team application development; 4D automatically manages all necessary locking and/or updating to maintain integrity.
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. Now enhanced with DIGEST authentication. Learn more
SQL Server	Query any SQL database via a native ODBC Driver using 4D's new, integrated SQL server.
Clients
Data Client	Our updated 4D Client has been optimized to reduce network traffic; now, only modified data is sent across the network.
Web Services Client	Easily call on Web Services using 4D as a Web Services Client. Learn more
SQL Client	You can finally 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. Learn more
Application mode/Data access
Sort Editor	Define the criteria and sort your data in any way you choose.
Query Editor	Helps you build simple or complex data queries via integrated query editors.
Formula Editor	Use the formula editor to carry out complex tasks that require the execution of a statement (query, sort, global update, etc.)
User Form Editor	Give your users the ability to customize specified forms according to their own needs without developer intervention.
Runtime Explorer	Lets you analyze the use of memory, variables, processes and many other indicators when your application is running.
Report Editors	Design and automatically build data reports as tables, graphs or even labels.
Extension
4D Write	Powerful word processing tools integrated right inside of 4D.
4D View	An advanced spreadsheet integrated into 4D that can be entirely controlled via the 4D language.
SQL Pass-Through	Communicate natively with external data sources.
4D ODBC Driver	Access your database from other applications via the ODBC protocol. Learn more
4D Internet Commands	Support for classic internet protocols for mail (SMTP, POP, IMAP), and transfers via FTP and TCP/IP. Now allows the sending of messages in UTF8.
Native ODBC commands	Communicate with other data sources via ODBC as if they were part of your own application using a dedicated set of 4D commands
ODBC Import / Export	Import and export data using standard ODBC without writing a single line of extra code.
4D ODBC Pro	Communicate with other data sources through standard ODBC. Thanks to its "low level" architecture, this plug-in provides you with unlimited ODBC connectivity.
4D for OCI	Communicate natively with Oracle using the Oracle Call Interface (OCI).
Creation of Compiled Components	Build code libraries or applications and make them reusable and integrable into other developments by simple drag and drop. Compiling the component makes it faster and lets you protect your source code. Learn more
Creation of Interpreted Components	Build code libraries or applications and make them reusable via drag and drop. Learn more
4D Web 2.0 Pack	Integrate Web 2.0 functionality into your applications using the 4D Web 2.0 Pack, a set of tools, plug-ins and components that help you build more dynamic Web applications. Learn more
Server Administration
Admin Window	A new, more complete administration window gives you a heads-up view of all 4D Server metrics and direct access to primary server maintenance procedures. Learn more
Remote Administration	Reach your admin window remotely, or open it for your users using the OPEN ADMIN WINDOW command. Restart your servers remotely. (After compating, for example.)
Server
Server-Side Code Execution	New method parameter - "Execute on server" - allows a method to be executed on the server, reducing considerably the number of requests exchanged with the client.

When the solution matters

International Sites

Product Lines

Solutions

Corporate

Support

Purchase

Feature List