BLOGS

4D V11 SQL

warning: file_get_contents(http://www.telize.com/geoip/54.80.137.168) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /var/www/www.4d.com/docs/includes/common.inc(1762) : eval()'d code on line 4.

An Interface with SVG

mån, 2009-02-16 (Hela dagen)

Take advantage of SVG (Scalable Vector Graphics) to create a resizable, map-based interface to retrieve geographic information - all with only a couple of lines of code.

Dynamic SVG

mån, 2009-02-23 (Hela dagen)

The SVG standard allows the use and manipulation of Scalable Vector Graphics. In this tutorial, learn how to programmatically generate and modify SVG images to add rich, dynamic visuals to your applications.

Data Exchange Between 4D Applications

tis, 2009-04-07 (Hela dagen)

White paper providing a historical and comparative review of data transfer techniques in 4D v11 SQL.

4D v11 SQL: Breaking the Limits

ons, 2007-11-28 (Hela dagen)

Learn all about new features in the 4D v11 SQL product line.

4D Server v11 SQL: Beyond the Limits

tis, 2009-07-21 (Hela dagen)

See what's new in 4D Server v11 SQL and 4D v11 SQL Release 2.

 

http://4d.com/sites/default/files/resources/brochure_4DServerv11SQL-EN.pdf

Hierarchical and Included Lists

These examples illustrate the use of two types of lists in 4D v11 SQL.


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:

Integrated, Native SQL

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

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.

 

Ladda ner för Windows eller Mac

 

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

 

Ladda ner för Windows eller Mac

 

4D User Forms

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.