Stack Overflow
Stack Overflow

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
2
votes
2 answers

4D Web Server and session variables

I'm working on a Website made with the proprietary DBMS "4th Dimension". I'm really struggling with this, as I'm still a beginner, and I only have experience with PHP on client-server apps. 4D provides a Web Server that can handle GET and POST…
monsieur_h
  • 1,360
  • 1
  • 10
  • 20
2
votes
1 answer

Pandas read_sql with pyodbc to handle corrupt data

I am working with a client that has a 4D database. Tableau won't connect to it. (That's a whole other problem and if you know the answer to that let me know.) What we've decided to do is essentially keep two copies of the data. I am building a tool…
ggrant
  • 452
  • 7
  • 15
2
votes
1 answer

4D SSL Client Certificate

I'm trying to find a way to integrate a client-side ssl certificate to a 4d server, in order to send SOAP calls to a Web service. So far I have only encountered tutorials on server-side ssl certificate tutorial. 4D server version is 16.3.
Dylan
  • 37
  • 6
2
votes
1 answer

how to catch event in codes after linking events in an array of string inside “events” properties of form object variable in dynamic 4D form?

It's easy to catch events from 4D object's methods of 4D binary form (traditional 4D form) but didn't find any clue to do this in the json dynamic form. I already gave a try with some 4D commands (CALL FORM, CALL WORKER or POST OUTSIDE CALL) as well…
Ravi
  • 31
  • 5
2
votes
1 answer

Wakanda connect 4D error session

I launching a 4D method from Wakanda, I have this error : { "__ERROR": [ { "message": "The maximum number of sessions has been reached", "componentSignature": "dbmg", "errCode": 1823 } ], } I see 4D databases in Wakanda. I use 4D rest and I have…
Pratoux
  • 87
  • 8
2
votes
1 answer

Memory Leak examples written in 4D

What are some examples of developer created memory leaks written in the 4D programming language? By developer created memory leak, i am referring to a memory leak created by bad programming that could have been avoided with better programming. 32…
Tim Penner
  • 3,551
  • 21
  • 36
2
votes
5 answers

Wakanda 4Dmobile timeout issue

I´m connecting from Wakanda Enterpise v11 to 4D Server using 4D mobile and Connect to Remote Datastore. i respect 60 minute timeout value. In 4D, on 4D Mobile Authentication Method, all data is fine ($1 contains username and $2 contains…
Fran Caja
  • 41
  • 5
2
votes
1 answer

Cannot use parameter with pyodbc when dealing with 4D ODBC Server

I cannot get parametrized query working with pyodbc and 4D. Here an example of simple and basic code (working on mySQL database). The table B has two columns without any constraint. import pyodbc con2 = pyodbc.connect('dsn=odbc_source'); cur2 =…
jlandercy
  • 7,183
  • 1
  • 39
  • 57
2
votes
2 answers

4D Set Username & Password for PHP Connection with MySQL

I'm setting up a PHP script that connects to the 4D Database on my local system. However, I keep getting: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000] [1044] Access denied for user ''@'localhost' to database 'tester''…
Matt Reid
  • 235
  • 5
  • 14
2
votes
1 answer

Ignoring ascii carriage return characters in R

I've a dataset in tab delimited text file. The data have been exported from an old-school relational database software 4D. Most of the lines seems to be well formated but some lines include an ASCII carriage return character (^M in Emacs or Ascii…
PAC
  • 5,178
  • 8
  • 38
  • 62
2
votes
1 answer

ODBC Connection Issues: Function Sequence error when executing anything

I've been tasked with a one time migration from a 4D database to our MSSQL structure. I've got a datasource set up in the ODBC administrator and I was able to connect to it without issues. I 'reverse engineered' the schema in Visio so I can get a…
Francisco Garcia
  • 974
  • 1
  • 15
  • 26
2
votes
3 answers

Upload photo from iPhone to 4D Server

I am looking to upload a photo from iPhone to a 4D Server. Specifically to upload a photo taken on an iPhone, uploaded to a 4D Server and stored as a JPEG image in the WebFolder. I am using 4D Server version 12 and 13. I have looked at other…
sangony
  • 11,636
  • 4
  • 39
  • 55
1
vote
1 answer

Windows version outside the registry?

I need take an old software that was built in 4D 2004 (you probably never heard about 4D but it doesn't matter) and make it compatible with Windows 7 by fooling it and making him believe he's running under Windows XP. I thought the application was…
The_Black_Smurf
  • 5,178
  • 14
  • 52
  • 78
1
vote
1 answer

jQuery or db function to load one set of database records into one carousel at a time?

I hope this isn't too convoluted. I'm attempting to help someone use a jQuery carousel type slider (hopefully Smooth Div Scroll: http://www.smoothdivscroll.com/) to display products from a database. Unfortunately, they are using a platform called…
alison
  • 165
  • 1
  • 5
1
vote
1 answer

How does the create entity selection works in the 4D database?

I'm wondering about how the create entity selection command in the 4D database works. Does that command also re-query data store internally to get entity selection? If yes then which one would be faster to retrieve entity selection from an existing…
Ravi
  • 31
  • 5
1
2
3 4 5 6 7 8