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
1 answer

Differential backup in 4D database

I am developing an accounting application in 4D. So, I need to take differential backups everyday. I tried to take backups by configuring in database settings but 4D only takes the full backups (not differential backup). Do 4D database support…
Suniel
  • 1,449
  • 8
  • 27
  • 39
0
votes
1 answer

Is there a way to connect to 4d database from oracle

In our work environment We have old 4D database system. we want to migrate the data to oracle, before that i would like to connect the 4d database tables and other objects from oracle database. This is totally new to me. I would appreciate if anyone…
user3171342
  • 51
  • 2
  • 10
0
votes
2 answers

Is there such a thing as an ODBC driver which will connect to any SQL-92 database?

If a database has been written to the SQL-92 standard why does it need a proprietary driver? Is there a Python library which would let me interact with a standard SQL-92 database? The database is 4D v12 SQL and they don't have a 64 bit driver…
dave
  • 572
  • 7
  • 16
0
votes
1 answer

ODBC connection in Windows Service fails on second connection attempt

I wrote a .Net Windows service to copy data from a 4D database (v12) to a SQL Server database every 4 hours. It is running on Windows 7 32-bit and running as Local System. I am using version 12.02 of the 4D ODBC driver. When the service 1st runs…
CHS
  • 965
  • 2
  • 18
  • 29
-1
votes
3 answers

Export data from 4D database / convert 4D-database to free SGBD

Is there a way to convert a 4D database to a free SGBD like MySQL ? If no, is there a way to export tables from a 4D database to a csv file ?
bndgte
  • 1
  • 1
-1
votes
1 answer

4D SQL (v15.6): mix of JOINS + WITH clause + INNER queries on FROM, SELECT

Has anyone here worked with 4D SQL anytime? Our corporate application it's based on this, and through ODBC conector (I've tried multiple versions of ODBC driver, and now I'm currently using v17 on x64) and I can use a DB manager like DBeaver, to…
Lightworker
  • 593
  • 1
  • 5
  • 18
-1
votes
2 answers

what is the purpose of __STAMP column in 4D?

There are two columns which are __KEY and __STAMP using by 4D. __KEY is for Primary key. Would like to understand the usage and behavior of having the __STAMP column in 4D?
-1
votes
2 answers

Automatic Sales Tax in 4D

I'm hoping there is a soul out there who has some experience with 4D SAS. We use it for our inventory/sales management. What I am struggling with now is how to set up some sort of system to automatically calculate sales tax within our own state etc.…
-2
votes
1 answer

Convert an unknown format to string Oracle sql

I have a query and I am checking for a string in the where COURSE_NUMBER clause select * from CC cc inner join AB_COURSE_ENROLL ab on cc.DCID=ab.LOCAL_ID where cc.STUDENTID=34700 and cc.COURSE_NUMBER IN (TO_CHAR(FOD1050)); The problem is that if I…
user101
  • 139
  • 10
-2
votes
2 answers

Compiling a new pdo PDO_4D

We have 32 client databases, some are big, with millions of records (V.11. Currently, hosted and build on Mac's). I have build a website on Windows 2012 64x Server and included last version of PDO with PHP version that was stated (Xamp 2.5 with…
ikiK
  • 6,328
  • 4
  • 20
  • 40
-2
votes
1 answer

4D Framework worth it or not?

I was asked at work to participate in a new project: Migration from old version to the newest version of Framework 4D. I really don't know what is 4D Framework is. My question is: Does it really worth it to learn 4D framework and to participate in…
Mike
  • 7
  • 2
1 2 3 4 5 6 7
8