4D Changelog

What's new in 4D 20.R3

Feb 14, 2024

Highlights:
New collection.multiSort function.
Support of context parameter in Formula from string.
Support of headers property in connectionHandler parameter of 4D.WebSocket.new.
Global modification stamp to help implementing data synchronization modules. New functions: ds.getGlobalStamp and ds.setGlobalStamp.
Assigning file references to picture/blob attributes is supported in ORDA.
Support for initializing the variable's value and data type in the declaration line.
Log file settings are now saved with the current data file
New syntax for declaring variadic parameters
4D View Pro: Support for the import and export of 4D View Pro documents in Blob format.
4D Language commands: What's new page on doc.4d.com.
4D Write Pro: What's new page on doc.4d.com.
Fixed bug list: list of all bugs that have been fixed in 4D v20 R3.
Behavior changes:
Some errors were catchable by your error handling method in interpreted mode only. A fix has been done, so that the following errors will now be caught also in compiled mode: Indice out of range, Type incompatible, and Dereferencing a Null pointer. However, for such errors on Intel processors, the procedure is still interrupted as before, whereas on Apple Silicon processors the procedure is only interrupted if you call the ABORT command.
4D no longer includes an internal PHP interpreter. You need to set up and run your own PHP interpreter to use PHP commands.

New in 4D 20.R2 (Oct 13, 2023)

New in 4D 19 (Jul 13, 2021)

Object-Oriented Programming in 4D:
An approach that models the real world:
OOP allowed us to push the 4D language far beyond what was previously possible, promising greater productivity, better code quality, and lower maintenance costs. We bet on code that is closer to human language, easier to understand, similar to modern object-oriented programming languages, and compatible with your existing code.
D for Apple Silicon:
The reason this LTS is out six months earlier than planned:
With a brand-new compiler and notable performance enhancements, 4D now runs natively on Apple computers using the Apple Silicon M1, which you and your customers will certainly be happy to use to give your 4D applications a boost right away.
D redesigned architecture. Project Mode:
For collaboration and much, much more:
While 4D Project mode enables solo developers to keep an eye on the history of their work, and highly distributed workforces to work collaboratively, it also paves the way for many development possibilities that positively affect the end-user. Modularity. CSS. Apple M1’s remarkable performance. And we’re just getting started!
D for mobile. Carry your data in your pocket:
Run businesses on the go:
Track warehouse inventory, search products using barcodes, create invoices during client visits, perform onsite inspections, conduct health assessments, consult your contracts, get customer signatures after package deliveries, and much more. All that thanks to 4D for iOS and, in a coming feature release, 4D for Android.
The 4D language. Power taken further:
With +40 new features for business and productivity:
Speed up your development process with the plethora of new features. 4D v19 has made the 4D language more advanced than ever before.
Object-Relational Data Access (ORDA):
Advanced technology for ambitious developers:
ORDA has revolutionized the way data is accessed and presented in 4D. The entire 4D database can be accessed using an object-oriented approach. Instead of representing information as tables, records, and fields, ORDA uses an alternate approach that maps data to real-world concepts more accurately.
Today's applications are forced to handle complex and large data sets. ORDA tackles this issue by providing a seamless coding experience to developers and effective insights to end-users at a reasonable timeframe.
ORDA Classes:
With great power comes great efficiency:
D v19 drastically enhances the power of ORDA, especially with the use of classes. They allow you to combine all the benefits of an OOP language with a deep link to data.
By creating high-level class functions above the data model, you can write business-oriented code to hide complexity, reduce errors, and speed up your development process.
D Write Pro:
Simplify document creation workflows:
D Write Pro is a powerful desktop publishing engine entirely programmable and fully integrated into 4D.
Create invoices, reports, delivery notes, complex contractual documents. Display them on the web and send them as HTML Emails. Save them as PDF. Import from and export to Microsoft Word format.
D View Pro:
More than a spreadsheet solution:
Build reports, dashboards, budget planners with eye-appealing charts, perform mathematical operations and use built-in formatting to bring important data to the first lines. Import and export your documents to Microsoft Excel format, save them as templates or PDF files and attach them to emails. If you love Excel, you'll adore 4D View Pro.

New in 4D 18.6 (Apr 20, 2021)

4D applications:
Warning:
Warning: 4D v18 R6 includes an update to the ICU library (see below) which will force an automatic generation of alpha, text and object type indexes. Depending on the size of the data file, this operation may take some time and may require planning.
On click event generated in modified list box cells:
From 4D v18 R6, the On click and On double click events are generated when a click is performed on a text entry cell while the cell is being edited. This feature allows you to display pop-up menus after Contextual click for example. The event is generated in the column and in the list box object (in that order).
In previous versions, these events could be generated only for text entry cells when they were not in edit. To avoid any unexpected effects in existing interfaces, you can add the following test in your code:
// List box object or list box column method
If (FORM Event.code = On click) // or On double-click
If (No (Text in edition)) // additional test
// previous code
End of if
End of if
Undefined when entity selection is empty:
For consistency with collection functions, the entitySelection.min (), entitySelection.max (), and entitySelection.average () functions now return Undefined when applied to a selection of entities. In versions prior to R6 18, they returned Null in this case.
CHANGE ELEMENT PROPERTIES:
The icon parameter of the CHANGE ELEMENT PROPERTIES command is now optional. The syntax of the command is as follows:
CHANGE ELEMENT PROPERTIES ({*;} list; elementRef | *; enterable; styles {; icon {; color}})
HISTORY FILE TO JSON exports object fields
The HISTORY FILE TO JSON command now exports details of operations performed on object type fields. They were previously treated as blob fields.
4D Write Pro:
WP Get elements returns anchored images sorted in Z order
When you set wk type image anchored as the elementType parameter for the WP Get Elements command, the returned collection now contains anchored images sorted in Z order from lowest to highest. In previous versions, they were sorted by ID.
$ col: = WP Get elements (WPArea; wk type image anchored) // images are sorted in z order in $ col
To restore the previous behavior if necessary, just write:
$ col: = WP Get elements (WPArea; wk type image anchored) .orderBy ("id asc")
Library updates:
ICU: updated to v68.1 - This major update will force an automatic regeneration of alphanumeric, text and object indexes.
OpenSSL: updated to OpenSSL version 1.1.1k
SpreadJS (4D View Pro engine): updated to version v14
PHP: updated to version v7.3.27

New in 4D 18.5 (Jan 19, 2021)

New in 4D 17.0 (Oct 24, 2018)

