All Products 17 R6 - Fixed bugs

Reference Summary Fixed also with
ACI0096405 Scrolling a subform stops when the mouse is above an enterable object.
ACI0098029 The SQL command LEFT OUTER JOIN does not return all records of the left table. 17.1 HF2
ACI0098328 When converting a document from 4D Write to 4D Write Pro, some words are highlighted with blue color (background color). 17.2
ACI0098412 Columns settings are not reset when creating a new QR report: it keeps columns from the previous report. 17.2 HF1
ACI0098413 Unexpected Regex error in 4D SVG Component that prevent to save picture with 'SVG_SAVE_AS_PICTURE'. 17.2 16.6
ACI0098421 When a serious error is encountered, the entity.drop() ORDA method doesn’t return all the necessary information.
ACI0098452 While editing a record in a list form just generated by Form wizard, SVG picture of this line disappears during the editing time. After editing, the SVG of the edited record overwrites any other SVG in the table. 17.2
ACI0098700 Under macOS, when closing a window, it can flickers shortly before closing.
ACI0098925 Backup settings do not save “Repeat after X seconds/minutes/hours” option: on Windows it is always 60 mn, on macOS it is always 0 mn (wich is worse because the 0 seconds will lead the backup log file to be flooded). 17.2 HF1
ACI0099168 Sometimes, it happens that a user connected to the database is not shown in the user list (4D server administration Window). 17.2 HF1
ACI0099200 Printing records via label editor could be wrong when printing landscape: only 1 record printed (and sometimes the last one). 17.2
ACI0099228 Quick report "Cross Table" doesn't show the correct "SUM" of times. 17 R5 17.2
ACI0099235 'HTTP Get' command consumes CPU and Slows Server (CPU usage more than 60%). 16.5 HF1
ACI0099314 When 'SET MENU BAR' is called before 'EDIT ACCESS', the 'EDIT ACCESS' dialog has the design mode menu bar instead of the one setting by 'SET MENU BAR'. 17.2 HF1
ACI0099331 Since v17.1 hotfix 1, the 4D command 'FORM SET INPUT' has no effect on subforms. 17.2
ACI0099334 'QUERY WITH ARRAY' or ORDA query() with collection returns wrong results if database language is Japanese and ICU is set to use string matching for search. 17.2
ACI0099358 Compared to the legacy network mode, with ServerNet mode queries slow over on high latency network. 17.1 HF2 16.5 HF1
ACI0099379 4D View Pro doesn't manage invisible cell as the plugin 4D View used to. Thus, it has been decided to remove the style "visible=False" from a converted document. 17 R5
ACI0099393 Let a picture property that states to display a picture on some pages (not all) of a 4D Write document. After a conversion to 4D Write Pro, the picture appears on all pages. 17 R5 17.1 HF2
ACI0099400 A crash could occured when switchnig 4D in background when an update need to be done in the same time on a MODIFY/DISPLAY SELECTION. Windows system only. 17.1 HF2
ACI0099404 Especially during a data convertion, deleting an index after just building it may lead 4D to a crash if some pages are still in the flush tree, and if the index type has changed between the data and the structure file. 17 R5 17.2 HF1
ACI0099407 The constant 'lk remove from selection' used in the command 'LISTBOX SELECT ROW' may lead to a crash. 17.1 HF2
ACI0099409 A freeze could occurred after the use of the command "VP Convert from 4D View" when a 4D view document was corrupted for unknown reason. 17 R5
ACI0099415 Cursor not visible if setting a field background to a light color; the cursor color depends on the luminance. 17.1 HF2
ACI0099428 With 'dot notation', parentheses seems needed to unpoint : " (Form.colonne)->{$index}:=(Form.colonne)->{$index}*10 " works, whereas " Form.colonne->{$index}:=(Form.colonne)->{$index}*10 " doesn't work. 17.1 HF2
ACI0099430 'WA Get Page Title' returns URL information instead of page title, on Windows with Internet Explorer 11. 17.1 HF2
ACI0099444 Quick Report: the resulting subtotal row tooltip remains displayed if the mouse quickly leaves the listbox.
ACI0099448 With 4D 64-bit, web area with Embedded web rendering engine does not retain credentials (example: Google Calendar authentication not kept after restart). 17.2
ACI0099449 Reduce header then body size with vertical ruler results in wrong positions. This does only happen with a converted document from old 4D Write. 17 R5
ACI0099451 Listbox constant 'lk auto row height' in 4D command 'LISTBOX SET PROPERTY' is not functional in duplicated ListBox columns. 17.2
ACI0099455 When a database is converted from v13 to v17, font name is lost for forms objects with no stylesheet. 17.2
ACI0099456 If SSO is activated (Single Sign-On), the display of the users in the administration window may not be complete. 17.2 HF1
ACI0099458 On scroll event (picture) is slow if using the scroll bar or mouse wheel. No problem when using arrow keys. 17.2
ACI0099461 A bad result is returned with a query on an indexed object field attribute name, when this one is null (ORDA mode) or undefined (Classic mode). 17.2 HF1
ACI0099464 After a conversion from 4D Write to 4D Write Pro, referenced pictures may lose their scaling.
ACI0099476 4D Write Pro justification problem: a text with direction from right to left (such as Arabic text) is not aligned to the right anymore. It is aligned to the left. 17 R5 17.2
ACI0099482 Right aligned value in listbox may have invisible caret depending on the value length. 17.2
ACI0099485 entity.touched() return true for object field in Client/ServerMode even if this one is affected to an object (variable or field) not belonging to the dataclass. 17 R5 17.1 HF2
ACI0099493 "4D Design/Explorer" menu keeps check mark and doesn't update it anymore.
ACI0099501 'APPEND MENU ITEM' causes a crash when appending to non existent menu bar. 17 R5
ACI0099505 The check box "TabStrip" in 4D View Pro works inversely with a document converted from 4D View. 17 R5
ACI0099507 In a client-server environment with 2 clients connected, one client performs a syntax check, the other client execute SET DATABASE PARAMETER(REMOTE MODE TIMEOUT;1) while the syntax check is running. The client running the syntax check freezes. 17.2
ACI0099523 SVG Component does not replace CRLF with tbreak elements. 17.3 HF1
ACI0099524 In the Administration window, part 'Processes', when selecting the line of a 'preemptive worker', it shows a non-localized text : ":xliff:MONI_PROCESS_Type39 - (process name)". 17 R5 17.2 16.6
ACI0099525 4D commands 'File' and 'Folder' do not allow type-ahead when typing command name as parameters. It works only with constant.
ACI0099526 A crash could occur when modifying shared objects/collections simultaneously from multiple threads; compiled mode only. 17.2 HF1
ACI0099527 When exporting a 4D Write Pro document to word, unexepected blue lines appear in the word document. 17 R5
ACI0099536 In 64-bit mode, Quick Report ignore column separator other then 'tab'. A change in settings is not applied. 17 R5 17.2
ACI0099544 When applying a format to a field of type 'real' in the label editor, only the first record is printed. 17 R5 17.2 HF1
ACI0099551 4D application may go to an error unexpectedly if you quit the application immediately after displaying 4D Welcome wizard. 17 R5
ACI0099554 Reducing selection to 0 using 'REDUCE SELECTION' does not unload the current record in the application process when running 4D client-server. 17.2 HF1
ACI0099556 collection.sort() method doesn’t work well on Client/Server for attributes of type date when using transactions. 17.2
ACI0099557 When the web server of 4D sends a web page with a <link> tag towards a css file inside, 4D crashes if the web page is asked several times. On Windows system only. 17 R5
ACI0099567 For a 'thermometer' object form, the property list never show the 'numeric format' in the 'Display' part (when "Labels" is checked in 'Scale' part).
ACI0099569 SQL functions "LOWER" and "UPPER" work as 4D commands "Lowercase" and "Uppercase" without the * parameter, and thus accented characters lose their accent ("éè" transformed "ee").
ACI0099578 Not possible to bind time field to JSON form because the UI does not respect expression type 'time'.
ACI0099585 During a Compact, Repair or Recover by record headers, the cache size was always (harcoded) to 800 Mb. Now, the cache size allocation is set to 70% of the physical memory (64-bit only). 17.2 HF1
ACI0099599 On Mac, a bad character appear at the end of the line when you try to tokenise in the method editor a table name that does not exist. 17.2 HF1
ACI0099600 Label editor: unchecking 'auto-resize' does not revert the label size to form size. It does not toggle; the function only works one-way.
ACI0099601 LAbel editor: when the form to print is changed while 'auto-resize' is checked, the label size is overwritten by the newly selected form size.
ACI0099603 Label editor: unit conversion is incorrect if form is used and 'auto-size' is not selected.
ACI0099609 Displaying a false value when passing a string containing an accented character 17.3
ACI0099620 The mode 'Can be run in preemptive processes' is unexpectedly deactivated if the option 'Use legacy network layer' is checked. 17 R5
ACI0099621 When a form contains multiple date pickers, assigning a date to one of them causes both date pickers have the same value instead of treating them separately. 17.2 HF1
ACI0099634 The check boxes "Vertical Gridline"and "Horizontal Gridline" in 4D View Pro work inversely with a document converted from 4D View. 17 R5
ACI0099636 The subject of a mail sent with 'SMTP New transporter' is unexpectedly separated in chunks with invisible characters between. 17 R5
ACI0099638 The subject of a mail sent with the command SMTP New transporter is unexpectedly transformed: a chunk of the subject is repeated two times. 17 R5
ACI0099639 "Inherited form name" property doesn't display the values list at the first load of a form.
ACI0099641 The conversion of a 4D View file that contains data with "###0 days" format to a 4D view Pro file generates wrong result 17 R5
ACI0099642 The default size of a 4D View converted file has been reduced (from 100Column/1000row to 20Column/100 row). This improve the conversion time to 4D View Pro, especially when the converted file is small or empty, and when it has style applied to every cell. 17 R5
ACI0099650 4D Write Pro area drawn in page 0 of a form appears above objects of page 1.
ACI0099659 Server can crash while indexing when a “recover by record header” was performed with MSC. 17 R5 17.2
ACI0099661 A shared form of a component is not visible from the subform container of a host project database. 17 R5
ACI0099674 Compiler gives error (“missing parameter”) if third parameter of 'COLLECTION TO ARRAY' is a text variable. 17.2 HF1
ACI0099675 Using the Quick report' with 4D 64-bit, when applying a format for a calculated column, the formula of this column is lost. 17 R5 17.2 HF1
ACI0099689 4D can't be launched (crash) on macOS Catalina (macOS 10.15.x). 17 R5 17.2 HF1
ACI0099692 Incorrect conversion of Helps Tips in XLIFF form
ACI0099693 4D crashes when trying to use, via a relateEntities kind attribute, a relateEntity kind attribute of an empty entity selection. 17 R5
ACI0099700 entitySelection.query() with more than one search criteria doesn't work well in C/S mode on 1->N relations when using collections. 17 R5
ACI0099714 Copying from 4D and pasting in Excel a text with words separated by tabs doesn't place words in different cells as it should. All are unexpectedly pasted in one cell. 17.2 HF1
ACI0099723 With the 4D Write Pro Toolbar widget, after entering some text the popup menu of fonts becomes blanck.
ACI0099725 Using "Suppr" key of keyboard in the JSON property list editor cancels the current property edition.
ACI0099736 entity.drop() method returns true in the status instead of false when the drop action with "dk force drop if stamp changed" fails because the referenced record doesn’t exist anymore. 17.2 HF1
ACI0099738 entity.lock() errors are not trapped by 'ON ERR CALL' in Standalone mode, and the returned object in Client/Server mode doesn't contain all the error information. 17.2 HF1
ACI0099740 entity.save() method with "dk auto merge" should not be successfully executed when at least one attribute is stored outside the record or outside the data file. In C/S mode the execution of the entity.save(dk auto merge) returns success = True
ACI0099741 In C/S mode entity.save() is successfully executed in some situations when it should fail for example: when used with "dk auto merge" if their referenced record doesn't exist anymore or it was replaced by another record or if attempts to duplicate primary
ACI0099742 In Client/Server mode, entitySelection.drop() doesn't return the number of locked entities that were not dropped. 17.2 HF1
ACI0099749 Rarely, when creating and deleting processes, it could happen that 4D Server freezes (deadlock). 17.2 HF1
ACI0099758 In Client/Server mode, dataClass.query() with order by statement makes the query but doesn't always order the resulted entity selection.
ACI0099770 The factory settings doesn't set the default values of the backup.
ACI0099773 Drag and Drop doesn't work after setting the text object property to Automatic Drag and Automatic drop, and unsetting 'Draggable' and 'Droppable' options. 17 R5 16.6 17.2 HF1
ACI0099777 Engined Server built with the option "Use new architecture for application deployments" unchecked (in Settings dialog, "Compatibility :Deployment") neve remind the path of the last data file after startup. 17 R5
ACI0099783 If you change the page border for Quick Report (x64) and confirm it by clicking "OK", the values will be reseted to the original one.
ACI0099784 Using Semaphore in many parallel processes can produce hanging system threads (wich can lead to a 4D Server crash). 17.3
ACI0099794 Unexpected filenames inside 4D applications (like 4D Volume Desktop) contains "%" character in the name, which may disturb the use of installer software (like Wise). 17 R5
ACI0099800 'MAIL Convert to MIME' crashes with a null JMAP message if the first parameter (Object for mail) is equal to Null.
ACI0099803 When deleting a form page, if then the following page displayed has a listbox, a crash could appear. That problem appears since the v17 R5 (238362), only in beta session then. 17 R5
ACI0099817 'Current user' returns an empty string instead of the current user name when executed on 4D Server. 17 R5
ACI0099839 4D Write Pro: Wrong value in footer (for instance, "page x of total page") after executing the 4D command "ST FREEZE EXPRESSIONS" 18
ACI0099840 4D returns first entity instead of a error when there is no attribute in the dataClass when doing 'entitySelection.attribute'.
ACI0099844 Using ORDA language (Object Relational Data Access) in a loop to access an entity through several levels of relations may lead to an unexpected error message. Client/Server mode only. 17 R5
ACI0099862 After a conversion from a 4D Write document to 4D Write Pro, an unexpected 'gap' between the bottom of the body and the top of the footer area occurred. 17.3 HF1
ACI0099868 In SDI mode, Menus item with some styles applied appear always empty. 17.3
ACI0099869 The 'WEB CLOSE SESSION' command no longer close the session designated by the session ID, and the database event 'On Web Close Process' is not triggered. 17 R5
ACI0099875 Execute the alert and move to the next line after highlighting the line in trace mode 17.3 HF1
ACI0099877 4D for iOS Project Editor: an unexpected 'Runtime error' ("Index in collection must be a positive finite number") may happen when creating a New project.
ACI0099879 After executing the 4D command 'ALERT' with a very large text (for instance > 80.000 characters), 4D becomes no more responsive on Windows. on MacOS, the message is empty.
ACI0099889 Write Pro: The character attributes of the last empty line in a paragraph (such as font size, font color, and bold) do not change with the rest of the paragraph 17.3
ACI0099890 When repeating in a loop the command ' VP Convert from 4D View'.each time, the memory used (Virtual and Ram) increase
ACI0099891 When ORDA optimisation is activated, some Many-To-One relations don't load correctly the related entities.
ACI0099893 When the style underlined is applied to an entire paragraph in a 4D Write Pro document, the same paragraph is not underlined when exported to HTML
ACI0099894 4D View Pro - Impossible to enter the date "01.11.2019", problem related to time zone
ACI0099895 Write Pro: converted documents show an unexpected horizontal line in the header (Mac Only)
ACI0099897 Using XLIFF syntax such as :19000,1 does not display the XLIFF string anymore
ACI0099906 Potential crash when external SQL requests are sent to 4D Server when the 4D SQL server (SQL engine) is already started but 4D Database engine ('DB4D') not yet completely started.
ACI0099907 A potential crash could occur when using the 'Order by' SQL command especially when trying to retrieve the column from the index position rather than by name.
ACI0099908 Alpha fields wrongly converted to Date ISO Format 17.3 HF1
ACI0099911 A crash could occured when attempting to load a record that has been deleted with an SQL query.
ACI0099924 4D or 4D Server doesn't test the presence of the 4D folder when needs to write in the temporary folder. 17.3 HF2
ACI0099931 4D for iOS: pictures taken by a camera are received under a wrong rotation following the execution of an action with parameters.
ACI0099939 ORDA: Bad or incomplete requests between Client and Server when using ".next()" and ".previous()".
ACI0099957 Since v17 R5, 4D crashes when trying to get the debug log file path (thanks to 4D commands 'File' or 'Get 4D file') after deactivating ( with "SET DATABASE PARAMETER(Debug log recording;0)" ).
ACI0099967 4D may freeze when coming back from sleep.
ACI0100001 The conversion of documents from 4D View to 4D View Pro return wrong numeric format ("," is replaced by ".") 18
ACI0100027 Since v17 R5, it is unexpectedly possible to attempt to rename a database method thanks to a contextual menu in the Explorer; this leads to a crash.
ACI0100033 The request optimisation mechanism with ORDA, in C/S to display the entity selection in a listbox was not always activated correctly, depending when the query was performed. This could generate a slowdown issue to display the entity selection.
ACI0100043 After the conversion from a 4D view file, the cells that contain time in the 4D view Pro file are not displayed 18
ACI0100059 Dialog Error code :652 (xbox) happens on macOS 10.15.x (Catalina) during the autoupdate if the updater version stored in 'Application Support:BuilAppfolder:4D:updater was to old. 17.3 HF1
ACI0100066 The "CEF_cache" folder is not created in the user folder ("AppData\Roaming\" for Windows system, "...:Application Support" for macOS).
ACI0099431 Commands "OCILobGetLength", "OCILobWrite" and "OCILobRead" return -2 (invalid handle) for CLOB Oracle data type when ran 64-bit applications (No problem on 32-bit). 17 R5 17.2