4D 11 SQL Release 4

4D 11 SQL Release 4 is an excellent tool which allows you to develop, deploy, communicate with and take advantage of virtually any type of professional business application on Mac, Windows, and on the web.

11 Reasons to Use 4D v11 SQL:

• Ease of Implementation
• • Simplified installation
  • Graphic environment
  • Clear syntax
  • Only three executables across the entire product line
• Completely Integrated  
• • A single environment from creation to execution
  • Relational & transactional database
  • IDE
  • Language
  • Application server
  • HTTP server
  • SQL server
  • Numerous helpers and extensions
  • Connectivity
• More Productivity
• • Intuitive Method Editor
  • Pre-defined form objects
  • Override default behavior
  • High-level, event-driven language
  • Reusability of code
• Agile Development 
• • Flexible data structure
  • Debugging and modification on the fly
  • Real-time compilation
  • Modular component achitecture
  • Team development
• Easy Application Generation
• • Double-clickable applications
  • Client/Server applications
  • Web applications with integrated database and HTTP server
  • True application server
• Open Standards  
• • SQL
  • Unicode
  • XML
  • Native management of graphic formats
  • Web standards
  • much more...
• Easy Maintenance
• • Integrated backup
  • Automatic crash recovery
  • "Zero Administration"
  • Automatic updating
  • Easy version deployment
• Cross-Platform
• • Windows XP, Vista, 2003 Server, Mac OS X
  • Cross-platform stylesheets
  • Simultaneous connection by clients on different operating systems
  • No need to convert source code or data
• Scalability  
• • A project can go from 1 to 32,000 tables, without stopping its operation
  • Go from standalone to hundreds of users, locally or on the Web, without changing any source code
  • Be autonomous while integrating with other systems
• Economic Benefits No need for a server system
• • Free standalone deployment
  • Discount for concurrent users
  • Complete development environment
  • Unlimited SQL access based on number of cores/processors
  • Simplified administration
  • Fewer development and support resources necessary
  • A Quick Study
  • No special prerequisites
  • Usable results from your first steps
  • Intuitive language and development environment
  • Committed to standards
  • No difficulty at all or anyone with solid computer abilities

Major Features:

1. 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.
   • 4DLink in XML: Easily automate connections with your 4D applications using 4DLink files in XML format.
2. Design Environment
   • Explorer: View every element of your application at a glance.
   • Structure Editor: Analyze, model and design the structure of your database thanks to a high-level graphic interface.
   • Index Explorer: View every index in your application at a glance.
   • 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.
   • Debugger: A suite of integrated code debugging tools.
   • 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.
   • 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.
   • 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.
   • 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.
   • 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.
   • 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.
   • Maintenance and Security Center (MSC): A toolset for 4D database monitoring, maintenance, optimization, and backups. Can be run manually or automatically.
3. 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.
4. 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.
   • SQL Server: Query any SQL database via a native ODBC Driver using 4D's new, integrated SQL server.
5. Clients
   • Data Client: TheEnhancements:
     
     • Internal Improvements: As an update release, 4D v11 SQL Release 4 contains numerous under-the-hood improvements and optimizations that increase stability and reliability, as reported by users in contact with 4D's quality department. Please see the fixed bug list linked at the bottom of this page.
       
     • Support for Windows DEP: 4D v11 SQL release 4 applications are compliant with DEP (Data Execution Prevention) specifications. Designed by Microsoft and included in Windows Vista, XP SP 2, and Windows Server 2003, DEP "is a set of hardware and software technologies that perform additional checks on memory to help prevent malicious code from running on a system".
     • Windows DEP:
     • • To be able to work in systems where DEP is employed, applications must either be compliant with this system or be included in the list of applications that are exempted from the control.
       • 4D v11 SQL Release 4 lets you execute your 4D applications under DEP, without any additional configuration required. Note that any plug-ins used must also be compliant with DEP.
     • Language Updates: 4D v11 SQL Release 4 introduces a new parameter for menu management commands, wherein "special" characters in menu items are considered standard characters, and not metacharacters. Several of the menu commands have been renamed for greater clarity.
     • New parameters are also available for the SET DATABASE PARAMETER, GET DATABASE PARAMETER, and SQL SET OPTION commands.
     • "System Folder" constants have also been renamed in order to more accurately reflect system folder architecture under both Mac OS and Windows.
     • Design Mode: In list boxes, it is now possible to display disabled (greyed-out) three-state checkboxes. Disabled checkboxes can simply be displayed by calling out negative values.
     • 4D Pack: A new command is available in 4D Pack (AP MODIFY METHOD), and the existing AP CREATE METHOD command has been updated. These two commands are found in the "4D Pack: Utilities" theme.
     • SVG Viewer4D SVG Component: Three commands have been updated (SVG_SET_DIMENSIONS, SVG_SET_STROKE_WIDTH, and SVG_PATH_ARC) and the strokeWidth parameter now accepts Real values under 13 commands.

     Requirements:
     

     • MacIntel ® or PowerPC (G5 recommended)
     • (MacIntel® only for 4D Server v11 SQL)
     • Mac OS 10.4.11 or later
     • 512 MB RAM (1 GB recommended)
     • Screen Resolution 1280x1024