Log In    |    Knowledge Base    |    4D Home
Tech Note: 4D v11 SQL Database Access Files (4DLINK)
Published On: August 20, 2008

4D v11 SQL features a new file type called "database access file" or simply, 4DLINK.

This new file type allows 4D Developers to control the way in which 4D databases are launched, automatically log in users, automatically create a data file, etc. This feature goes beyond anything seen in both Path Documents and the CLI found in previous versions of 4D.

This Technical Note outlines how these files can be created and used.

A sample database for creating 4DLINK files is included.

Download Complete Tech Note and Example: Windows | Mac

Commented by Brian Campbell on March 4, 2012 at 10:31 PM
This is a great tool, but the version posted here, as well as the one distributed for the 2011 Summit, have an bug in setting the "structure_opening_mode" value in the XML file. The documentation states that the values are:0 -> normal1 -> interpreted2 -> compiledHowever, the app uses the selected index of the listbox, which results in values 1-3, rather than 0-2. The fix is to change updateDOM lines 34 and 89 to read:DOM SET XML ATTRIBUTE(currentDom_ref