4D v11 SQL Examples
New: Web Area | Components | SQL | Unicode
Enhanced: Lists | 4D Mailing | 4D Objects | User Management | Web
| Web Area NEW! |
|
Stock Stalker
Stock Stalker is a simple application that tracks your selected stocks. A Web Area form object displays current graphs of your stocks' performance as retrieved from the internet, with options for update interval, zoom level, date range, and more. (Many thanks to Tom Dillon for this contribution.)
|
| Web Area NEW! |
|
Web Area Demo
The new Web Area form object, introduced in 4D v11 SQL Release 2, allows you to display browser-accessible content in your 4D forms. Web sites, local HTML pages, PDFs, movies, animations, JavaScript controls - all of them are at your diposal.
This demo uses Web Area to create a simple web browser, Google Maps mashup, document viewer, and canvas viewer in 4D v11 SQL. |
| Components and Tool Palette |
|
4D Pop
4D Pop is a series of productivity components grouped into a toolbar that integrates perfectly with the 4D v11 SQL development environment. You can enhance 4D Pop with your own components, or download and share components made by the 4D developer community.
4D Pop is provided with source code, so on top of being extremely useful, it serves as an excellent example of 4D programming.
Learn more and download at the 4D Pop page. |
| SQL |
|
Integrated, native SQL language
One of the major new features of 4D v11 SQL is its integrated, native SQL language
The 4D v11 SQL language allows you to connect directly to an ODBC data source and to execute SQL queries inside Begin SQL/End SQL tags (and via the new 4D command: QUERY BY SQL).
This database shows how to carry out queries with the 4D language as well as with SQL.
Specific examples show both languages in parallel in order to compare them easily and to highlight their respective advantages.
Comments and explanations are provided during the execution of these queries.
The 1st example illustrates a simple query (which consists of finding the airports of a specific city and country).
A 2nd example illustrates a join (which consists of finding from among a selection of airports those that can be accessed via a direct flight).
A 3rd example illustrates a complex SQL query written simply using the 4D language.
A 4th example shows a complex 4D query illustrating "nested" queries in SQL. |
| 4D Indexes |
|
| This example database shows the possibilities of using indexes in 4D v11 SQL:
- new index types:
. BTree index for non-repeated values (IDs, names, etc.)
. cluster index for repeated values (Booleans, titles (M., Ms., etc.))
. composite index for sorting (FirstName+LastName, City+ZipCode,
State+City, etc.)
. keyword indexes for texts
- indexes created stored in a separate file
- etc.
To demonstrate their efficiency, this example explains how to choose the correct index type. |
| Unicode Support |
|
This database is for informative purposes. It demonstrates the ability of 4D to display Unicode characters.
It also shows the conversion of characters during the use of the Uppercase and Lowercase functions. |
| Lists |
|
Hierarchical List
This database shows the possibilities of using a hierarchical list:
- display of items of the list of colors
- multiple selections allowed
- events used: "On Expand", "On Collapse" and "On Selection Change"
- dynamically built lists
- icons from resources, object library or variables |
Included List
This database show the possibilities of included lists:
- calculated content updated according to the selections
- 4D v11 SQL customized interface (alignment, font style, etc.)
- graphic object replaces color of current selection
- display of contents of several tables in one form |
| 4D Mailing |
|
This database show how to use the "4D Write" word processor to send customized e-mails to contacts as a mail shot. |
| 4D Objects |
|
This example database shows all the interface objects managed by 4D:
- variables
- buttons
- field lists
- checkboxes
- etc.
To use it, you can click on the buttons representing the Form editor tool bar or you can select a specific type of object directly from a dropdown menu.
|
| User Management |
|
4D Passwords
This database shows how to manage users by programming.
It allows you to:
- save and restore users and their passwords (encrypted)
- use a customized connection dialog box
- remove or create new users
- create additional information for a user (icon, visibility, etc.) |
| Web (static, dynamic, FTP transfer) |
|
4D StaticWebBuilder
This database shows how to publish a relational database on the Web both statically and dynamically.
It also shows how to transfer via FTP the generated static web site using the 4D Internet Commands plug-in. Additional information is provided when running the demo. |
| Forms |
|
4D UserForms
With 4D, users can modify certain forms.
Starting with a classic "clients - invoices - invoices_lines" structure, two forms can be duplicated then modified by the users: "envelopes" and "invoices."
These two templates have been deliberately left "open" so the final user can modify the text, formats and paper orientations, as well as margins, objects, etc.
Each form can be duplicated as many times as necessary. This allows, for example, specifying several envelope formats as well as different templates for the invoices. |
Overview
| 4D RSS Feeds