BLOGS

4D V11 SQL

Unicode Support

in
This example demonstrates 4D's ability to display Unicode characters.


It also shows the conversion of characters when using the Uppercase and Lowercase functions.

 

Download for Windows or Mac

 

4D Indexes

in
This example shows the possibilities of using indexes in 4D v11 SQL.


4D v11 SQL's index types include:

 

- 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

 

This also covers indexes created stored in a separate file.

 

To demonstrate their efficiency, this example explains how to choose the correct index type.
 

Integrated, Native SQL

in
One of the major 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" and "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.

Web Area

in
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.

 

Download for Windows or Mac

 

Stock Stalker

in
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 4D developer Tom Dillon for this contribution.)

 

Download for Windows or Mac

 

SVG Goodies

in
This example demonstrates various uses of 4D SVG, from simple text formatting to advanced functions like creating images with reflections and even animation.


Requires 4D v11 SQL Release 3 or above.

Download for Windows or Mac

 

SVG Analog Clock

in
This demo uses a simple SVG file of an analog clock, animating the hour, minute and second hands based upon your system clock.


Requires 4D v11 SQL Release 3 or above.

Download for Windows or Mac

 

4D User Forms

in
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.

Theatre Seating Plan (SVG)

in
This is a simple simulation of a graphical seat selector for a theatre, showing seat availability based on a user's click.


Requires 4D v11 SQL Release 3 or above.

Download for Windows or Mac

 

4D Mailing

in
This application shows how to use the "4D Write" word processor to send customized e-mails to contacts as a mail shot.


Download for Windows or Mac