ACI0094683 'QUERY WITH ARRAY' command does not return all the expected records when used against an indexed field with a query array size greater than 1, when using the wildcard character (@). 16.3 HF4
ACI0094811 'RELEASE MENU' executing in the "On Exit" database method may lead to a crash. 16.3 HF4
ACI0095913 The "text-align" property is not interpreted correctly by multi-style 4D variable. 15.6 16.3 HF3
ACI0096115 'SET MENU BAR' command executed in 'On Server Startup' database method leads 4D Server to quit unexpectedly. 16.3 HF3
ACI0096454 'CALL WORKER' may cause a concurrency issue when writing to a file. Now, the new worker process awaits for the previous one to die before coming alive.
ACI0096587 Slowness when typing code in method editor when there are loads of code lines (several thousands).
ACI0096698 Cannot manage 4D Write Pro access rights on 4D Remote unless 4D Write plugin is present in "Plugins" folder. 16.3 HF2
ACI0096866 'LOCKED BY' command shows always "Default" user but never shows the user that results from a call to 'CHANGE CURRENT USER'. 16.3 HF3
ACI0096868 The variable 'Document' is not updated with the newly created document path. Only with 64-bit application. 16 R6 16.3 HF1
ACI0097102 Since v16 R3, when using the 'WP INSERT DOCUMENT' command an unexpected error "This kind of argument was not expected here" may appear.
ACI0097167 Bad 'Find in design' result when using 'Any object' and 'whose modification date is since yesterday' criteria. 16 R6
ACI0097252 Clicking twice on the icon of a built 4D Remote in the taskbar causes multiple failed starts.
ACI0097346 'Datepicker' widget doesn't display the current date value at first load or when the date is directly entered using the keyboard. 16.3 HF1 15.5 HF1
ACI0097373 Unexpected error #9852 on Quick Report with 4D Remote when a subform of quick report is added. 16.3 HF2
ACI0097381 On macOS, in the Page Setup dialog the 'Format For' is unexpectedly equal to "Any Printer" wich causes wrong margins when printing. 32-bit application only. 16.3 HF3
ACI0097390 4D Server may crash after calling the 'On Web Connection' database method that contains 'QUERY SELECTION' after 'WEB SEND TEXT'. 16.3 HF2
ACI0097426 When enabling the “Display this dialog at next startup” option in the connection dialog of an engined Client, at next startup, the connection dialog is not displayed. 16.3 HF1 15.5 HF1
ACI0097484 The MSC XML Log files are not displayed on all browsers because related XSL file is generated as a separate file and not loaded due to security constraints from some browsers. 15.6 16.3 HF3
ACI0097497 Multiple instances of an engined desktop application can be launched in SDI mode (Windows only, 64-bit only then), witch is not allowed. 16 R6
ACI0097501 Loading an object value (field, C_OBJECT) in binary format duplicates references to same objects.
ACI0097539 4D Server application may quit unexpectedly when lots of SOAP requests are completed. 16 R6 16.3 HF2
ACI0097557 Method windows and form windows previously opened are not restored when re-open the database: they are closed. 32-bit applications only. 16 R6
ACI0097575 Breakpoints may not be registered correctly in client-server mode. 16.3 HF1
ACI0097633 Label editor: with 64-bit application, concatenation of fields with "&" or "%" symbols causes font color change to red. 16.3 HF3
ACI0097641 'LISTBOX SET COLUMN WIDTH' has not effect on a listbox placed on page 2. 16 R5 16 R6
ACI0097656 Lets a button that shows an alert. Clicking several times on it while the form method takes time to run may prevent to validate the alert (kind of freeze). 16.3 HF1 15.5 HF1
ACI0097668 Label editor: on a 32-bit application, loading an empty label file makes 4D to quit unexpectedly. 16.3 HF4
ACI0097676 After typing Japanese text in cell of listbox and hitting space bar once, the thickness of the underline may be wrong. 16.3 HF1
ACI0097683 Display of thermometer label is trimmed in form editor with 'Windows classic' theme. 16.3 HF1
ACI0097688 Unexpected error #-10002 when attempting to connect a 32-bit 4D Remote to a 64-bit 4D Server.
ACI0097690 Interpreter throws error if "Sum(...)" is passed directly to "String(...)". 16 R5 16.4
ACI0097696 There are some lags when scrolling a 'heavy' list form. 16 R6
ACI0097697 Impossible to change a listbox cell value with the up and down arrow keys on Mac. 16.3 HF1
ACI0097701 A temporary file is unexpectedly created when exporting an existing method. Only on macOS 10.13 (High Sierra). 16 R5 16 R6 16.3 HF1
ACI0097706 Query editor syntax error if using virtual structure names in formulas. 16.3 HF2
ACI0097707 Using region settings from the 'Language & Region' option set as primary in System Preferences is not working when you have more than one language in the list; English language is always used. Only on macOS 10.13 (High Sierra). 16 R5 16 R6 16.3 HF1 15.5 HF1
ACI0097715 Quick Report inserts wrong field if used table contains an invisible field. 64-bit application only. 16.3 HF2
ACI0097722 Quick Report area 64-bit erroneously required a 4D View license when used in a form. 16 R6 16.3 HF2
ACI0097723 Using the command 'ST INSERT TEXT' in a cell of a 4D Write Pro table may unexpectedly wrongly resize the according row (1 or 2 lines added in the cell). 16 R6
ACI0097730 Old 4D Write document conversion to 4D Write Pro may fail: a coma (",") becomes unexpectedly a dot ("."). 16 R6 16.3 HF1
ACI0097738 A blank picture is displayed for a picture in PICT format in 4D write Pro document instead of the crossed camera expected. 32-bit and Windows application only. 16 R6 16.3 HF1
ACI0097740 'HTTP Request' command returns HTTP status code 200 for an invalid request whereas it previously returned 0. 16 R6 16.3 HF1
ACI0097756 Entering directly a filtered URL in the URL variable does not trigger the event "On URL Filtering" when the Web Area is set to use the embedded Web rendering engine.
ACI0097764 The clipboard is not updated when attempted to copy by doing Cmd/CTRL+"A", and then Cmd/CTRL+"C" while editing in a cell (listbox, form editor Property list palette). 16.3 HF2
ACI0097778 'BASE64 ENCODE' command inserts CRLF characters every 40000 characters. The new behaviour is that no more CRLF is inserted by the command. If CRLF is needed, it's up to the developer to insert it. 16 R6 16.3 HF2
ACI0097785 Deleting a corrupted method may prevent to create another new one. 16.3 HF2 15.6
ACI0097787 Type of listbox footer is not preserved when converting a database from a major version to another (for instance, v15 to v16). 16 R6 16.3 HF2
ACI0097791 Wrong error message for faulty SOAP call: message is about "4D View Pro license required". 16 R6
ACI0097802 Collection member: 'distinct' doesn't order objects by reference.
ACI0097809 Unexpected error execution when launching a form that contains an included form wich "%report" is associated to. 16 R6
ACI0097817 Collection member: using the operator 'IN' in a query may crash 4D.
ACI0097826 For engined server on Windows, the Server Administration window and the Runtime Explorer don't show the correct icon. 16.3 HF2 15.6
ACI0097831 Hitting Space bar no more bring a background current window to the foreground. 16.3 HF2 15.6
ACI0097834 4D Server Administration window will not reopen if you close it once. 16.3 HF3
ACI0097838 Query on scalar attribute object from Wakanda to 4D server do not work. 16.3 HF2
ACI0097841 Wrong tokenization of constants used by the 'PRINT SETTINGS' command in the french version of 4D. 16 R6 16.3 HF2
ACI0097853 Wrong appearance of boolean checkbox in listbox (not enterable=enterable) under certain conditions. 16.3 HF3
ACI0097860 By enabling the 'Automatic row height' option for a listbox,, the vertical scroll doesn't refresh and lines selection is broken. 16 R6
ACI0097864 Format 'System date short' is not correct en macOS: some digits are missing for day, month or year. 15.6 16.3 HF3
ACI0097867 Bad display of windows with 'MODIFY RECORD' when executed in maximised window mode (full screen). 16.3 HF2 15.6
ACI0097878 The event "On Data Change" is not triggered with the date picker (pop up date).
ACI0097889 4D Write documents (4W7) take more time to load when converted to 4WP. 17 R2 16.3 HF5
ACI0097891 4D Server Administration window cann't be opened via 'Help' menu on Mac platform. 64-bit version only. 16 R6 16.3 HF2
ACI0097895 In the query editor, navigation with the arrow keys on the keyboard doesn't work correctly: there is no scroll. Scroll bar stands still. 16.3 HF3
ACI0097912 Using client/server encryption downgrades the web server ssl notation. 16.3 HF5
ACI0097918 If 'Automatic row height' option is enabled for a listbox and you hide rows on "On load" event, 4D quite unexpectedly. 4D 64-bit only, Windows system only. 16 R6
ACI0097921 Text input caret is always displayed in black even if the background colour is black too, which makes impossible to locate the caret. 16.3 HF2
ACI0097924 Possible disconnection on New Network Layer when 'ON EVENT CALL' is used. 16 R6
ACI0097932 Memory leak with commands 'OPEN PRINTING JOB' and 'CLOSE PRINTING JOB'. 16.3 HF3
ACI0097933 Various third-party plugins fail to load on Windows 64-bit because of a conflict between CEF and 4D plugins dll folders. For information, the 'Welcome wizzard' uses a web area (CEF); so the problem may happen from the start. 16 R6
ACI0097934 Copy and paste SVG picture from 4D 64 bits to a non-4D application does not work. 16.3 HF2
ACI0097937 'SET WINDOW RECT' doesn't move the resize icon after changing the form wizzard window size. 16.3 HF2
ACI0097938 Graphics.dll leads to crash (direct2D) 16.3 HF4
ACI0097946 Copying text from a combobox object doesn't work. 16 R6
ACI0097951 'WEB Get server info' command doesn't list the IPv6 address information for the current session.
ACI0097952 In Settings dialog, IP addresses (in the dropdown list) of SQL server are not the same on Client side and Server side.
ACI0097964 Menu items from the menu 'Edit' become unexpectedly disabled after editing a variable in a form. 32-bit applications only.
ACI0097966 64-bit label editor cannot print in landscape format. 16.3 HF3
ACI0097972 Debugger window: Local variables expressions may show unexpectedly values as 'undefined'. 16 R6
ACI0097975 'Current method name' command's return is wrong (returns "untitled") in the context of a dynamic form.
ACI0097980 When the option "Use object notation to access object properties" is checked, after a conversion of a database to v17 the unicode option" Save methods as Unicode" disappears (even if it's not checked before).
ACI0097983 4D Server as a service: 'Launched as service' system information is never updated. The value is always 'No'.
ACI0097984 Drop a user from the Administration window generates a client disconnection error when a process application is postponed.
ACI0097986 In compiled mode, the command 'SET ASSERT ENABLED' with parameter equals to 'False' may not always be applied correctly: 'ASSERT' command can still be enabled. 15.6 16.3 HF3
ACI0097992 On Windows system, TrueType fonts not useable in 4D Write Pro, even though they are scalable. 16.3 HF3
ACI0097994 "Check Syntax" and "Generate Typing" functionalities of 4D Compiler dialog don't display the resulting message like "Syntax check successful" for a Standard Server License.
ACI0097998 4D Remote can freeze unexpectedly after waking up the computer. 16 R6
ACI0098002 A random crash could occur when a menu bar is released. 15.6 16.3 HF3
ACI0098012 The 4D Write Pro area disappears when inserting an SVG picture into a 4D Write Pro document.
ACI0098025 Japanese IME turns deactivated after a call of 'ADD RECORD' in a button from a form. 16.3 HF4
ACI0098031 'QUERY BY ATTRIBUTE' doesn't find the good result when using all operators (=, #, >, <, >=, <=) with Time field.
ACI0098037 Cluster Index on object field could be damaged when doing a Sum on a path value. Side effect: 'QUERY BY ATTRIBUTE' may not work correctly. 16.3 HF3
ACI0098038 Using the arrow key, cursor doesn't move before hitting space-bar key for conversion when typing japanese text. 16.3 HF5
ACI0098041 The 'BUILD APPLICATION' command does not set 'OK' variable to 0 if the compilation fails and the compilation dialog that lists errors is not displayed.
ACI0098042 A freeze of 4D Client as web server can occured if some web requests attempt to read some resources in the structure file. 16.3 HF3
ACI0098062 Folders in "Ressources" not copied in the root of the folder ".../Library/Caches/4D/DBname/Ressources".
ACI0098063 Typing a title containing the letter "n" triggers the "open/select report" window on Quick Report 64 bit editor. 16.3 HF4
ACI0098075 [138586] Crash sur CHERCHER PAR FORMULE
ACI0098079 Paths for data stored automatically outside datafile are not correct. Folders are badly named, and not created every 100 records. 15.6 16.3 HF3
ACI0098094 Not able to compile when using 'Min' and 'Max' commands applied on a date array. 16.3 HF4
ACI0098098 Localization issue: In 'FR' release, the constant "Web client adresse IP d’écoute" (value 23) is not present and badly replaced by the 'INTL' constant "Web Client IP address to listen". 16.3 HF4
ACI0098102 Clicking on a cancel button in a form page 'B' containing a web area closes it, but also closes unexpectedly the original form 'A' which has called the form 'B'. 17.0 HF3
ACI0098107 4D Write Pro: missing check marks in contextual menu after selecting an option. 16.3 HF4
ACI0098109 4D View Pro: Black or Grey background color appears after the last row and column.
ACI0098127 Web Server doesn't listen on specified IP Address, but instead it listens on Any.
ACI0098128 It's not possible to select a background picture (behind a text) in 4D Write Pro; unexpected alert and message appear when attempting to do so.
ACI0098129 Loading an object variable using 'LOAD VARIABLES' command, makes 4D quits unexpectedly. 16.3 HF4
ACI0098135 Crash of 4D in the TRACE window (debugger windows) if an old set expression is present in the expression panel.
ACI0098136 In some special cases, 4D crashes when you Generate Typing, and 'Object notation' is activated.
ACI0098149 4D and 4D Server quit unexpectedly when using the Runtime Explorer dialog to explore variables for a preemptive process.
ACI0098157 Since ICU 50, prolonged sound mark ("-") is no longer considered as a letter when the database language is set to Japanese. 16.3 HF4
ACI0098161 'QUERY BY ATTRIBUTE' doesn't find the good result when using operator ">=" or ">" on an indexed Object field.
ACI0098165 Existing records with a 4D Write Pro area contain unexpectedly all attributes twice. 16.3 HF4
ACI0098178 'IMPORT DATA' command used with an empty string for the file parameter doesn't display the open file dialog; 64-bit mode only. 16.3 HF4
ACI0098184 A problem in the CSS parser exception (brakets considered as a quote) may prevent good conversion of 4D Write expression to 4D Write Pro. 16.3 HF5
ACI0098188 Unexpected syntax error "Attempting to retype by using a pointer." with 4D commands 'Min' and 'Max' in compiled mode. 16.3 HF4
ACI0098194 In the form editor, changing the size of a column in a listbox may not be taken into consideration.
ACI0098253 Unexpected error #-20002 with 'SVGTOOL_show_in_viewer' when there is a text with character ‘&’ in the SVG. 16.3 HF4
ACI0098260 Runtime error message not explicit when XPS Viewer is not installed (for information, installing Windows 10.1803 may remove the XPS Viewer). 16.3 HF5
ACI0098261 In a form opened by 'MODIFY SELECTION', a checkbox in a listbox is non-enterable whereas it should be enterable. 17 R2 16.3 HF5
ACI0098269 Switching the 4D user in 4D Remote thanks to 'CHANGE CURRENT USER' does no more actualize the 4D user column in the 4D Server admin window. 16.3 HF5
ACI0098271 In certain circumstances, 'Undo' deletes too many characters in 4D Write Pro. 16.3 HF5
ACI0098275 When saving an object that contains itself (cycle) in an object field, 4D issues error #900 ("JSON cannot stringify cyclic structures")
ACI0098294 'WRITE PICTURE FILE' doesn't accept a picture object property in compiled mode.
ACI0098321 Probable crash when MSC check of application with the built 4D Server application. 16.3 HF5
ACI0098384 'LISTBOX DELETE ROWS' will delete the last row incorrectly if the listbox displays control array.
ACI0098388 4D Server 32-bit may quit unexpectedly when a plugin creates new handles, using 4D SDK, from different threads. 17 R2
ACI0098223 4D for OCI constant 'OCI_STMT_DECLARE' was wrongly set with value 39 instead of 9. 16.3 HF4
ACI0096484 'IMAP_SetPrefs' cannot find directories with umlauts in the name. 16.3 HF1
ACI0096656 'IMAP_Search' command is unable to find few messages when the used criteria is "HEADER MESSAGE-ID". 16.3 HF3
ACI0096779 Error #-43 returned by 'FTP_Send' because of some accented characters in the 'localpath'. 16 R6 16.3 HF1
ACI0097254 'IMAP_MsgLst' returns error #-120 if an umlaut is in the path name. 16 R6 16 R6 16.3 HF2
ACI0097882 Time type data is retrieved in a timestamp format instead of usual time format as expected. 16.3 HF2
ACI0097960 The connection with the ODBC Driver fails in secure mode (TLS). An unexpected error "Can't read from server" occurs.

New in 4D 16.4 Build 16.226.553 (Sep 13, 2018)

ACI0094242 When adding by programming fields as primary key to a table (Field1 and Field2) the 'Unique' property is not added to these fields. 16.3 HF1 15.5 HF1
ACI0095626 Cannot access blob byte via a pointer in compiled mode (For instance "$ptr->{$row}{$offset}"). 16 R5 16.3 HF1
ACI0094683 'QUERY WITH ARRAY' command does not return all the expected records when used against an indexed field with a query array size greater than 1, when using the wildcard character (@). 17 16.3 HF4
ACI0094811 'RELEASE MENU' executing in the "On Exit" database method may lead to a crash. 17 16.3 HF4
ACI0095763 Using 'SUSPEND TRANSACTION' and 'RESUME TRANSACTION' triggers error "Transaction is not suspended, so it can't be resumed". 16.3 HF1
ACI0095913 The "text-align" property is not interpreted correctly by multi-style 4D variable. 17 15.6 16.3 HF3
ACI0096034 The command 'ST Get content type' cannot be compiled is you pass 4 variables parameters after the object name or object variable. 16.3 HF2
ACI0096115 'SET MENU BAR' command executed in 'On Server Startup' database method leads 4D Server to quit unexpectedly. 17 16.3 HF3
ACI0096573 Missing help tip on listbox after an horizontal scroll. 16.3 HF1
ACI0096654 Unexpected error #-1 displayed when canceling the saving dialog while exporting data to file. 16.3 HF1
ACI0096698 Cannot manage 4D Write Pro access rights on 4D Remote unless 4D Write plugin is present in "Plugins" folder. 16.3 HF2
ACI0096866 'LOCKED BY' command shows always "Default" user but never shows the user that results from a call to 'CHANGE CURRENT USER'. 17 16.3 HF3
ACI0096868 The variable 'Document' is not updated with the newly created document path. Only with 64-bit application. 16 R6 16.3 HF1
ACI0096911 Remote database connection stop button does not cancel the connection attempt. 16.3 HF1
ACI0097045 WritePro Widget shows an error message when the entered value exceeds the allowed value. 16.3 HF1
ACI0097129 Bad title displayed in Japanese for the standard action "Quit <app name>". 16 R5 16.3 HF1
ACI0097173 In 4D Write Pro, pasting a text may paste unexpectedly twice. 16.3 HF1
ACI0097184 Pie Graph rendering direction is incorrect in 64-bit, starting at 3 o'clock position and sweeping counter clockwise. 16 R5 16.3 HF1
ACI0097193 Quick Report: the content of a generated cross table is empty. 16.3 HF1
ACI0097207 The 4D command 'RESTORE' executed with two parameters has wrong text on the "Stop" button: it is written "Restore" instead. 16.3 HF1
ACI0097303 A breakpoint could not be registered correctly in client/server configuration. A crash could be generated. 16.3 HF1
ACI0097327 Using 4D 64-bit to connect to 4D Server via LEGACY network displays an incorrect network error message. 16.3 HF1
ACI0097346 'Datepicker' widget doesn't display the current date value at first load or when the date is directly entered using the keyboard. 16.3 HF1 15.5 HF1
ACI0097373 Unexpected error #9852 on Quick Report with 4D Remote when a subform of quick report is added. 16.3 HF2
ACI0097381 On macOS, in the Page Setup dialog the 'Format For' is unexpectedly equal to "Any Printer" wich causes wrong margins when printing. 32-bit application only. 17 16.3 HF3
ACI0097386 First two characters of an HTTP POST Request's body being removed. 16.3 HF1
ACI0097388 "Find unused local variables" does not show blob, object and time variables. 17.0 HF1
ACI0097390 4D Server may crash after calling the 'On Web Connection' database method that contains 'QUERY SELECTION' after 'WEB SEND TEXT'. 16.3 HF2
ACI0097392 Calling left 'OUTER JOIN' and order by in SQL forces the application to quit. 16.3 HF1
ACI0097409 Cannot open a ".4dc" file when using the 4D Web Application Server license; an error #10507 is raised. 16 R5 16.3 HF1
ACI0097426 When enabling the “Display this dialog at next startup” option in the connection dialog of an engined Client, at next startup, the connection dialog is not displayed. 16.3 HF1 15.5 HF1
ACI0097458 Change listbox background color in form editor with color picker doesn't work. 16.3 HF1
ACI0097478 Depending of the font (Japanese font), italic character in a hierarchical list is trimmed on the right side. 16.3 HF1
ACI0097483 4D Server doesn't respond anymore after a lot of simultaneous connection with the 'New network layer'. 16.3 HF2
ACI0097484 The MSC XML Log files are not displayed on all browsers because related XSL file is generated as a separate file and not loaded due to security constraints from some browsers. 15.6 16.3 HF3
ACI0097488 Free memory is exhausted when running a 4D Backup roughly equivalent to the size of installed RAM. 16.3 HF1
ACI0097496 Deleting all transitional characters in IME editor doesn't automatically end editing mode; delete key needs to be pressed 3 more times to continue #Japanese. 16.3 HF1
ACI0097520 A crash can occur if in a method a table and a field have the same name using SQL with alias. 16.3 HF1
ACI0097539 4D Server application may quit unexpectedly when lots of SOAP requests are completed. 16 R6 16.3 HF2
ACI0097575 Breakpoints may not be registered correctly in client-server mode. 16.3 HF1
ACI0097581 Ghost Application process may unexpectedly stay after client disconnection is killed. 16.3 HF1
ACI0097613 The sort thanks to menu command 'Last Used Tables' is changed after 4D restart. 16.3 HF1
ACI0097623 Boolean field as radio buttons displayed unexpectedly as checkbox after a database conversion. 16.3 HF1 15.5 HF1
ACI0097630 4D Remote connection dialog: settings lost in the 'Custom' tab if going to 'Available' tab before. 16.3 HF1 15.5 HF1
ACI0097633 Label editor: with 64-bit application, concatenation of fields with "&" or "%" symbols causes font color change to red. 17 16.3 HF3
ACI0097634 A data verification thanks to the MSC on object fields can generate some unexpected errors. 16.3 HF1
ACI0097642 A crash may occur while 4D parsing an SQL server request. 16.3 HF1
ACI0097649 4D may crash when opening a form containing a tab control with a width of 1 pixel. 16.3 HF1
ACI0097656 Lets a button that shows an alert. Clicking several times on it while the form method takes time to run may prevent to validate the alert (kind of freeze). 16.3 HF1 15.5 HF1
ACI0097668 Label editor: on a 32-bit application, loading an empty label file makes 4D to quit unexpectedly. 17 16.3 HF4
ACI0097676 After typing Japanese text in cell of listbox and hitting space bar once, the thickness of the underline may be wrong. 16.3 HF1
ACI0097681 4D Server doesn't accept too many postpone reconnections per seconds on new network layer (ServerNet). 16.3 HF2
ACI0097683 Display of thermometer label is trimmed in form editor with 'Windows classic' theme. 16.3 HF1
ACI0097690 Interpreter throws error if "Sum(...)" is passed directly to "String(...)". 16 R5 16.3 HF5
ACI0097697 Impossible to change a listbox cell value with the up and down arrow keys on Mac. 16.3 HF1
ACI0097700 Unexpected message "bound variable changed" when using the TimePicker object. 16.3 HF1
ACI0097701 A temporary file is unexpectedly created when exporting an existing method. Only on macOS 10.13 (High Sierra). 16 R5 16 R6 16.3 HF1
ACI0097706 Query editor syntax error if using virtual structure names in formulas. 16.3 HF2
ACI0097707 Using region settings from the 'Language & Region' option set as primary in System Preferences is not working when you have more than one language in the list; English language is always used. Only on macOS 10.13 (High Sierra). 16 R5 16 R6 16.3 HF1 15.5 HF1
ACI0097715 Quick Report inserts wrong field if used table contains an invisible field. 64-bit application only. 16.3 HF2
ACI0097722 Quick Report area 64-bit erroneously required a 4D View license when used in a form. 16 R6 16.3 HF2
ACI0097726 Canceling printing, the Quick Report does not set 'OK' variable to zero. 16.3 HF2
ACI0097730 Old 4D Write document conversion to 4D Write Pro may fail: a coma (",") becomes unexpectedly a dot ("."). 16 R6 16.3 HF1
ACI0097738 A blank picture is displayed for a picture in PICT format in 4D write Pro document instead of the crossed camera expected. 32-bit and Windows application only. 16 R6 16.3 HF1
ACI0097740 'HTTP Request' command returns HTTP status code 200 for an invalid request whereas it previously returned 0. 16 R6 16.3 HF1
ACI0097760 'UNREGISTER CLIENT' loses connection when the process is postponed. 16.3 HF1
ACI0097764 The clipboard is not updated when attempted to copy by doing Cmd/CTRL+"A", and then Cmd/CTRL+"C" while editing in a cell (listbox, form editor Property list palette). 16.3 HF2
ACI0097778 'BASE64 ENCODE' command inserts CRLF characters every 40000 characters. The new behaviour is that no more CRLF is inserted by the command. If CRLF is needed, it's up to the developer to insert it. 16 R6 16.3 HF2
ACI0097779 Server not responding under certain circumstances when the sleep mode timeout is reached. 16.3 HF1
ACI0097785 Deleting a corrupted method may prevent to create another new one. 16.3 HF2 15.6
ACI0097786 Typing in values in RGB slider (from the color picker) in Form editor does not work. 16.3 HF2
ACI0097787 Type of listbox footer is not preserved when converting a database from a major version to another (for instance, v15 to v16). 16 R6 16.3 HF2
ACI0097823 "RESOLVE POINTER" command returns an empty name when executed in preemptive mode. 17.0 HF1
ACI0097826 For engined server on Windows, the Server Administration window and the Runtime Explorer don't show the correct icon. 16.3 HF2 15.6
ACI0097831 Hitting Space bar no more bring a background current window to the foreground. 16.3 HF2 15.6
ACI0097834 4D Server Administration window will not reopen if you close it once. 16.3 HF3
ACI0097838 Query on scalar attribute object from Wakanda to 4D server do not work. 16.3 HF2
ACI0097841 Wrong tokenization of constants used by the 'PRINT SETTINGS' command in the french version of 4D. 16 R6 16.3 HF2
ACI0097853 Wrong appearance of boolean checkbox in listbox (not enterable=enterable) under certain conditions. 17 16.3 HF3
ACI0097864 Format 'System date short' is not correct en macOS: some digits are missing for day, month or year. 17 15.6 16.3 HF3
ACI0097866 4D Server may crash when trying to find a localized string for a process name from SQL Server. 15.6 16.3 HF3
ACI0097867 Bad display of windows with 'MODIFY RECORD' when executed in maximised window mode (full screen). 16.3 HF2 15.6
ACI0097889 4D Write documents (4W7) take more time to load when converted to 4WP. 17 16.3 HF5
ACI0097891 4D Server Administration window cann't be opened via 'Help' menu on Mac platform. 64-bit version only. 16 R6 16.3 HF2
ACI0097895 In the query editor, navigation with the arrow keys on the keyboard doesn't work correctly: there is no scroll. Scroll bar stands still. 17 16.3 HF3
ACI0097912 Using client/server encryption downgrades the web server ssl notation. 17 16.3 HF5
ACI0097921 Text input caret is always displayed in black even if the background colour is black too, which makes impossible to locate the caret. 16.3 HF2
ACI0097932 Memory leak with commands 'OPEN PRINTING JOB' and 'CLOSE PRINTING JOB'. 17 16.3 HF3
ACI0097934 Copy and paste SVG picture from 4D 64 bits to a non-4D application does not work. 16.3 HF2
ACI0097937 'SET WINDOW RECT' doesn't move the resize icon after changing the form wizzard window size. 16.3 HF2
ACI0097938 Graphics.dll leads to crash (direct2D) 17 16.3 HF4
ACI0097954 4D Server 64-bit may crash randomly on macOS. 17.0 HF2
ACI0097966 64-bit label editor cannot print in landscape format. 17 16.3 HF3
ACI0097986 In compiled mode, the command 'SET ASSERT ENABLED' with parameter equals to 'False' may not always be applied correctly: 'ASSERT' command can still be enabled. 17 15.6 16.3 HF3
ACI0097992 On Windows system, TrueType fonts not useable in 4D Write Pro, even though they are scalable. 17 16.3 HF3
ACI0098002 A random crash could occur when a menu bar is released. 17 15.6 16.3 HF3
ACI0098025 Japanese IME turns deactivated after a call of 'ADD RECORD' in a button from a form. 17 16.3 HF4
ACI0098037 Cluster Index on object field could be damaged when doing a Sum on a path value. Side effect: 'QUERY BY ATTRIBUTE' may not work correctly. 17 16.3 HF3
ACI0098038 Using the arrow key, cursor doesn't move before hitting space-bar key for conversion when typing japanese text. 17 16.3 HF5
ACI0098042 A freeze of 4D Client as web server can occured if some web requests attempt to read some resources in the structure file. 17 16.3 HF3
ACI0098063 Typing a title containing the letter "n" triggers the "open/select report" window on Quick Report 64 bit editor. 17 16.3 HF4
ACI0098079 Paths for data stored automatically outside datafile are not correct. Folders are badly named, and not created every 100 records. 17 15.6 16.3 HF3
ACI0098094 Not able to compile when using 'Min' and 'Max' commands applied on a date array. 17 16.3 HF4
ACI0098098 Localization issue: In 'FR' release, the constant "Web client adresse IP d’écoute" (value 23) is not present and badly replaced by the 'INTL' constant "Web Client IP address to listen". 17 16.3 HF4
ACI0098107 4D Write Pro: missing check marks in contextual menu after selecting an option. 17 16.3 HF4
ACI0098129 Loading an object variable using 'LOAD VARIABLES' command, makes 4D quits unexpectedly. 17 16.3 HF4
ACI0098157 Since ICU 50, prolonged sound mark ("-") is no longer considered as a letter when the database language is set to Japanese. 17 16.3 HF4
ACI0098163 Creating and editing a record in a listbox, the next new record takes over the value from the last new record entered. 17.0 HF1
ACI0098165 Existing records with a 4D Write Pro area contain unexpectedly all attributes twice. 17 16.3 HF4
ACI0098178 'IMPORT DATA' command used with an empty string for the file parameter doesn't display the open file dialog; 64-bit mode only. 17 16.3 HF4
ACI0098179 Export data to file with a form does not display the related fields. 64-bit only. 16.3 HF5 17.0 HF1
ACI0098184 A problem in the CSS parser exception (brakets considered as a quote) may prevent good conversion of 4D Write expression to 4D Write Pro. 17 16.3 HF5
ACI0098188 Unexpected syntax error "Attempting to retype by using a pointer." with 4D commands 'Min' and 'Max' in compiled mode. 17 16.3 HF4
ACI0098213 'HTTP Get' command fails on Windows system and returns unexpectedly the error #30 ("HTTP Server unreachable") for some web sites. 16.3 HF5
ACI0098246 'ADD RECORD' and 'GOTO OBJECT' combination can disable Japanese IME. 17.0 HF1
ACI0098253 Unexpected error #-20002 with 'SVGTOOL_show_in_viewer' when there is a text with character ‘&’ in the SVG. 17 16.3 HF4
ACI0098260 Runtime error message not explicit when XPS Viewer is not installed (for information, installing Windows 10.1803 may remove the XPS Viewer). 17 16.3 HF5
ACI0098261 In a form opened by 'MODIFY SELECTION', a checkbox in a listbox is non-enterable whereas it should be enterable. 17 16.3 HF5
ACI0098269 Switching the 4D user in 4D Remote thanks to 'CHANGE CURRENT USER' does no more actualize the 4D user column in the 4D Server admin window. 17 16.3 HF5
ACI0098271 In certain circumstances, 'Undo' deletes too many characters in 4D Write Pro. 17 16.3 HF5
ACI0098277 Some of the Shield icon in the Form Editor is wrong from what is defined in the preference. 16.3 HF5 17.0 HF1
ACI0098307 "Cancel" button in the 'Print' dialog does not work in Windows with 4D 32-bit. 17.0 HF1
ACI0098321 Probable crash when MSC check of application with the built 4D Server application. 17 16.3 HF5
ACI0098342 'HTTP Server' does not take compression level into account. 16.3 HF5 17.0 HF1
ACI0098348 After setting "Enable TLS" in user Settings in External File, SQL-connection from client is no more possible. 17.0 HF2
ACI0098351 'SET PRINT PREVIEW' command on a system with XPS Viewer not installed may crash 4D. 17.0 HF1
ACI0098368 A delayed processes do not wake up if paused and then resumed: it stays in pause mode. 17.0 HF1
ACI0098386 The Japanese Input conversion underline colour is always black, which is hard to see if the background is dark (text input and code editor). 17.0 HF1
ACI0098409 'FONT STYLE LIST' on Garamond font may crash if German language is set as language for date and number format. Windows system only.
ACI0098429 'Set Current Printer' may cause a crash of 4D Server 64 bits on Windows.
ACI0098480 'QR RUN' doesn't use FldDelimit or RecDelimit values when output to text file. 17.0 HF1
ACI0098645 "OBJECT Get style sheet" command always returns the style sheet that has ID =0 instead of the assigned one. 17.0 HF2
ACI0098223 4D for OCI constant 'OCI_STMT_DECLARE' was wrongly set with value 39 instead of 9. 17 16.3 HF4
ACI0090544 IMAP_Search (vImap_ID;"";msgNumArray) can make 4D to quit unexpectedly. 17.0 HF1
ACI0096484 'IMAP_SetPrefs' cannot find directories with umlauts in the name. 16.3 HF1
ACI0096656 'IMAP_Search' command is unable to find few messages when the used criteria is "HEADER MESSAGE-ID". 17 16.3 HF3
ACI0096779 Error #-43 returned by 'FTP_Send' because of some accented characters in the 'localpath'. 16 R6 16.3 HF1
ACI0097254 'IMAP_MsgLst' returns error #-120 if an umlaut is in the path name. 16 R6 16 R6 16.3 HF2
ACI0098117 'IMAP_Search' command can make 4D to quit unexpectedly. 16.3 HF5 17.0 HF1
ACI0097377 4D View: when you delete an image from a record and want to check the attribute "keep proportions" in the "image attributes" menu, by double clicking on the same image, 4D may crash. 17.0 HF1
ACI0098097 'Copying' or 'cutting' a 4D view cell which have its stylesheet just removed may lead to a crash. 17.0 HF1
ACI0098476 While editing a formula for a cell, selecting cells with the mouse doesn't show the selection with a Retina screen. 17.0 HF1
ACI0098376 Objects besides a 4D Write area may not be print with 'PRINT RECORD' or 'PRINT SELECTION'. 16.3 HF5
ACI0097882 Time type data is retrieved in a timestamp format instead of usual time format as expected.

New in 4D 16 R6 Build 16R6.221608 (Mar 15, 2018)

New in 4D 16 R5 Build 16R5.219256 (Jan 16, 2018)

New in 4D 16.3 Build 16.217894 (Dec 7, 2017)

Fixed bugs:
ACI0092847 Static text baseline is 2 pixels too high in form editor if the text starts with Japanese.
ACI0093293 Search field of method editor does not display history on macOS system.
ACI0094424 Duplicating a method that ends with a Japanese characters results in duplicate names.
ACI0094675 Moving (from a database to another) 3D objects like buttons, radio buttons, checkboxes doesn't move their associated image.
ACI0094836 Loading Date picker widget after setting a value to the associated date variable erases the variable value.
ACI0094994 Slowness when running an SQL subquery; it may cause the server to lock up.
ACI0095136 Method editor: code can be lost when typing something nearby a collapsed loop.
ACI0095298 Selecting an item in combo-popup list does not validate Japanese IM edit.
ACI0095659 Automatic update for engined server fails if application name contains an apostrophe.
ACI0096026 Error #1013 using 'SQL INSERT' with 'ARRAY TIME' from 4D Remote.
ACI0096028 Error #1111 Execution using 'SQL INSERT' with 'ARRAY BLOB' from 4D Remote.
ACI0096165 4D Server Admin Window Buttons does not working when using English system and English as default language, but select Turkish regional settings.
ACI0096533 4D View: Unable to add a new customized format on cells thanks to the 'Style' menu.
ACI0096615 Deleting and creating index several times in transaction may crash the application, or damage the indexes.
ACI0096646 "HTTP Get" command takes long time to complete.
ACI0096695 Kind of flashing / flickering situation in a window when loading a form. Only with 4D 64-bit ; only on Mac platform.
ACI0096775 Debug window doesn't open when executing the command TRACE in the 'On Exit' database method.
ACI0096801 Wrong object coordinates with 'OBJECT SET COORDINATES' in 'On load' event when the according subform has been resized.
ACI0096836 A project method minimized in Mac OS tray, cannot be brought back using "Goto Definition..." from the Method Editor.
ACI0096870 Quick report: The Document variable is not updated with the newly created document path; only with 64-bit application.
ACI0096875 Keyboard shortcut control - K does not open Explorer when on an empty line
ACI0096892 When you try to import a '.tsv' file that includes Japanese text exported from an older version of 4D, v16 doesn't recognize the tab correctly.
ACI0096943 Scroll to a columns that is right outside of the visible part of the list box and edit a cell of this column; clicking into another cell of this column leads the listbox to jump to the first column.
ACI0096957 Method editor: pressing RETURN at the end of splitted line will combine the line.
ACI0096998 When there are hundreds of tables, it takes several seconds per keystroke to type between 'Begin SQL' and 'End SQL'.
ACI0097003 Choice lists in list boxes do not work correctly with time fields
ACI0097005 Unable to delete files in the list-view of ressources (Toolbox dialog).
ACI0097021 A radio button defined thanks to a resource Id value in a inter-process variable may appear unexpectedly as a check-box.
ACI0097055 Setting the size of max used memory does not work in user settings next to the data file.
ACI0097082 Depending of the Japanese font used, in a variable, if the text ends with a soft-hyphen character (which is not recommended), an unexpected 'dust' character appears.
ACI0097119 A 4D crash may occur when linking a table that requires horizontal scrolling in the structure editor.
ACI0097120 Quickreport: MIN and MAX with date-fields return a number instead of the correct date
ACI0097124 When creating a new DB in Windows, Error 1010 is generated
ACI0097135 4D command 'SVG Find element IDs by rect' is not always able to find an SVG picture.
ACI0097176 Order by Dialog box doesn't allow drag/drop of fields.
ACI0097179 Client is unable to get updated image from custom external data path without database/server restarted.
ACI0097197 A margin is added unexpectedly by few pixels next to 4D write Pro area due to a bad management of a scroll bar size.
ACI0097201 Memory leak with SQL SELECT...ORDER BY on Mac OS system when the sort is done on a text column
ACI0097208 Using 4D Remote 32-bit, when creating a subfolder in the Explorer, the client application may crash.
ACI0097210 Using 4D Remote v16.x 32-bit, unexpected high CPU use with Legacy Network Layer chosen. On macOS system only.
ACI0097219 Following commands, 'ERASE WINDOW', 'GOTO XY' and 'MESSAGE', may crash 4D when used in 'On load' event of a form. Only in 64-bit mode, and only on macOS.
ACI0097233 "On URL Filtering" not triggered after executing a javascript function using WA EXECUTE JAVASCRIPT FUNCTION
ACI0097235 When you have project method in form method of input table form, an unexpected error is generated upon printing preview through Label Editor.
ACI0097236 By using the toolbox dialog, in the tab Lists, list references are renumbered from 1 to N (contiguous number).
ACI0097241 "WA Evaluate JavaScript" raises error "maximum call stack size exceeded" when executing a JQuery command.
ACI0097246 Third parties Japanese IME (like Google IME) is forced to System IME when moving focus.
ACI0097247 An alert or a dialog may unexpectedly deactivate the Japanese IME.
ACI0097248 On macOS system, changing from one page to another can cause the cursor to be displayed on multiple fields at once.
ACI0097257 A connection interruption leaves an undeletable ghost process at the server
ACI0097262 Saving text outside the datafile could corrupt the data if more than 259 bytes is in a text field.
ACI0097264 'ACCEPT' in On Outside Call form event does not close form.
ACI0097278 The use of the Up arrow key to change a listbox cell value thanks to an associated required list prevent to enter the chosen data.
ACI0097282 SQL SELECT CAST (timefield AS TEXT) converts the time value into a number of milliseconds instead of a time string
ACI0097286 'LISTBOX DELETE ROWS' and 'LISTBOX INSERT ROWS' doesn't update correctly the row height array of listbox.
ACI0097289 'On Web Close Process' database method is not executed when 4D kills a Web process automatically, except when calling 'WEB CLOSE SESSION'.
ACI0097295 4D Server running as a Service will lock up if ALERT or Range Checking Error is displayed on Server
ACI0097297 Object method of a combo box or a popup having as variable name a field name, is not triggered in compiled mode.
ACI0097314 Stop button of the printing dialog has no effect in v16.x (using NQR and XPS Writer). it may lead to a crash on v15.x .
ACI0097316 Unable to launch 4D.exe from a network drive under windows 10.
ACI0097319 Crash when deleting a record used during a complex JOIN in SQL.
ACI0097321 Fields references are lost when moving a listbox from a database to another.
ACI0097322 'GRAPH' returns empty image with a 64-bit 4D Volume desktop application.
ACI0097330 Listbox: in a cell, the descender height of a letter can be shortened with 4D v16.2 .
ACI0097341 Ghost connection left on server after canceling from User Identification (login dialog) window.
ACI0097352 4D can crash when quitting if an SVG picture is inside the pasteboard.
ACI0097353 4D could freeze or crash when loading a record after a network shutdown.
ACI0097354 Login window position issue (access to the window) when passing from a 2 screens mode to 1 screen on the same computer.
ACI0097357 SVG pictures are displayed improperly in Resources tab of Toolbox dialog.
ACI0097359 Arrows keys navigation doesn´t work correctly in the expanded pop-up of the Query editor.
ACI0097369 "DOM Parse XML source" command fails to parse an XML file containing a default namespace URI.
ACI0097370 "On Server Close Connection Database" not executed on a lost connection; no problem with legacy network layer.
ACI0097380 The more people connected to 4D Server, the longer is the print of a label. With 64-bit applications only.
ACI0097383 No data sent to MS SQL if one of the values contains an empty string.
ACI0097408 A mouse click done in an enterable variable outside an Arealist plugin area is not always taken into account correctly.
ACI0097411 Small-Caps doesn't work in 4D Write Pro.
ACI0097413 The 'Request' 4D command returns the default value (set from the second parameter) despite canceling the dialog.
ACI0097448 "On Data Change" event doesn't fire on Combo box object if "On After Edit" event is enabled.
ACI0097457 Automatic update for engined remote application (client) fails if application name contains an apostrophe
ACI0097460 Multiple simultaneous remote applications update crashes the applications
ACI0097479 "DOM Parse XML source" fails to parse a XML file with a DTD and generates error -9935 "XML not valid...".
ACI0097482 Can't kill thanks to the button 'Kill process' a sleeping connection (4D Remote in sleep mode) from 4D Server.
ACI0097486 On macOS 10.13 (High Sierra), unresponsive print dialog stuck on screen with 4D 64-bit.
ACI0097495 4D crashes if the option key is pressed over a hidden collapse/expand icon on the method editor.
ACI0097519 "SVG Find element ID by coordinates" fails to find elements (rects, paths, etc) that have their fill color set to "black".
ACI0097521 With masOS 10.13.x (High Sierra), there is a bad display of pop-up icon (an arrow) in listbox cell when hovering over it with the mouse. The icon may disappear.
ACI0097537 4D may quit unexpectedly when calling 4D components that are compiled with more recent versions than the one used to load the host database.
ACI0097545 A postponed user connection process is not deleted on 4D Server when a 4D Client quit abnormally.
ACI0097564 Unexpected Runtime internal timer error #22 during a Backup.
ACI0097572 Cursor jumps to wrong line or wrong position in the current line, after 2 or 3 keystrokes using Japanese input, if the current line is not last.
ACI0097621 Cascading menu items missing in "Database Settings" menu on a built Server application.
ACI0097635 Command "Get file from pasteboard" takes very long time (1mn) on Mac OS X High Sierra
ACI0097253 The command 'POP3_SetPrefs' returns an error #-120 if an umlaut character is in the path name.
ACI0097254 IMAP_MsgLst return error -120 if umlaut is in the pathname
ACI0097302 4D Internet Commands"MSG_GetBody" and "MSG_Extract" are slow when using 4D v16 64-bit.
ACI0097368 The 4D Internet command 'MSG_extract' doesn't recognize Japanese file path correctly.
ACI0096532 4D View: Unable to apply a customized format on a cell using the pop-up in the tool bar.
ACI0097083 A field reference other than the selected one is inserted in 4D Write if using dynamic field names and hidden fields

New in 4D 16.2 Build 16.214903 (Sep 6, 2017)

Significant variation between graphing XML created in 32-Bit vs. 64-bit 4D
Vertical positioning of text "sinks" low in listbox cell during edit. Japanese text can't be typed properly. Only in 64-bit mode, and only on Windows system.
"Type" command doesn't return the same value for an Array blob in compiled and interpreted mode
HTTP Request (and/or HTTP Get) does not always return the total request result depending of the response size.
Many japanese font names are missing in Toolbox dialog, styles part.
'WA Open URL' on a pdf file with integrated webkit makes 4D to quit.
When creating a virtual structure using 'SET TABLE TITLES' then using the query editor, the tables are not ordered at all.
The 4D command 'SET ABOUT' causes OEM 4D Server to crash when ran as a Windows service.
Automatic drag and drop of picture between objects can take several seconds to complete.
Long concatenated non-ASCII text constants are partially lost when converted from v14 to v15 (or to v16).
When setting the Horizontal Sizing option of a list box (selection ou tableau) to Grow, if you type in the list box and before tabbing out, resize the form, 4D replaces the entered value with the old value of that column.
Dragging and dropping a file to the desktop doesn't work.
Tooltips remain visible in the method editor when typing code (64-bit only).
When You set the alternate row background color of a listbox using code, the extra padding column added when Listbox Column Auto-Resizing is turned on has every other row in black.
Multiple clipboards in method editor: lack of consistency about shortcuts information between Help tips and the official Documentation.
Popup drop down crashes when there is only a “-“ as an element.
The 'On selection change' event isn't triggered if user clicks an empty row and the previous selected line is a node (hierarchical listbox).
In form editor, cancelling the object tool popup menu closes the editor
In structure editor, changing the font name has no effect. 64-bit application only.
ACI0096320 In the form editor Property list palette, after clicking the Print settings button, and then closing the Print settings dialog, the palette doesn't reappear. Only in 64-bit application.
Picturebuttons with FR accent/DE umlaut in file name don't work
Data is not exported correctly via odbc using the 4D dialog if the first field is not also chosen.
When importing a big ".4UG" file; it leads 4D to run with poor performance.
Using the legacy network layer, 4D Server can unexpectedly freeze while execute processes thanks to 'EXECUTE ON CLIENT' and 'Execute one server'.
Web area doesn't lose the focus after clicking into any other 4D object.
Missing 4D icon in splashscreen application window.
There is a latency when deploying a hierarchical list having the horizontal scrollbar enabled.
4D Write pro: Columns blend into tables if the text in the column contains multiple lines.
Error 9922 raised when sending a short data type Varchar or Char to Mysql database using actual ODBC Driver
Inactive menu items become active when executing some 4D commands
A v13.x query file (".4df") wich contains several query-criterias is wrongly loaded by more recent 4D.
'HTTP Get' request can fail depending secured (https) web sites.
'HTTP Get' command may cause 4D to quit when reading data in chuncked transfer encoding mode.
Icons included into OEM Build only have very small resolution
"Modal dialog" window have no borders or shaders
'OPEN COLOR', 'FONT PICKER' crashes if used in a non-focusable, non-enterable text input.
When an error dialog is generated in a detail form, the Japanese IME is disabled
Japanese text is limited in alpha field only in Mac/64 bit combination
Incorrect result when sending multiple Queries on an indexed table field within a Transaction.
Unexpected error when attempting to launch 4D from a path that contains non_roman characters. For instance with a "d" in the path.
Erratic behavior of enumeration associated with a numeric listbox column.When we choose a value in the enumeration, several lines are modified at the same time.
'HTTP Request' can return unexpectedly an error #5 instead of #404.
Form editor 'Object' menu won't update after using "Move to back" menu item.
After loading a query formula which contains a 'is between' query, the start-field will be replaced by the end-field.
ACI0096677 In hierachical listbox, when scroll at one line by using command OBJECT SET SCROLL POSITION and the line belongs to a hierarchical level that is collapsed, last rows are not displayed when you scroll at the end of listbox.
ACI0096684 "Remote mode" information missing in About dialog (unexpectedly, there is instead "Server").
'BUILD APPLICATION' command doesn't build 64-bit '.4DC' file if 'Stand-alone' option is checked.
PRINTERS LIST adds NULL character behind the printer names
The "ON EVENT CALL" method is called twice unexpectedly with 4D 64-bit on Mac when a keyboard key is pressed.
Unexpected quit of 4D could occured when a shortcut was applied to an accept button
License issue: "4D Application Server connections" used counter not reset after a network failure
Bad object name display for 4D Write Pro area in design mode.
Some disconnection or freeze can happen on a client side, after several sleep and awake mode
'WA Evaluate Javascript' doesn't always recognize the types Date and Object.
"WEB SEND HTTP REDIRECT" command called from within a component doesn't succeed
4D Write and converted 4D Write Pro documents doesn't look similar
"HTTP SET OPTION" command does not set correctly the 'HTTP compression' setting .
HTTP REQUEST command returns error when passed by the proxy
Engined application shows unexpected Runtime error (#-10518) if opened with MSC (alt-key) without selected data file.
4D may freeze when quitting after an execution of an SQL query that uses "left OUTER JOIN" on indexed date fields.
Popup window no longer closed with external click after an alert display.
Checkboxes in a listbox filled with boolean values are not showed if printed.
If you open the database settings on a engined Server and open the Client_Server Tab, there is an error.
After a new form creation the 'Inherited form name' list is not filled correctly
In a form, if filling two listboxes with two SELECT * FROM xxx_1 INTO << yyyy >>, we have objects (column, header, footer) with the same name.
Default disconnection error message should be changed to ""A disconnection error occured with the server. You should restart the application.”"
The Web DIGEST authentication ('Passwords with DIGEST protocol' setting enabled) causes inappropriate long waiting time.
Umlaut character can't be pasted in a multi-style text variable/field if copied from an apple mail.
In some cases application process isn't close on windows server administration when quit 4D client.
4D font weight is lower (thinner then) than it should be with 64-bit application.
Connection to 4D Server Dialog OK Button Not Enabled
Memory leak can happen when loading Object Arrays into a Listbox.
Let the Horizontal Sizing option of a list box (selection or array) set to 'Grow'. Resizing the listbox while editing in a cell, the edition area isn't sized correctly.
Using 'HTTP AUTHENTICATE' method with Digest Authentication: URI Mismatch Error triggered for 'HTTP Get'.
DirectWrite font styles are not supported while printing with 64-bit applications.
The 4D Dock icon does not show the list of windows that are open with 4D 64bits
Can't select listbox rows properly after using the command 'LISTBOX SET ROW HEIGHT'.
While scrolling a records list using a form that uses a 'On display detail' event , displaying a pop up menu by right-clicking can unexpectedly quit 4D.
With 4D 32-bit MAC: design mode unusable opening a form containing a subform with a listbox with automatic column resizing.
Unexpected empty confirm window in Toolbox dialog (Resources tab) if deleting multiple items at once.
Open windows are not saved after 4D is closed (test application mode)
On Windows 10, depending the system regional settings, 4D Server may not start at launch; for instance with English (Belgium), English (International), ...
Unable to select more files in Toolbox Thumbnal-view using <cmd>.
When a window at the background containing a selection is been re-displayed, it can switch unexpectedly to the front (Windows system), or remove unexpectedly the focus of the frontmost window (macOS).
Unexpected memory leak when using the 4D command 'Max' with an alphanumeric field as first parameter.
'BLOB to print settings' does not load the information of the print range.
'SQL EXECUTE' fails to execute correctly an 'INSERT' instruction when a value contains brackets.
A runtime error can occur when stopping a backup.
Quick report: Invisible columns width are unexpectedly taking into account for the calculation of a report.
'On close connection' could not be executed completely.
Selecting a table in the tables list after scrolling it doesn't work correctly.
A complex SQL query that uses JOIN mechanisms may quit unexpectedfly 4D Server 64-bit when executed several times.
The command 'SET ALLOWED METHODS' doesn't work on 4D Server.
4D Label Editor x64: Error dialog after right click on picture field if a ".4lb" label elditor file is used. 64-bit version only.
After creating only one row in a listbox with 'APPEND TO ARRAY', this row is not selectable. No problem with several rows created.
"On data change" event is unexpectedly triggered when tabbing out of a combobox whereas no value has been entered ; this happens if this object is the first object of the form entry order.
Menu items icons associated in the Menu editor do not appear. Only in 64-bit mode.
Hover the mouse over multistate picture buttons doesn't change picture correctly.
"OCIBindByPos" may cause the application to quit unexpectedly when called twice.
A picture send in attachment with SMTP_Attachment is show up two times in Apple Mail
SMTP_SetPrefs does add incorrect line wrapping when BASE64 encoded.
Sending HTML email with 4D Internet Commands, a NULL character is added at the end.
ACI0096804 'FTP_GetDirList' is very slow when directory contains numerous items.
PDF attachment is missing in opened mail if using iOS system (IPhone / IPad).
On macOs, 4D can crash during a drop event on legacy 4D Write area.
When executing the "WR DELETE OFFSCREEN AREA" command, the memory is not freed on Windows 10 v1703. Use Microsoft system update "KB4025342" to get a fix.
Invalid table names returned via ODBC Driver on Mac OS X; table names are truncated: "[table_1]" is returned as "[tbe1]".

New in 4D 16 R2 Build 16R2.209603 (Mar 30, 2017)

New in 4D 16 Build 16.207104 (Jan 11, 2017)

High-speed object database:
Up to x10 speed improvement just by upgrading
Dramatically faster queries and data access with the new 64-bit database cache
Blindingly fast access to your data, schema or schemaless
More Processes, More Memory, More Users:
Make your solutions scalable with 4D v16 64-bit
Benefit from almost infinite memory to manage
high volume data
Take advantage of multi-core machines to support hundreds of desktop users or thousands of web users
Ready for the future. New product line entirely
based on the latest macOS and Windows APIs
Enhanced development capabilities:
With 4D, develop faster and focus on your business logic first
No more rigid data model thanks to the object database. Flexible and fast!
Asynchronous programming for an optimized and efficient use of system resources
Fully customizable listbox objects, entirely adaptable to user needs
4D language enriched with 50+ new commands and additional programming options
New powerful integrated text engine:
Embrace modernity with 4D Write Pro for smooth development
Programmatically generate your catalogues, invoices and reports with ease
Fast and flexible development with objects
Rapidly create your documents using templates and bookmarks
Rich and immersive user experience:
Simply upgrade to 4D v16 and automatically benefit from an engaging user interface and enhanced usability
Modern Label editor, Quick report and Import-Export dialogs, intuitive and easy to use for your end-users
Your business applications instantly adopt the latest look and feel guidelines on both macOS and
Windows platforms
Save time with the fully automatic reconnection when a client awakes from sleep
Thanks to Single Sign On, log in to your Windows session, and voila you’re also logged in your 4D application!
Bugs fixed:
ACI0066193 LOG EVENT(Into 4D Commands Log) is not Unicode-compatible.
ACI0069623 The 4D command 'SET FIELD VALUE NULL' does not work on UUID field.
ACI0095452 Quik report's toolbar doesn't get refreshed/updated when selecting report cells .
ACI0095487 The fields position in a label is incorrect in v15 after a database conversion.
ACI0095496 Listbox footer calculation not correctly typed with SQL results: Reals are unexpectedly typed in Integer.
ACI0095503 In the Property list palette from the Form editor, choosing a style-sheet in the pop-up with the keyboard may lead to a crash.
ACI0095505 Right justification of a text is displayed over other field in a output form.
ACI0095533 When you initially display the tables list in Design Mode, the displayed records selection does not correspond to the selected table.
ACI0095540 Quitting 4D Server may lead to a crash if the window 'Runtime Explorer' is open. Mac only.
ACI0095562 Tips remain visible even if other window of an other application is in front of 4D.
ACI0095574 4D still saves a picture as PICT when dragging and dropping a picture into a field
ACI0095581 Just written Japanese text in listbox cell disappears when clicking in another cell while still in the IME (text not yet validated)
ACI0095582 Need to press delete (or backspace) twice to clear the last edited Japanese character.
ACI0095610 Unexpected errors when an 'Auto Update' of application is performed because of a virus scan run.
ACI0087565 'LAUNCH EXTERNAL PROCESS' doesn't set OK to zero when the called command doesn't exist.
ACI0088073 A record can't be deleted because of an attempt to delete its related records in transaction, even if the transaction has been canceled.
ACI0088141 Structure Editor: Unexpected error -20001 when ordering fields using the arrow buttons in the Index list dialog.
ACI0089189 Query editor: when typing BackSpace key in 'Find' area, the text edit behaves inconsistently.
ACI0091205 The xml error returned by the command 'SAX Get XML node' contains a negative line value when the referenced node is over MAXINT value.
ACI0091247 Wrong display when writing a carriage return in a hierarchical list item.
ACI0091264 Thanks to the command 'String' (with 'ISO Date GMT'), the clock is not correctly taken into account for the Daylight Saving Time.
ACI0091658 Query editor displays one or several tables without a name (“[]”) when using the 4D command "SET TABLE TITLES".
ACI0091711 Unexpected empty alert may appear when loading query files.
ACI0091810 In Form editor, duplicate a column and undo the action lead to a bad redraw of the listbox.
ACI0092067 Impossible to drop an index of an Object type field using the "Index List" dialog in the 4D Structure editor.
ACI0092274 Shortcut to stop catching events with a method doesn't work since v14.x.
ACI0092571 Checkbox "Use Legacy network layer" unchecked after conversion from v14 if using User settings
ACI0092650 Japanese conversion guideline (line under the word) misplaced when method code has multiple lines.
ACI0092893 After re-opening a same database without quitting 4D application, a plugin (4D Write, 4D View) can no more be available from the toolbar.
ACI0092903 Some servers truncate the mime message when exporting from 4D Write Pro.
ACI0092919 In Japanese localization, incorrect label in Query editor history when time criteria is "lasts exactly".
ACI0095623 Unexpected error #-9977 with empty selection and "LONGINT ARRAY FROM SELECTION".
ACI0093483 Unexpected blank page can be printed with the 4D command 'PRINT FORM' depending of the position of 4D Write Pro and form markers.
ACI0093521 Client auto-update fails if new server version has SSL activated (Network connection error).
ACI0093541 In the Structure editor, editing a field can create an unexpected scroll of the table in the editor.
ACI0093776 In Export dialog, 4D can quit unexpectedly when entering a value with a slash ("/") in one of the delimiter fields.
ACI0093858 Break Markers are sorted incorrectly if you have more then 1 of it.
ACI0093949 Hierarchical pop-up changes value unexpectedly when a form window is opened, and then closed in the same process containing the hierarchical pop-up.
ACI0094031 Log commands list defined by SET DATABASE PARAMETER is ignored on 4D Remote.
ACI0094069 Pictures are not displayed on Outlook when exporting from 4D Write.
ACI0094154 The 4D command 'Select folder' doesn't always scroll within the area until the folder is visible.
ACI0094194 Executing the command 'CONFIRM' after selecting with the keyboard an item in a popup may quit 4D unexpectedly.
ACI0094250 Unexpected errors (#1010, #3585) when creating a database with the Japanese version of 4D Server Mac 64-bit.
ACI0094273 Wrong value in the test area preview of filters in the Toolbox dialog.
ACI0095625 Clicking in a numeric input area doesn't always select all the number, depending if it is defined through the Property list palette or defined by programming (declaration).
ACI0094466 The command 'MESSAGES OFF' doesn't work when called before the command 'BUILD APPLICATION'. The progress bar is never removed.
ACI0094484 The plain border colour of text input is always black.
ACI0094545 Listbox: 'OBJECT SET FONT SIZE' applied on a listbox may not work on headers.
ACI0094570 The 4D command 'FORM SCREENSHOT' returns low-resolution screenshot on Retina screen.
ACI0094574 Resizing splash screen at start-up may not resize the picture correctly.
ACI0094581 4D crashes in compiled mode when executing this mistaken code: QUERY([table];[table]field;*) .
ACI0094592 On Mac OS X 10.11.x (El Capitan), a CANCEL button is to short for german text: need to see the word "Abbrechen" entirely.
ACI0094604 Combo box items list window stays on screen if opened by left and right click together.
ACI0094651 Printed picture listbox columns have black backgrounds.
ACI0094654 Error 59 when trying to switch to the “Layout” tab in the Label editor dialog.
ACI0094670 Help menu not functional when using the 4D command 'MODIFY SELECTION'.
ACI0094700 In the explorer, methods in a folder can unexpectedly move to an other folder when clicking quickly between folders.
ACI0094753 Setting Web inactive process timeout using command WEB SET OPTION has no effect.
ACI0095627 Problems of copy/paste between multi-styled text area and simple text area.
ACI0094807 Running the database method "On SQL Authentication" returns an IP address of the host in the $3 parameters instead of the IP address of the client that is trying to connect.
ACI0094816 4D always re-generates the "Index.html" file after restarting the web server.
ACI0094834 Some OTF fonts are cut off at the top in 4D Write Pro.
ACI0094837 Impossible to change a listbox column font to the %Password.
ACI0094868 Impossible to select several listbox headers at a time, whereas is is possible for columns (multiple selection).
ACI0094901 4D command 'Mod' can return a wrong number if the value passed to the command is close to the maximum limit of the digits available.
ACI0094947 'LISTBOX SELECT BREAK' not correctly executed if run in the same method that creates and populates a hierarchical listbox.
ACI0094976 Calling a Web Service by passing a blob parameter returns a zero-byte compressed blob.
ACI0094978 Creating a view with 'SQL Execute' can lead to a crash.
ACI0094982 DOM Count XML element is not case-sensitive.
ACI0094988 'LISTBOX SELECT ROW' could not work when executed within a method launched from the object method of the hierarchical listbox.
ACI0094995 Japanese text in method editor blinks unexpectedly.
ACI0094996 Japanese text shifts vertically in multi-styled listbox cell.
ACI0094997 Problem with SVG command SVG_Copy in x64 version, the reference was empty
ACI0095000 Cannot remove composite index containing a primary key or a field of unique type anymore.
ACI0095018 This code, OPEN SETTINGS WINDOW("/Database";True;User settings), with "Enable User Setting in External File" unchecked lead 4D to quit unexpectedly.
ACI0095020 Bad date format while entering a value when query operator is "Starts from" or "Is after".
ACI0095030 Quick Left to Right click causes 'On Double Click' event.
ACI0095036 Due to a syntax error while compiling, Japanese variables are wrongly displayed.
ACI0095042 The command "Dec" can return a wrong value.
ACI0095055 Unverified Japanese text in IME gets verified when switching application. This is fixed on Mac platform but not on Windows platform as it is the wanted behaviour.
ACI0095077 The access to Hunspell dictionary thanks to the line "SET DATABASE PARAMETER(Spellchecker;1)" could lead to a crash if the path of the application (and so for the Hunspell) contains a diacritical characters.
ACI0095085 After clicking CANCEL button in the 4D Server shutdown window, client connections (current and new) are rejected.
ACI0095091 Possible freeze using a Hierarchical drop down placed in an input form of a subform.
ACI0095118 Same array used in several columns prevents to sort a listbox correctly.
ACI0095129 In very heavy condition (loads of records created by several processes), during the ‘New Log File’ execution, some actions could not be integrated correctly in the new log file.
ACI0095155 The too strong mouse click sensitivity prevents to move properly objects in form editor.
ACI0095163 In the code editor, the tool tip of the command 'ST SET PLAIN TEXT' ('ST FIXER TEXTE BRUT' in french) is never displayed in french.
ACI0095181 The 4D command 'IMPORT TEXT' is very slow.
ACI0095184 Printing can not be correct when "Print Variable Frame" is selected on a field, because of a wrong calculation of object position by 4D.
ACI0095211 Type ahead in combo boxes is broken.
ACI0095231 Auto Updater Error Log shows inaccurate error message: there is an unexpected 'Invalid Parameter' error (For instance: [xbox] ERROR - [661] Invalid Parameter)
ACI0095232 'BLOB TO USERS' does not import users correctly into the database structure.
ACI0095234 When call 'SET PRINT PREVIEW (true)' before 'OPEN PRINTING JOB', the first time the page is sent to the printer.
ACI0095250 Picture field with 'Stored outside data file' property can not be load or created within a transaction.
ACI0095255 If a first record has moved after sorting a listbox selection, modifying the new first record modifies the previous first record.
ACI0095257 Impossible to set the cursor at the end of a field with the mouse when the text ends with a space char. Also, Space characters just entered are displayed wrongly.
ACI0095265 'Get last query plan' and 'Get last query path' always return the info of the first query run after activating with 'DESCRIBE QUERY EXECUTION (true)'
ACI0095271 Text color becomes white for selected items in a non focused listbox.
ACI0095286 If applying a format for a report, it is done on the header instead on the value if the destination is an HTML file.
ACI0095321 The menu “Help:4D SVG” doesn't work when a window called by MODIFY SELECTION is in the front.
ACI0095354 Forms of a type 'List form for printing' created with the Form wizard are corrupted (warnings about non unique object from the MSC).
ACI0095359 It is not possible anymore to catch a right-click on a radio button, whereas it works with a checkbox button or a simple button.
ACI0095394 Cross-origin resource sharing (CORS) protection is unexpectedly effective in 4D.
ACI0095632 Text areas are too small in Structure inspector for Japanese system localization.
ACI0095633 When the splash screen is hidden in database settings, the edit menu is unexpectedly actived by default.
ACI0095651 Quick report leaves a ghost window after using the Open dialog.
ACI0095681 The backgroud color of a listbox cell gets always white when entering characters in it. Even if listbox is transparent.
ACI0095686 'Old' queries files ('.4DF' files), like those made with 4D v13.x are not readable with 4D v15.x.
ACI0095695 Wrong error message if creating a new form with an already existing name.
ACI0095726 Web service assistant create deprecated code : '_o_C_STRING' appears instead of 'C_TEXT'
ACI0095739 Debugger Trace's window freezes when used with popups
ACI0095746 If " SET DATABASE PARAMETER(Circular log limitation;1) " is called before log activation (using a log recording selector), the log limitation is not respected.
ACI0095772 Moving a form between two opened structure can generate incorrect script associations for several objects.
ACI0095780 Some landscape PDFs are displayed in the wrong proportion (e.g. scanned and rotated document).
ACI0095790 Quick report leaves phantom window after using save dialog (TXT or HTML file export)
ACI0095794 Auto-Update license not prompted if you close the App window to return in Design mode
ACI0095804 4D may unexpectedly quit after compacting without compacting the address table and then compacting again with compacting the address table. Same thing happens if compacting once when database structure is read only.
ACI0095819 A boolean expression can wrongly update a form object (radio button, listbox, etc ...).
ACI0095832 In I.M.E. mode (Input Method Editor), hitting backspace to request conversion candidates for just entered Japanese characters can delete these chars of the area.
ACI0095844 4D Write Pro license unavailable in Client/Server
ACI0095847 In some case the print preview is not displayed on Windows 10 (1607)
ACI0095853 Searching through all methods thanks to "Find in Design" menu leads 4D to hang for some seconds if loads of methods in the database.
ACI0095854 'HTTP GET' does not receive some specific text file where the charset is not indicated; and it returns the error #200.
ACI0095885 Horizontal scroll doesn't work if non-enterable text area has no vertical scroll bar.
ACI0095890 From a 4D modal and movable window, if opening a system window like the 'Open file dialog', and going back and forth between the finder and 4D, the system window goes behind the 4D modal window and 4D gets stuck. Only on macOS 10.12.x (Sierra).
ACI0095892 Signing application failed on macOS 10.12.x (Sierra).
ACI0095935 Issue when launch build application on macOS 10.12.x (Sierra): a "Can't load Error ..." dialog may happen.
ACI0095950 'OK' variable is never set to the value 0 using 4D command 'RECEIVE RECORD' beyond the end of a document.
ACI0095967 Copy/Paste PICT pictrue from 4D Write to a form doesn't work.
ACI0095973 4D may crash on specific Sierra system (macOS 10.12.1.16B2657) after clicking into Property List palette of form editor.
ACI0095981 An unexpected ghost window (in a new process) can be left after closing an editor (Label editor, Export editor, ...)
ACI0095992 4D may crash when opening old quick reports (from v6.x or v2004).
ACI0096018 SVG rendering engine is not correct with the "Arial Black" font.
ACI0096021 4D Server 64-bit crashes on macOS 10.12.1 (16B2657) when using 'Update license' dialog.
ACI0096047 Deferred activation: the registered license doesn't appear immediately in the licenses manager dialog
ACI0096050 Using 4D command 'CONVERT PICTURE' to convert a PICT picture to a Jpeg picture can lead to a crash on macOS 10.12.x (Sierra).
ACI0096051 Saving a PICT picture to the disk can lead to quit the application unexpectedly.
ACI0096082 Fields horizontal alignment always “right” when format is applied.
ACI0096137 Crash when clicking in the welcome wizzard
ACI0096139 label editor : You can't select .4lb or .4blp files on mac With 4D 64 bit
ACI0096144 QUERY BY ATTRIBUTE with date attribute and null values don not work correctly in C/S
ACI0096191 Unexpected black screen with recent Windows 10 update (Since 13th of December ?) if going into the INPUT page of a record display thanks to a listbox, and when locked record dialog appears. It happens only with 4D 32-bit since v15.
ACI0094431 4D Internet Commands do no more send German diacritical chars like "ä", "ö", "ü", or "ß".
ACI0095543 "AP Print settings to BLOB" may crash 4D 32-bit on Windows 10.
ACI0095017 Wrong error code with 'AP Is Picture Deprecated' with 64-bit application on a PICT picture.
ACI0095198 'PV Create picture' create picture with bad transparency (picture interferences).
ACI0095653 4D View 'Advanced Properties' not visible in Properties Palette. The fix is in 4D and 4D View.
ACI0096053 The 4D View formula editor area in the toolbar is unexpectedly black since v15.3 .
ACI0093999 Cursor disappears while writing in 4D Write.
ACI0094114 The 4D Write command 'WR PRINT' no longer able to overwrite a document (for instance 'PDF') since v15.
ACI0095051 4D Write spellchecking is very slow.
ACI0095060 The "Save" menu command displays the standard Save File dialog even if the document already exists on disk.
ACI0095303 The 4D Write command "WR Get on error method" can randomly damaged the memory and lead the application to quit unexpectedly.
ACI0095305 Because of a web area in a form page, it can prevent to enter text in a 4D Write area in another page.
ACI0094884 4D ODBC Driver truncates data over 255 chars with OpenLink JDBC Bridge.
ACI0095714 ODBC driver returns error #9922 if last character in a word is a diacritical sign as è,é or ä (using fields).

New in 4D 15.3 Build 15.205412 (Nov 23, 2016)

Library Update:
Open SSL: Upgrade to version 1.0.2j
Bug fixes:
The event 'On display detail' is executed before the event 'on load' in a listbox.
LOG EVENT(Into 4D Commands Log) is not Unicode-compatible.
The 4D command 'SET FIELD VALUE NULL' does not work on UUID field.
The code OPEN SETTINGS WINDOW("/Database";True;User settings), running without authorizing user properties, brings an expected error #-10531 with a wrong error text.
The fields position in a label is incorrect in v15 after a database conversion.
Listbox footer calculation not correctly typed with SQL results: Reals are unexpectedly typed in Integer.
In the Property list palette from the Form editor, choosing a style-sheet in the pop-up with the keyboard may lead to a crash.
Right justification of a text is displayed over other field in a output form.
Tips remain visible even if other window of an other application is in front of 4D.
4D still saves a picture as PICT when dragging and dropping a picture into a field
Canceling the choice of a font selected in the font picker could not work; the font is keep selected.
'LAUNCH EXTERNAL PROCESS' doesn't set OK to zero when the called command doesn't exist.
The 4D command 'LISTBOX GET HIERARCHY' quits the application when the column number is equal to 0.
Query editor: when typing BackSpace key in 'Find' area, the text edit behaves inconsistently.
Unexpected error #404 when using component method called from 4DACTION.
The xml error returned by the command 'SAX Get XML node' contains a negative line value when the referenced node is over MAXINT value.
Wrong display when writing a carriage return in a hierarchical list item.
Unexpected empty alert may appear when loading query files.
In Form editor, duplicate a column and undo the action lead to a bad redraw of the listbox.
Impossible to drop an index of an Object type field using the "Index List" dialog in the 4D Structure editor.
Shortcut to stop catching events with a method doesn't work since v14.x.
Checkbox "Use Legacy network layer" unchecked after conversion from v14 if using User settings
Japanese conversion guideline (line under the word) misplaced when method code has multiple lines.
Japanese underline is in wrong place when there is too much variable.
Drag and drop from and to the same hierarchical list item can lead to a crash.
After re-opening a same database without quitting 4D application, a plugin (4D Write, 4D View) can no more be available from the toolbar.
Some servers truncate the mime message when exporting from 4D Write Pro.
In Japanese localization, incorrect label in Query editor history when time criteria is "lasts exactly".
The property list is not updated when creating or deleting a marker in a form.
4D can quit unexpectedly when testing a new menu bar juste created.
Client auto-update fails if new server version has SSL activated (Network connection error).
In the Structure editor, editing a field can create an unexpected scroll of the table in the editor.
In Export dialog, 4D can quit unexpectedly when entering a value with a slash ("/") in one of the delimiter fields.
Break Markers are sorted incorrectly if you have more then 1 of it.
Hierarchical pop-up changes value unexpectedly when a form window is opened, and then closed in the same process containing the hierarchical pop-up.
Double click just after the last work of a text does not select the last word.
Wrong vertical position for a Popup menu when using 2 screen monitors.
Circular log limitation ignored; on 4D Remote only.
Log commands list defined by SET DATABASE PARAMETER is ignored on 4D Remote.
The 4D Write command 'WR SAVE DOCUMENT' ignores ".txt" extension when saving to UTF format. Problem fixed in 4D and 4D Write.
Pictures are not displayed on Outlook when exporting from 4D Write.
The 4D command 'Select folder' doesn't always scroll within the area until the folder is visible.
Executing the command 'CONFIRM' after selecting with the keyboard an item in a popup may quit 4D unexpectedly.
Unexpected errors (#1010, #3585) when creating a database with the Japanese version of 4D Server Mac 64-bit.
Wrong value in the test area preview of filters in the Toolbox dialog.
Using the 4D command 'SET PRINT OPTION', the Orientation option is not taken into account if set before the Paper option. Only in preview mode.
Quick report: using cross tables, the 'Sum' function doesn't work correctly; values are in seconds instead of hours.
Problem with some fonts that don't appear in the list of the label editor (like some printing fonts).
High Combobox has wrong select button size on 'El Capitan' Mac system. This is fixed but there is only 3 sizes for that button (limitation on Mac OS X 10.11).
Binding Array blob using "SQL Select Into" causes no array population and runtime error.
The command 'MESSAGES OFF' doesn't work when called before the command 'BUILD APPLICATION'. The progress bar is never removed.
The plain border colour of text input is always black.
Listbox: 'OBJECT SET FONT SIZE' applied on a listbox may not work on headers.
Filter names just modified in the Toolbox dialog are not saved correctly.
Wrong stack level in debug log when using 'Log command list' database parameter.
'EXPAND BLOB' can bring up an error message when expanding a tiny blob compressed with GZIP.
Three state checkboxex in a listbox column don't work as expected: the third value is never reached.
The 4D command 'FORM SCREENSHOT' returns low-resolution screenshot on Retina screen.
In a text variable with auto wrap, and automatic vertical scrollbar, the content is displayed over the scroll bar area.
Resizing splash screen at start-up may not resize the picture correctly.
On Mac OS X 10.11.x (El Capitan), a CANCEL button is to short for german text: need to see the word "Abbrechen" entirely.
Combo box items list window stays on screen if opened by left and right click together.
'HTTP GET' with a not specified Content-Type header may return empty content.
A query using automatic relations through report editor can lead to a crash.
In certain circumstances, 2 mouse clicks, instead of 1, are needed on SAVE button (or CANCEL) in form editor to make it work.
Creating new SQL schema replaces existing default schema instead of been added.
Printed picture listbox columns have black backgrounds.
4D may unexpectedly quit when logging to LDAP with a wrong password.
Help menu not functional when using the 4D command 'MODIFY SELECTION'.
When typing Korean text in an input field, last char is cut off.
Text area scrollbars redraw problems when moving a splitter over it.
Wrong appearence of menus (Bold menu text, menu separator line, ...) when creating by programming.
In the explorer, methods in a folder can unexpectedly move to an other folder when clicking quickly between folders.
Invisible cursor in a listbox cell because of a Popup window.
'SET QUERY DESTINATION' can lead to a crash in the Client-Server mode.
Wrong graph drawn by the command "GRAPH" when value(s) used is 0.
Records open slowly if large text is saved in a field.
4D may crash on quitting the application if 'On exit' database method gets too much time to run.
Setting Web inactive process timeout using command WEB SET OPTION has no effect.
The "Random" 4D command produces same serie after restart on Mac.
Problems of copy/paste between multi-styled text area and simple text area.
The server computer name is badly displayed in the connection dialog if it contains Japanese characters.
4D always re-generates the "Index.html" file after restarting the web server.
Some OTF fonts are cut off at the top in 4D Write Pro.
Impossible to change a listbox column font to the %Password.
Auto update fails because timeout is too short.
Incorrect Multipart/Form-data causes web server run in an infinite loop.
Impossible to select several listbox headers at a time, whereas is is possible for columns (multiple selection).
Potential crash with system dialogs (for instance 'PRINT SETTINGS') used through a TeamViewer session.
4D command 'Mod' can return a wrong number if the value passed to the command is close to the maximum limit of the digits available.
The 4D command "ST Get plain text" can crash if running in a process without opening a form.
'LISTBOX SELECT BREAK' not correctly executed if run in the same method that creates and populates a hierarchical listbox.
In the form editor, CTRL + 'Mouse click' does not remove form markers.
Creating a view with 'SQL Execute' can lead to a crash.
DOM Count XML element is not case-sensitive.
'LISTBOX SELECT ROW' could not work when executed within a method launched from the object method of the hierarchical listbox.
Japanese text shifts vertically in multi-styled listbox cell.
Cannot remove composite index containing a primary key or a field of unique type anymore.
This code, OPEN SETTINGS WINDOW("/Database";True;User settings), with "Enable User Setting in External File" unchecked lead 4D to quit unexpectedly.
Bad date format while entering a value when query operator is "Starts from" or "Is after".
Quick Left to Right click causes 'On Double Click' event.
Due to a syntax error while compiling, Japanese variables are wrongly displayed.
The command "Dec" can return a wrong value.
Unverified Japanese text in IME gets verified when switching application. This is fixed on Mac platform but not on Windows platform as it is the wanted behaviour.
The access to Hunspell dictionary thanks to the line "SET DATABASE PARAMETER(Spellchecker;1)" could lead to a crash if the path of the application (and so for the Hunspell) contains a diacritical characters.
After clicking CANCEL button in the 4D Server shutdown window, client connections (current and new) are rejected.
Possible freeze using a Hierarchical drop down placed in an input form of a subform.
Instability when loading with 4D Write Pro commands a 4D Write document (.4W7) that contains expression.
Same array used in several columns prevents to sort a listbox correctly.
In very heavy condition (loads of records created by several processes), during the ‘New Log File’ execution, some actions could not be integrated correctly in the new log file.
The too strong mouse click sensitivity prevents to move properly objects in form editor.
4D may unexpectedly quit when switching several times between the same window opened twice in 2 different processes. In compiled mode only.
The 4D command 'IMPORT TEXT' is very slow.
Printing can not be correct when "Print Variable Frame" is selected on a field, because of a wrong calculation of object position by 4D.
Type ahead in combo boxes is broken.
Headers/titles in Quick report get overlapped when using cross tables.
Auto Updater Error Log shows inaccurate error message: there is an unexpected 'Invalid Parameter' error (For instance: [xbox] ERROR - [661] Invalid Parameter)
Picture field with 'Stored outside data file' property can not be load or created within a transaction.
If a first record has moved after sorting a listbox selection, modifying the new first record modifies the previous first record.
Impossible to set the cursor at the end of a field with the mouse when the text ends with a space char. Also, Space characters just entered are displayed wrongly.
'Get last query plan' and 'Get last query path' always return the info of the first query run after activating with 'DESCRIBE QUERY EXECUTION (true)'
Text color becomes white for selected items in a non focused listbox.
If applying a format for a report, it is done on the header instead on the value if the destination is an HTML file.
The menu “Help:4D SVG” doesn't work when a window called by MODIFY SELECTION is in the front.
Forms of a type 'List form for printing' created with the Form wizard are corrupted (warnings about non unique object from the MSC).
ACI0095359 It is not possible anymore to catch a right-click on a radio button, whereas it works with a checkbox button or a simple button.
Text areas are too small in Structure inspector for Japanese system localization.
Quick report: Wrong Date display format in a sub-total area of a report.
Quick report leaves a ghost window after using the Open dialog.
Wrong error message if creating a new form with an already existing name.
Web service assistant create deprecated code : '_o_C_STRING' appears instead of 'C_TEXT'
Moving a form between two opened structure can generate incorrect script associations for several objects.
Quick report leaves phantom window after using save dialog (TXT or HTML file export)
In some case the print preview is not displayed on Windows 10 (1607)
The 4D Pack command 'AP FULL SCREEN' can not work properly in 'engined' mode (built application).
When scrolling up and down a 4D view area using a trackpad on OS X, the area barely follows scroll swipes.
4D View 'Advanced Properties' not visible in Properties Palette. The fix is in 4D and 4D View.
Cursor disappears while writing in 4D Write.
The 4D Write command 'WR PRINT' no longer able to overwrite a document (for instance 'PDF') since v15.
Bad display/redraw of 4D Write are with Retina screen.
The "Save" menu command displays the standard Save File dialog even if the document already exists on disk.
The 4D Write command "WR Get on error method" can randomly damaged the memory and lead the application to quit unexpectedly.
Because of a web area in a form page, it can prevent to enter text in a 4D Write area in another page.

New in 4D 15 R5 Build 15R5.203500 (Sep 14, 2016)

More power & users for your application. Preemptive 4D language is HERE:
From v15 R5 onwards, the 4D language can be run using preemptive processes in 64-bit versions. Your 4D compiled applications are now able to take full advantage of multi-core computers in order to run faster and support more connected users. To do so, there is a new "Execution mode” property in the method properties
Develop better and faster. Asynchronous messages between processes:
4D v15 R5 introduces a new, simple and powerful concept to exchange information between processes as well as between processes and forms. This feature is based upon an asynchronous messaging system that allows processes and forms to be called and asked to execute methods with parameters in their own context.
64-bit product line:
Import/ Export data dialog:
For a better end-user experience, the import and export dialogs have been ergonomically improved. We now fully support the virtual structure and the object type. A Document Type Definition (DTD) has been written for the .4si file.
Improved ergonomics of Quick Report:
In the v15 R5 64-bit version, we designed the new UI to minimize the number of clicks. This new dialog proposes to
Add fields simply by double-clicking field by field
Add fields by selecting several at once - they will be inserted in the order of selection, so even a long list of fields will have the right order directly
Search by "contains" in the list of fields in order to filter the list which is useful for tables with many fields
Sort the list of fields by name or by field number
4D Write Pro is moving forward:
More pagination and printing possibilities:
You now have access to a new page view mode; Page mode. It allows you to view the document in multiple pages and to see it as it will be printed (page size, orientation, page margins). Two new commands are available for printing a document; WP PRINT and WP PAGE SETUP. A new selector has also been created for SET PRINT OPTION (so you will be able to define which page or page range you want to print). Printing in 64-bit is available in R5, while printing in 32-bit will be available in v16 Beta.
Take a break, your 4D connection is still active. Application sleep:
If a client machine goes into sleep mode, the client application will automatically inform the server “I’m sleeping” and its connection will be closed – but the session is kept open on the server. When the machine wakes us, the session will resume and the client can continue to work as if it had remained connected the whole time
4D and the Enterprise - more integration tools:
Single Sign-On user authentication:
Following the LDAP protocol native integration in 4D, for our customers running client-server applications on Windows, it is now possible to enhance the end-user experience by using the Single Sign-On feature (based on Microsoft Active Directory), which allows your end users who are logged into the system to also use their 4D application without being asked to re-enter any login/password.
User Interface – List box features keep improving:
OBJECT SET FORMAT for headers:
You can now add an icon, placed on the left or right side of the column, in the list box header by programming.
And even more:
Delete folder and folder contents:
By popular demand, the DELETE FOLDER command has been enhanced with an optional parameter to permit you to delete both the selected folder and its contents at the same time. Et voilà!
Faster execution of SQL outer joins:
The SQL engine has been drastically improved to run queries with Outer joins up to 200 times faster than they were in 4D v15 R4.

New in 4D 15 R4 Build 15R4.200345 (May 30, 2016)

4D Write Pro:
Integrated user interface is here.
Plus the ability to handle hundreds of properties by programming:
We have designed a ready-to-use interface in 4D v15 R4 that you can include in your application. Just drag and drop it and it’s ready to go.
Thanks to these new commands, you can now design your own 4D Write Pro interface tailored to meet your customer’s specific needs.
A whole new world in 4D Tags:
PROCESS 4D TAGS has been improved again to drastically simplify the use of templates.
4D tags are now designed to leverage existing code assets. You can now include blocks of 4D code directly within a template using the new 4DCode tag. Even better, you can also debug it using the 4D Debugger. Nice
The new dollar syntax increases compatibility with several document formats; for example, the writing of XML-compliant templates
More control over list boxes:
4D gives you better control over your application user interface
A new property is available to hide extra blank rows
You can now control every single row to make it “Selectable/Not Selectable;” “Visible/Not Visible” or “Enabled/Disabled.”
There is a new option to display extra long content either with an ellipsis in the middle or by truncating the end. This provides more flexibility when displaying large content on small screens
Suspend and resume transactions:
You can now suspend a transaction, perform certain operations that do not need to be executed under the control of this transaction (i.e., create or modify records so as to increment an invoice number counter), then resume the transaction. The two new SUSPEND TRANSACTION and RESUME TRANSACTION commands will substantially simplify the coding while retaining the same user experience.
Fully customizable graphs:
The GRAPH command has been totally reworked to simplify programming and allow complete customization of graphs. More than 30 properties (such as font size, colors, margins, gap between bars, opacity, etc.) can now be modified to give you the full control. Coding has been simplified since the GRAPH SETTINGS command is no longer needed and all settings can be done with the GRAPH command on its own using an object.
New architecture for read-only application deployment:
As part of a wider project to create double-clickable applications that are compliant with modern OS rules (stored in read-only locations), we are reorganizing the application file structure. The data file path and server connection information are now stored in a “writable” location," i.e., user preferences, if you enable the new architecture mode.
Database journaling:
Simplify log integration:
When the integration fails in standard mode, you can try integration in auto-repair mode. In this case, 4D tries to resolve the error encountered, doesn’t stop the integration, and returns the error list.
Journal export using LOG FILE TO JSON:
You can now extract the log file contents into a JSON file, allowing you to keep track of the activity on a particular table; see the changes made by a user; follow a record's history, and so on.
SQL outer joins support:
4D v15 R4 includes the first step for the support of outer join queries. This implementation allows running queries that combine several joins and tables in the same SELECT statement, provided they respect specific conditions as detailed in the documentation. More types of queries will be supported in the coming R-releases.
Updates and performance improvements:
New parameter for DISTINCT VALUE:
It is now possible to get the number of occurrences detected in the current selection for each non-repeated value in a field. This is particularly useful for obtaining statistics on records, and with the new parameter, it’s just one line of code.
4D Mobile session management:
The WEB Session command has been adapted to handle 4D Mobile sessions, allowing you to keep the cart of your customers in your online store.
The WEB Get session process count command has been created to allow you to find out the number of existing processes related to a given session; in addition, three other Web commands have been updated.
Better performance for your application:
The EXECUTE FORMULA execution in compiled mode has been optimized with the introduction of a new dedicated cache in memory
The algorithm for global database re-indexing has been dramatically accelerated and can be up to two times faster
Other improvements:
The new “Error formula” system variable is available to get the offending 4D code that generates an error
The METHOD GET CODE command has been enhanced to allow you to get the very same result for the names of the commands, tables, or fields, regardless of the 4D language of the localized product used - Download demo database

New in 4D 15.2 Build 15.198931 (Apr 21, 2016)

New in 4D 15 R3 Build 15R3.196777 (Feb 25, 2016)

New in 4D 15.1 Build 15.192845 (Nov 20, 2015)

New in 4D 15 Build 15.187516 (Jul 27, 2015)

4D v15's fully tested and validated new features cover 4D Write Pro, 4D View Pro, enterprise advantages, modern UI improvements, additional possibilities for developers, analysis & optimization enhancements, Web and mobile features, SQL updates, deployment features, 64-bit support and overall increased security.
4D Write Pro:
Document compatibility: Import existing 4D Write documents with a limited feature set
HTML email: Create a 4D Write Pro document including expressions, text, and images, then modify the document, paragraph or text properties and send by email.
Existing Object and Styled Text commands are also supported to manipulate the new 4D Write Pro form object.
New commands (over fifty) are also available to create, import and export a 4D Write Pro document.
The SMTP_QuickSend command has been improved so that 4D Write Pro areas can be sent as HTML emails.
4D View Pro:
Easily create flexible and powerful UIs, dialogs and widgets.
This is a powerful enhancement for the listbox object, providing you with the means to define very flexible UIs. An array of objects can now be associated with the column of a list box so that each cell can have different types of widgets according to the type of data to be displayed.
This feature is restricted to users who have purchased a 4D View license, as this is the first step toward 4D View Pro. Similar to 4D Write Pro, it is no longer a plug-in but integrated in 4D itself, and it will add new functionality as well as enhance existing parts such as listbox.
ENTERPRISE ADVANTAGES:
LDAP support:
4D v15 now supports LDAP integration, allowing you to integrate your 4D solutions with company information systems like Microsoft Active Directory. It is now possible to automatically grant access to an application using existing user credentials as defined in the company directory. This provides the end-user with the advantage of only having one password to remember for their workstation and 4D app. 4D can also query the company directory to retrieve user information such as name, email address, phone number, department, etc.
New network layer (Preview):
The network stack has been completely rewritten in 4D v15, used to communicate between 4D Server and remote clients, as well as in commands such as HTTP client. This redesign is an investment in the future, making optimizations and further evolution possible, with a final implementation planned in coming minor and R-release versions. For compatibility reasons and for expanded testing, 4D v15 is shipping with both the old and the new network stack for the time being, making it possible to switch between them based on user interface or programming language.
4D Internet Commands mail content-type SMTP attachment:
The command now allows you to specify the content type of each attachment, for example "application/msword", allowing the recipient of an email to open attachments in a specific application.
MODERN UI IMPROVEMENTS:
New property to define radius for rectangles with rounded corners:
Rectangles now support customizable rounded corners. You can define them in the Form editor properties, as well as by programming language (getter/setter).
Toolbar form window type:
This new window type gives you the ability to design more flexible toolbars compared to the old application toolbar.
New "On scroll" form event:
You now have more control over managing scrollingl in user interfaces with pictures or list boxes. The 4D developer can be notified with the new “On Scroll” event whenever the user scrolls a scrollable object, in particular when the user uses the mouse wheel or clicks on the scroll bar.
SVG filters with Direct2D on Windows:
The SVG_Filter_Blend, SVG_Filter_Blur and SVG_Filter_Offset commands are now supported on Windows with Direct2D enabled in graphic software context.
Get the display coordinates of a listbox object:
The OBJECT GET COORDINATES command can now return the coordinates of the listbox reference frame for any listbox sub-object, i.e. columns, headers or footers, in addition to the listbox object itself.
The new command LISTBOX GET CELL COORDINATES does the same for any listbox cell. For example, it gives you the ability to draw a rectangle to display the current selection from a column when clicking on the header, with correct handling of scrolling.
Click count:
In the context of a mouseclick event, this function returns the number of times the user has clicked the same mouse button in quick succession (for example, 2 for a double-click).
Handle transparency when converting PICT files:
4D v15 now supports image transparency for now-deprecated PICT files.
EVEN MORE POSSIBILITIES FOR DEVELOPERS:
New field type: Object:
After introducing the object variable in 4D v14, a new object field type is supported by the 4D database engine starting with v15.0. It is now possible for you to store objects in the data file, add/modify/remove object attributes dynamically, and also you can perform fast queries on it. Those queries will be performed using a new QUERY BY ATTRIBUTE command that works in the same way as the QUERY command (and it can be mixed with this command in case of multiple queries).
The 4D tag revolution:
Use “smart templating” techniques to output your data in most any text format imaginable. JSON, XML and HTML are just the beginning. You have the power and control to build the output using a number of control loops or newly-added arbitrary parameters. You can even embed and evaluate 4D code inside your template. Developed over ten years ago to evaluate HTML templates, the PROCESS 4D TAGS command has evolved drastically. The newest major improvements allow the command to be used for any kind of template processing, but even further, to execute complex, structured code. PROCESS 4D TAGS creates a dedicated interpreter context, containing its own set of local variables, in both interpreted and compiled mode. It allows expression execution (such as variable assignment or command execution), and even parameters can be passed to the code.
Dynamic listbox column creation and long names for form objects:
You may now dynamically add columns to a listbox.
You are also now able to define object names up to 255 bytes for all form objects available in the form editor.
You no longer need to be concerned about object name length when applying your naming rules/convention (e.g. using a name like xxxx_Button). You can use generic code like OBJECT SET VISIBLE(*;"@_Button";False) to hide several buttons at once.
Find in sorted array:
The new command Find in sorted array drastically improves performance, especially in very large arrays, when the array is sorted. The command returns information that allows you to know:
the number of occurrences, when the element has been found
the position where the element should be inserted when the element has not been found.
Without any additional work or execution time, you can do everything by calling a single command, effectively killing two birds with one stone.
4D View: Get cell border definition programmatically:
Improved generic programming as well as a procedural reading of 4D View allow you to automatically create other documents, such as Excel XML files.
Display unsupported picture format:
This new feature provides you a quick and easy way to detect unsupported picture format and update it
4D will now display an ‘unsupported format’ picture indicating the file extension in question when any obsolete file format is detected
New option to choose the application that opens a URL:
Select the best application to open a specific file by default. The OPEN URL command accepts a new appName parameter, allowing you to designate the application to be used to open the document or URL.
Import/export a database structure programmatically:
Similar to the functionality in Design mode, two new commands, IMPORT STRUCTURE and EXPORT STRUCTURE, allow you to import/export a structure via code. This feature is important for automatic testing and introspection.
High resolution 4D process scheduler:
The DELAY PROCESS command now accepts smaller units, making it possible to specify a duration of less than a tick, like 1/180th of a second.
Open a database programmatically:
Make it simple to perform automatic testing of your solution using multiple test databases. You may also automatically reopen a database after a compilation operation. The new OPEN DATABASE command closes the current 4D database and opens on-the-fly the database defined by filePath.
Subtable migration:
4D developers can now benefit from smooth migration from subtables to normal tables. The relation field was previously read-only, and now it can be set to allow full access to a subtable using standard field/table commands. This way, all references to a subtable can be slowly rewritten, temporarily using mixed access, avoiding having to do a complete rewrite in a single step.
Form Get Object:
The FORM GET OBJECT command has enhanced functionality in 4D v15.
Language independence:
4D's method editor uses the international "English-US" language by default, regardless of the 4D version or local system settings. This new default setting provides 4D developers with two main advantages:
Facilitation of code sharing between developers, regardless of their country, regional settings, or version of 4D being used
Add 4D methods in source control tools, which often require exports to be independent from regional settings and languages.
4D code stored in Unicode:
4D code, as entered in method editor, will be stored as Unicode, allowing all characters (such as Japanese) to be directly used in code or for variable names. It is now easy and safe to exchange code without any problem with accents or specific language characters such as in Japanese, etc.
4D Plug-in SDK:
4D plug-in developers now have easier resource management of 4D dialogs.
ANALYSIS AND OPTIMIZATION:
Get database measures:
The Get database measures command returns new information regarding index usage, queries and sorts. Furthermore, you have the means to analyze and optimize the internal configuration of your database
For example, for an index, a high number of "insertKeyCount" items and a low number of "queryCount" and "sortCount" items may indicate that and index is unnecessary
Go deeper into your 4D Server performance analysis, and enlarge the number of simultaneous connected users without investing in new hardware, by deeper performance analysis of 4D Server
Enhancements now available are Query plan info and User/computer initiating the operation
Get locked records info:
A key new Command that will permit a 4D developer to optimize and streamline mature 4D client/server solutions.
Called for a table, the GET LOCKED RECORDS INFO command returns a list of all locked records, for every user, for every process, including table record number and process information.
Show form value by object name in debugger:
The increased use of dynamic variables in 4D forms (variables without a variable name, i.e. “$form.9.1”) can make debugging painful. The enhanced debugger displays object names, as well as an improved listing for subform objects, so that it is easy to identify
Show locked record count in debugger:
In both 4D Server and in 4D, in the "Watch" pane of 4D Debugger and Runtime Explorer, under each table watch icon, the count of total locked records for that table will be displayed.
Runtime Explorer improvements:
The user interface has been reworked to be more consistent with the process lists from the 4D Server administration window.
WEB- AND MOBILE-READY:
Is web server running?:
A question you may have asked often: you can now send a command to check, indeed, Is web server running?
New preference in WEB SET/GET OPTION:
Do you want to create a Web application with session handling and keep the session alive even when switching from wi-fi to 4G? With this new option, it's now possible to disable the IP address verification in session cookies for some applications that would need to switch from 3G to wi-fi or 4G, without requiring the user to log in to the application again.
Activate HTTP cache by default:
The 4D Web server cache will be set by default for any new database created.
4D Mobile: Return selection from a 4D method:
Keep your business logic within 4D and save time. A new MOBILE return selection command allows a 4D method to return a selection to Wakanda. Avoid any unnecessary work on the Wakanda application development side
4D Mobile: Get/Set 4D Mobile method properties:
It is now possible to get and set 4D Mobile-related method properties when exporting and re-importing methods using METHOD GET/SET CODE.
Two new commands, METHOD GET/SET ATTRIBUTES, have also been created. They are now returning the current value of all attributes of the method specified as a C_OBJECT.
SQL POWER:
SQL performance improvements:
The SQL GROUP BY/ORDER BY commands now make it about ten times faster to run a Select statement using Group by for single tables, but also for more complex cases, like joined tables. Running a distinct Select on a non-calculated field is about 80% faster than before.
Set/Get SQL server port programmatically:
Get peace of mind for automatic custom deployment: Use the new GET/SET DATABASE PARAMETER option to set or get the port used by the SQL server.
Disable/Enable triggers with ALTER DATABASE DISABLE/ENABLE CONSTRAINTS:
To ease the development of bulk imports and similar operations, this command allows you to enable/disable all triggers throughout the application or for a particular table. In combination with PAUSE INDEX, it drastically increases performance for such operations.
ODBC driver support for MS SQL:
4D v15 offers enhanced ODBC driver support for MS SQL Server, especially for the DTS import/export wizard.
EVEN BETTER DEPLOYMENT:
Default Data:
After a product upgrade or at first launch, 4D usually opens the “Select data file” dialog. This dialog, as the very first interaction with your application, might be confusing for the end-user.
4D v15 introduces a new feature named Default Data that is strictly designed for deploying an application. It allows you to set up a default data folder, with data file, index file (and if needed, additional files) to be automatically merged with an application build.
At startup, the 4D application will first check if the last used data file is available. If not, it checks if the build contains a default data folder. If yes, this default data is used, and then it allows you to decide what you want to do and take control. For example, you may want to present to the user with your own dialog to select or create a data file.
INCREASED SECURITY:
Open SSL update:
4D v15 verifies that it is using the latest version of Open SSL in order to be compliant with the lastest security references.
Weak cipher list removal:
Security for client-server communication has been improved: Weak cipher list suites have been removed and certificate key length has been increased.
NOTE: It is now possible to use your own encryption key for your secured client-server communications.
Web area preference to prevent URL drop:
4D Web areas now have improved security settings that prevent direct URL dropping by default. For security reasons, changing a Web area's contents by dropping a file or a URL in the area is disallowed by default. The mouse cursor now shows a forbidden icon when the user tries to drop a file or a URL in the area.

4D Changelog

What's new in 4D 20.R3

New in 4D 20.R2 (Oct 13, 2023)

New in 4D 19 (Jul 13, 2021)

New in 4D 18.6 (Apr 20, 2021)

New in 4D 18.5 (Jan 19, 2021)

New in 4D 17.0 (Oct 24, 2018)

New in 4D 16.4 Build 16.226.553 (Sep 13, 2018)

New in 4D 16 R6 Build 16R6.221608 (Mar 15, 2018)

New in 4D 16 R5 Build 16R5.219256 (Jan 16, 2018)

New in 4D 16.3 Build 16.217894 (Dec 7, 2017)

New in 4D 16.2 Build 16.214903 (Sep 6, 2017)

New in 4D 16 R2 Build 16R2.209603 (Mar 30, 2017)

New in 4D 16 Build 16.207104 (Jan 11, 2017)

New in 4D 15.3 Build 15.205412 (Nov 23, 2016)

New in 4D 15 R5 Build 15R5.203500 (Sep 14, 2016)

New in 4D 15 R4 Build 15R4.200345 (May 30, 2016)

New in 4D 15.2 Build 15.198931 (Apr 21, 2016)

New in 4D 15 R3 Build 15R3.196777 (Feb 25, 2016)

New in 4D 15.1 Build 15.192845 (Nov 20, 2015)

New in 4D 15 Build 15.187516 (Jul 27, 2015)

New in 4D 14.1 Build 14.157407 (Jun 13, 2014)