Questions tagged [4d-database]

4D is an integrated development platform containing all of the components needed to create and distribute professional applications.

History

Initially developed in 1984 by Laurent Ribardière, it was initially negotiated that 4D would be published by Apple. However, due to pressure from other database publishers, those plans eventually fell through, and 4D was published independently by Laurent Ribardière, in partnership with French businesswoman, Marylene Delbourg-Delphis.

Although independently published, Apple did support the venture and used 4D extensively throughout the organization for diverse projects such as fitness center management to CIM (Computer Integrated Manufacturing). This support from Apple undoubtedly helped the product to mature and gain traction in a difficult marketplace.

In 1987 4D was reviewed by Info World in their September 28 1987 publication.

In 1993, 4D Server, the client/server version of 4th Dimension was introduced and since 1995, 4D has supported both the Microsoft Windows and Apple Macintosh operating systems.

Syntax

The 4D syntax is unique, but bears some similarity to Visual Basic, Perl, and Python. One very unique aspect of 4D is that it's SQL engine is directly integrated into the language. The screenshot below demonstrates the Method Editor interface, showing the mixture of 4D and SQL syntax.

enter image description here

Current/Supported versions

Hotfix Versions

  • 4D v15.2 Hotfix 1, released on 4 July 2016 (fix list)
  • 4D v14.5 Hotfix 1, released on 11 July 2016 (fix list)

Legacy/Unsupported Versions

  • 4D v15.6, Final release on 25 Apr 2018; (first v15 release on 16 Jul 15).
  • 4D v14.6, Final release on 20 Dec 2016; (first v15 release on 12 Dec 13).
  • 4D v13.6, Final release on 18 Jun 2015; (first v13 release on 14 Feb 12).
  • 4D v12.6, Final release on 08 Oct 2013; (first v12 release on 03 Jun 2010).
  • 4D v11.9, Final release on 07 Jul 2011; (first v11 release on 25 Sep 2008).
  • 4D 2004.8, Final release on 30 Jun 2009; (first 2004 release on 31 Aug 2004).
  • 4D 2003.8r2, Final release on 11 Apr 2006; (first 2003 release on 17 Mar 2003).
  • 4D v6.8.6, Final release on 24 Sep 2004; (first 6.8 release on 15 Apr 2002).

Additional Resources

Related Tags

116 questions
0
votes
2 answers

can't insert in a 4D database with php odbc library

i'm trying to make an insert query with php via ODBC to a 4D Database and i get the following error : SQL error: Server rejected the connection: Failed to execute statement. , SQL state 08004 in SQLExecDirect Here's my php code :
0
votes
2 answers

Can a 4D database function be started from a unix shell script (Mac)?

We have large data sets in a 4D database. Recently we needed to automate certain tasks to export, import, or process data, which requires some connection between 4D and the unix shell (bash and zsh). We did fine whenever a 4D function had to call a…
Keve
  • 383
  • 2
  • 13
0
votes
1 answer

How do you export pictures from 4D's tool box?

I am using 4D version 11.6 (72398) in remote mode and am trying to export three pictures from a database. How do you extract pictures from the tool box? Screenshots and editing are not acceptable if avoidable.
Noctis Skytower
  • 21,433
  • 16
  • 79
  • 117
0
votes
0 answers

ODBC Query with multiple conditions gives no results

When querying a 4d database via an odbc system dsn, I am able to get back data from a statement with joins and a single, or no, where condition. This works: static void Main(string[] args) { OdbcConnection sys4dConn = new…
Dan R
  • 33
  • 8
0
votes
1 answer

How do I install this PECL package (PDO_4D) on PHP 7.1 on Red Hat 7?

I want to install the following PECL package (PDO-4D) on a Red Hat 7 server running PHP 7.1: https://pecl.php.net/package/PDO_4D The documentation doesn't seem to explain how to do this, so how do I do this?
HartleySan
  • 7,404
  • 14
  • 66
  • 119
0
votes
2 answers

Is it possible to read/write from a 4D database using SQL & PHP

I am trying to build an application that pulls data from a 4D database to fill in form options. Then allow the user to select from those options and submit the form. I am not to familiar with 4D so any advice would be appreciated.
Tyler
  • 119
  • 1
  • 11
0
votes
1 answer

Save time duration of greater that 24 hours

I have a Database in 4th Dimension. It stores its time values in number format (seconds). Now I have a Time duration of 29:30:00 ( 29 hours: 30 min : 00 Sec ) But this conflicts with the TIME rules of mySQL ( cant be > 23:59:59 ) I tried to convert…
morne
  • 4,035
  • 9
  • 50
  • 96
0
votes
1 answer

Connecting to 4D database in Power BI via ODBC

Has anyone tried connecting to a 4D database from Power BI? I keep getting this error when I try to connect. The field `Field Name` already exists in the record. What's happening is that the 4D database columns all have spaces in there. I think…
jaywhy13
  • 1,068
  • 12
  • 16
0
votes
2 answers

Pass a string to method CREATE RECORD in 4D

Can i pass a string variable to the 4D CREATE RECORD method ? or any other method i just need to set the name table as a variable. I already tried to pass a string variable but as the method only accepts table object i can't find any way to do that
two-bar
  • 3
  • 2
0
votes
1 answer

Connecting Laravel 5 to 4D application

I am working on a new project, where Laravel will be my API to an mobile app that will be develop on Ionic 2. The company has an ERP build on 4D; sincerely I have never worked with an app build on this platform. So what i need is to make queries to…
felipebla
  • 53
  • 5
0
votes
1 answer

How can I Export Data from 4D Database?

I'm working with a customer who has a simple application written in 4D database stuff from probably 20 or 25 years ago. They've been using the tool to manage a small portion of their inventory. As I understand it, that tool in its current form…
zipzit
  • 3,778
  • 4
  • 35
  • 63
0
votes
1 answer

Hide the help menu in 4D

I am developing an application using 4D as front-end and postgresql as back-end. So i don't want the help menu to be displayed at front-end side. I do some research but i don't find any 4D commands to do so. Also i went through 4D manuals which…
Suniel
  • 1,449
  • 8
  • 27
  • 39
0
votes
2 answers

What is the best practice for Wakanda to 4D error handling?

In 4D Mobile architecture, what is the best practice for ensuring that Wakanda interactions with 4D do not error resulting in thread failure. There can be many such interactions: query, entity reference col[0], .save, method calls, etc... We want to…
David Ringsmuth
  • 325
  • 1
  • 12
0
votes
1 answer

Wakanda / 4DMobile: Present contents of BLOB to client

There is a PDF in a BLOB field of a table in the 4Dv15 database that Wakanda is connected to. When I pull the BLOB from the field in a serverside script (in Wakanda), it is an object: {'size': 12915, 'type': 'application/octet-stream'} The PDF or…
NAMS
  • 983
  • 7
  • 17
0
votes
3 answers

Use 4D only as front end application

I want to develop an application using 4D fully as front end and Postgres fully as backend. Is it possible? I don't want any traces of database in front end i.e at 4D end. But here the problem is while opening/running the compiled 4D application…
Suniel
  • 1,449
  • 8
  • 27
  • 39