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
1
vote
2 answers

Connect 4D database with R

I think StackOverflow is the best QA for asking this question. I would like to connect a 4D database (please don't ask why 4D, this is enough painful to have to use it) with mathematics tools such R (or Matlab or even a C++ or .NET handwritten…
jlandercy
  • 7,183
  • 1
  • 39
  • 57
1
vote
1 answer

JDBC ODBC and 4D Database : when reading a row, the first space character of a column is not sent

I use a remote 4D v11 database and an ODBC 4D Driver on Windows to access and read the data. The issue is about some rows of a table: these rows have columns beginning with a space character. It's intended. My java application has to retrieve these…
jack-y
  • 433
  • 4
  • 12
1
vote
1 answer

How to determine when multiple SQL queries are finished using PHP

I have a web app which is basically one page with a single form broken down into tabs, each containing data from separate database tables. The form action points to a save.php script which takes the form data and saves it into the database. The…
Roy
  • 705
  • 2
  • 11
  • 32
1
vote
6 answers

Why does my 4D Database debugger not display all panels?

We are using 4D Server v13. As I connect to the server and run a method with a Trace or breakpoint, I get the debugger with the expression panel missing. The database has been converted from version 6.7.1.
Jun Dolor
  • 609
  • 2
  • 11
  • 25
1
vote
2 answers

Duplicate records being returned in MySQL

Unfortunately for most of my career I use a freaky french database called 4th dimension. And it acted very differently from MySQL. So please bear with me on what could be avery simple question. I have bult a query as follows: SELECT c.id,…
JVMX
  • 1,016
  • 2
  • 12
  • 23
1
vote
1 answer

Generic Parsing Error

In a 4D application, I have the following lines of code: Begin SQL UPDATE Keys SET Desc = :$desc, KeyStamp = :$key_stamp WHERE KeyTitle = :$key_title End SQL When trying to run the code, the following error is displayed: Generic parsing…
Noctis Skytower
  • 21,433
  • 16
  • 79
  • 117
1
vote
0 answers

JQuery Validation Triggering on Failure

OK, I have been trying for days to do something that feels like it should be very simple. Basically I have a form setup. It currently is required to check for an email address within a 4d database, and if it exist post a message that states that…
Jack Parker
  • 547
  • 2
  • 9
  • 32
1
vote
2 answers

Automatically zoom web page on iphone/android so text box fills screen horizontally

We have a large proprietary MRP system based on 4D. We are creating a very simple web page served by 4D that has a text box. How do I convince iphones and androids to make the text box the width of the screen, so the user does not have to manually…
Jeff
  • 1,364
  • 1
  • 8
  • 17
1
vote
2 answers

Multiline Text Literal in 4D

Is it possible to enter a multiline text/string literal in a 4D method? Something like: C_TEXT($var) $var:="""First Line Second Line Third Line""" Using the triple-" here as they are being used in Python, just as example.
Riemy
  • 53
  • 6
1
vote
1 answer

Using 4D server to send out APNs

I am looking to send out Push Notifications from a 4D Server. I have been following Ray Wenderlich's tutorial, but get stuck when trying to use 4D Server to "push". Anyone know how to do this?
sangony
  • 11,636
  • 4
  • 39
  • 55
1
vote
1 answer

How can I browse for a file path and then display that path in the variable of a 4D form?

I'm trying to create a 4D form that will allow me to browse my server for a specific file, then once selected, have that file's path be displayed as a variable in the form. So far, I've been unsuccessful at even opening the Explorer window to browse…
SirSkidmore
  • 11
  • 1
0
votes
0 answers

How to efficiently compute checksum on core-data attribute for online verification?

I need to find a way to verify the contents of core-data entities against the online database from which the data originated. Essentially I need a fingerprint of a core-data entity or attribute that I can reasonably replicate in other common systems…
TomB
  • 116
  • 2
  • 5
0
votes
1 answer

Looped .Refresh causing slow Excel

I am trying to use VBA in Excel for Mac to query a database. A simple query works fine and I've been using it for years. Now I'm getting into more complex queries, where the results of one query (about 1,000 records) are used sequentially to query…
Schrocks
  • 13
  • 4
0
votes
0 answers

Read or open .s or .S extension (4 Dimention) file in python

I have a file with .s extension(S File) which dimensions are (40016862113). I want to read this file and then combine the data in 13 different time frames to get (400168*621). I used different methods to read this file, but I failed to open and read…
tahereh zare
  • 11
  • 1
0
votes
1 answer

Connecting to 4D database using Microstrategy

Is there a way to connect to a 4D database from Microstrategy? Thanks.
Shawn A
  • 11
  • 2
1 2 3 4
5
6 7 8