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

Connect to 4D database with database client

I have developed an application using 4D database. But I want to connect any database client to my 4D database for querying the tables (in which I am comfortable of). I know that I can use sql in 4D database too but my requirement here is to query…
Suniel
  • 1,449
  • 8
  • 27
  • 39
1
vote
2 answers

Calling $wakanda.init multiple times from different Angular controllers

I am developing a mobile application built in Wakanda Digital App Factory 1.0.3 using Ionic and AngularJS with a 4D backend database. I have two different 4D methods available through 4D-Mobile via two separate 4D tables that are accessed via two…
Tim Penner
  • 3,551
  • 21
  • 36
1
vote
1 answer

Is it hard to learn 4D database if I do not have any other database skill?

As title, I am a programmer and offered a job in relation to 4D database work, but I never heard of this one, I did some research and found out it is a kind of old type of database technology that is not widely used nowadays, it is applied in a lot…
user2711992
  • 61
  • 1
  • 3
  • 8
1
vote
1 answer

JDBC: Converting Clobs to Strings doesn't show \n line returns

I am connecting to a 4D (fourth dimension brand) database with its crappy jdbc driver. I have a CLOB on the database and when I fetch it either through getString or getClob, I don't get line returns, everything seems to come in one line. But, if I…
Pablo
  • 53
  • 1
  • 6
1
vote
2 answers

Error 61 Array type cannot be modified in compiled database

I have a 4D server (lets call it 4D server 1) that sends a BLOB to another 4D server (4D Server 2) via SOAP web service. The BLOB consists of arrays, that when parsed saves to corresponding tables. There are times (very few) when the BLOB fails to…
Jun Dolor
  • 609
  • 2
  • 11
  • 25
1
vote
1 answer

Save content of variable to a file

Is it possible to save the content of a variable to a file with JQuery. I have a html form (letter) which is saved and edited later on again by the user. I capture the whole html document in a variable, but now I want to write that variable to a…
morne
  • 4,035
  • 9
  • 50
  • 96
1
vote
1 answer

SOAP Web Service not works to update data in 4D database if someone is already using it

I have a client server application (desktop app having 4 users and installed on different machines) on 4D. I have written an SOAP web service whose primary role is to read data from another database of SQL Server and insert those one into 4D. All is…
Ajay
  • 21
  • 2
1
vote
1 answer

Open a html document with php

I have a strange setup at the moment (busy with a migration) I have a 4th Dimension application which calls php scripts (which is our soon to be, only application. Dropping 4D) This script thats called from 4D needs to open a html file in the…
morne
  • 4,035
  • 9
  • 50
  • 96
1
vote
1 answer

Python always crashes using pydobc connection

I am having a hard time with pyodbc module (python3). The following code always crashes python (I run it from DOS terminal). The crash happens when main() function returns. My data source is a 4D v13 database remote server. I am using 4D-ODBC driver…
jlandercy
  • 7,183
  • 1
  • 39
  • 57
1
vote
1 answer

Laravel 5 and ODBC

Can Laravel 5 connect via PDO to ODBC? We have a old 4th Dimension database that needs to be integrated temporarily ( 2 years ) . But Im not sure if it will be able to communicate with Eloquent ORM.
morne
  • 4,035
  • 9
  • 50
  • 96
1
vote
1 answer

How to force an update a Cached Kendo UI Mobile Remote View

I'm using Kendo UI Mobile Framework and have the bulk of my views handled as remote views. For example, a remote html doc view1.html instead of an inline div element #view1. They all work fine in the browser, however I see some problems related to…
btbJosh
  • 305
  • 2
  • 12
1
vote
2 answers

Select result from multi tables with joins

I have this query. I want to select the surgery Type surgery Details Modality ID Am I on the right path atleast? The LINK table is the middle of everything Addmission 1toM on LINK Surgery Mto1 on LINK Modality Mto1 on LINK My…
morne
  • 4,035
  • 9
  • 50
  • 96
1
vote
1 answer

Fastest way to execute a batch of SQL lines

I'm migrating a 4D database to a MySQL database. I have around 50k - 60k of SQL lines to do this. What is the fastest way to send this to the remote db? Because it's in development and the export changes frequently I have to run this multiple times…
Billy
  • 1,104
  • 8
  • 22
1
vote
1 answer

4D Write Error 1022

I am preparing to export the data of a 4D Database (version 11) to a MySQL database. The 4D field is a picture field with a 4D Write document saved in it. I can see that a document is stored in the picture field (when exported to MySQL blob), but…
kipsoft
  • 359
  • 4
  • 16
1
vote
2 answers

Improve format in windows 2008 service

I have a big issue, I have windows server 2008 R2, when I start a program (4D server) it takes the date format from system configuration (dd/mm/yyyy) but when I start the same program using a system service 4D Sever sets the date format to…
Jaime Alvarez
  • 99
  • 4
  • 16
1 2 3
4
5 6 7 8