Bugs Fixed in DataFlex 19.1

Runtime

ComboForm Does Not Change Height

Bug 7435, reported by Ian Smith
There appears to be an issue with the height of ComboForms. The combo seems to be drawn at 12.5 units high and is ignoring the Set of the size property.

To reproduce:
Use the attached view. The ComboForm there is set to the same height as the forms but it displays using the original height.

Database Builder

Database Builder Table Alphabetical List Order is Case-Sensitive, Differing from the Studio and Database Explorer

Bug 7410, reported by Garret Mott
When selecting File | Open Table, the grid displaying the list of tables is case-sensitive while the Studio and Database Explorer both list tables ignoring case in 19.0.

For example, the tables named:
1. SystemRequests
2. SYSFILE
3. settings

Will be listed in Database Builder as:
- SYSFILE
- SystemRequests
- settings

Instead of being in alphabetical order:
- settings
- SYSFILE
- SystemRequests

Database Explorer

Store and Reload Last Used Filters Cause an XML Error When Using Open-As Tables

Bug 7476, reported by Quality Assurance
When you turn on the MRU option "Store and Reload last filters" and make use of open-as tables, you get an XML error.

To reproduce:
1. Select the MRU configuration option "Store and Reload Last used filters"
2. Open a DataFlex table via open-as
3. Add a filter (any will do)
4. Open another open-as table -- the error was generated

This was caused by the path to the open-as table.

Deleting the Last Remaining Filter Gives a Selected Col Has No Selected Row Error

Bug 7453, reported by Quality Assurance
When deleting the filters for an opened table, you get a "selected col has no selected row" error after deleting the last filter that remained in the list.

Focus Always Goes to Row 1 After Adding or Deleting Filters

Bug 7426, reported by Anders Ohrt
When pressing Ctrl+A and you already have filters, a new row is added but the focus moves to row 1, not the added row. Same with Ctrl+D. If you have three filters and delete the second one, the focus moves to row 1, not the row below the deleted one.

Shift+F2 in Readonly Grid Works

Bug 7411, reported by Edgar Harvey Pe¤a Calderon
When the data grid is readonly, delete etc. are disabled via toolbar buttons and floating menu but still active for Shift+F2.

Filter Value Gets Overwritten

Bug 7376, reported by Dave Robinson
When you change the value of the 3rd filter, it overwrites the value of the 1st filter.

Open As Fails with a RAW File Command Error

Bug 7368, reported by Edgar Harvey Pe¤a Calderon
When using OPEN as without a path, you get a rawfile IO error.

Packages

dbSuggestionForm Generates Error on DB2

Bug 7474, reported by Raveen Ryan Sundram
When using dbSuggestionForm with DB2 tables, DB2 errors are generated when the table is not in the default schema.

Forum Discussion

Reproducible in Order Entry DemoSuggestionForm.vw.
Caused by SQLStrLike function in DataDict.pkg generating non-working SQL filter.

Coding Error in cConnection / WriteConnectionsIni - Use of Break Command

Bug 7466, reported by Frank Cheng
Code in WriteConnectionsIni method:

If (Ids[i].bDisabled) Begin
    Get WriteConnectionsIniString hoIniFile sSection C_ConnectionIniSectionDisabled "yes" to iErrorNumber
    If iErrorNumber ;
        Break
End
Else Begin
    Send DeleteKey of hoIniFile sSection C_ConnectionIniSectionDisabled
End

Should be:

If (Ids[i].bDisabled) Begin
    Get WriteConnectionsIniString hoIniFile sSection C_ConnectionIniSectionDisabled "yes" to iErrorNumber
End
Else Begin
    Send DeleteKey of hoIniFile sSection C_ConnectionIniSectionDisabled
End
If iErrorNumber ;
    Break

cCJGridColumn Has the Focus, Clicking on a Codejock PushButton Does Not Work the First Time

Bug 7421, reported by Anders Ohrt
When a cCJGridColumn has the focus, clicking on a Codejock PushButton does not work the first time. You need to press it twice to get the OnClick to fire.

Steps to reproduce in attached view:
1. Click on the grid. The column takes the focus.
2. Click on the DFButton. The OnClick fires.
3. Click on the grid again. The column takes the focus.
4. Click on the CJButton. The button does not react, but the grid exits "edit mode".
5. Click on the CJButton again. Now OnComClick fires.

Help

What's New: Broken Link at the End of 'Summary of Workspace Changes' Page

Bug 4676, reported by Flavio da Costa Figueiredo
What's New | Visual DataFlex 12.0 | Summary of Workspace Changes
At the end of the page, the "meta-tags" link doesn't work.

WhatsNew: Broken Links in 'File Drag and Drop' Paragraph

Bug 4574, reported by Jan Ole Andreasen
What's New
Visual DataFlex 12.0
Language Changes
File Drag and Drop

The links for OnFileDropped and pbAcceptDropFile result in the page "This program cannot display the webpage" being displayed.

Studio Wizards

The Word 'Occurred' is Misspelled in Error Messages Displayed by Studio Wizards

Bug 7438, reported by Quality Assurance
Various wizards in the Studio have the same error message with a misspelled word: "The wizard was unable to save. Errors occured while writing the code."
The word "occuRed" should have been "occuRRed".

Relative Directories in Path Could Incorrectly Be Identified as Bad Folders

Bug 7436, reported by Quality Assurance
Migration has a routine to check for bad folders in any path in Config.ws. If a path (e.g., AppSrcPath) had multiple folders in it and they were using relative pathing, the routine could erroneously indicate that the path contained invalid folders.

WinPrint Report Wizard and WinPrint Top Down Report Wizard Generate Code That Triggers Compiler Warnings

Bug 7433, reported by Quality Assurance

If (sStart="" AND sStop="") function_return ""
If (sStart="0" AND sStop="0") function_return ""

Generate a compiler warning in DataFlex 19.1 Studio:
- Warning 4535: C:\DataFlex 19.1 Examples\Order Entry\AppSrc\WinReportTest.rv (ln 491) Splitting an if/else/case line with a line separator (;) will make it easier to debug
- Warning 4535: C:\DataFlex 19.1 Examples\Order Entry\AppSrc\WinReportTest.rv (ln 492) Splitting an if/else/case line with a line separator (;) will make it easier to debug

Bug 7430, reported by Quality Assurance
Use cWebModalDialog instead of cWebModalDialog.pkg.
In 19.1, this results in a compiler warning.

Web Lookup Wizard Adds cWebModalDialog Package Without .pkg Extension

Bug 7425, reported by Quality Assurance
Use cWebModalDialog instead of cWebModalDialog.pkg.
In 19.1, this results in a compiler warning.

SQL Connection Wizard Error: Bad Parameter 4099

Bug 7393, reported by Quality Assurance
This error 4099 Bad parameter from the SQL connect wizard happens when the Repair option in the wizard is used after the wizard is launched from Database Builder (not the Studio).

Studio

Studio Modeler Icons for Center Vertically and Horizontally are Reversed

Bug 7464, reported by Quality Assurance
The Studio Modeler Icons for Center Vertically and Horizontally are reversed.

Connection Manager: Edit of a File DSN Does Not Show the Path to the File DSN

Bug 7461, reported by Nils G. Svedmyr
If I have set up a File DSN and I try to edit in the connection manager, the 'Select or enter ODBC Data Source' does not show the path/file name to the file DSN.

Disable WebApp Checkbox Overwrites the WebApp's Min Pool & Max Pool Configuration

Bug 7459, reported by Quality Assurance
If you use the Disable WebApp checkbox in the Studio's Project Properties dialog to disable a WebApp, then that webapp's Min Pool and Max Pool settings are both set to 0.

To test:
1. Use the WebApp Administrator to check the Min Pool and Max Pool settings.
2. Disable the WebApp from the Studio using the checkbox mentioned above.
3. Now re-check the WebApp's Min Pool and Max Pool settings in the Administrator.

Error 'Referenced Array Index Out of Bounds' When Changing Location Values with Malformed Code

Bug 7449, reported by Ian Smith
Trying to set a folded property through the property panel may raise an unhandled error when the code is improperly formatted.

For example:

Set Location 20 30Set Location 20 30 to

While we can't model this code (it's bad), the Studio should handle it.
The error below is generated when trying to set values for location through the Properties Panel and the location line of code is wrong.

C:\Program Files (x86)\DataFlex 19.0\Bin\Studio.exe
Referenced Array Index Out of Bounds
Error: 4509

Please report this error to Data Access Corporation.

To reproduce:
1. Open Order view.
2. From the designer view, double-click on Terms combo.
3. In the editor, remove the TO from the line Set Location to 64 63.
4. You should end up with: Set Location 64 63.
5. Go back to Designer view.
6. Select Terms combo.
7. Open Properties panel.
8. Go to Location property -- it should display 0;0.
9. Edit Location values in the Properties panel.
10. Press Enter - the error will be displayed.

The Word 'Occurred' is Misspelled in an Error Message Displayed by the Studio Debugger

Bug 7439, reported by Quality Assurance
The error message "An error occured evaluating this breakpoint:" included the word "occured" instead of "occurred".

Grid Columns Dragged and Dropped from DDO Explorer into Grids in the Studio Designer are Often Too Wide

Bug 7418, reported by Quality Assurance
Dragging a table.column from the DDO Explorer into a grid can result in a grid column width with longer ASCII table columns.

To reproduce:
1. Create a new data view in Order Entry sample workspace.
2. Add a cDbCJGrid to it.
3. Open DDO Explorer.
4. Add Customer to the tree.
5. Drag Purchases and Comments to the grid - Purchases will almost disappear from the grid with Comments taking most of the object.

DEOs Dragged and Dropped from DDO Explorer into Studio Designer are Often Too Wide

Bug 7417, reported by Wil van Antwerpen
If you use the DDO Explorer to add a field to your view and the field is over 40 or so characters wide, then the default width of the forms that you drag onto the dbView are always wrong.

For example, I had a 160 character wide ASCII field that I dragged onto a dbView and it became a whopping 960 dialog units wide! My view is 393 units wide and there's other controls it overlaps before the end.

The ideal width would be to stop before the other controls. Now I understand that that might not be easy; however, it should NEVER go past the right-hand edge of my dbView and quite frankly I never set a form to be wider than 200 units anyways.

This dbForm is now 166 units wide after resizing.

WebApp Framework

Adding Panels to an Accordion Card Causes Errors

Bug 7405, reported by Quality Assurance
When adding cWebPanel objects inside a cWebAccordionCard object, it causes a JavaScript error when the control is rendered (inside the designer or when running the application).

cWebTreeView: Send Expand Before the Treeview is Rendered Causes JavaScript Errors

Bug 7398, reported by Quality Assurance
The WebTreeView causes JavaScript errors when Expand is called before the control is rendered. This happens when the treeview is inside a tab container with a fixed height (or pbFillHeight) on the second page or higher.

See the attached view for reproducing the error. You can see the error in the Browser debugger's (F12) console.

cWebMenuSave Does Not Work When Used Outside a Command Bar

Bug 7395, reported by Raveen Ryan Sundram
Using the cWebMenuSave, cWebMenuFind, cWebMenuClear classes inside a menu that is not located inside a cWebCommandBar stopped working. As of DataFlex 19.0, the cWebToolbar / cWebMenuBar controls take the focus when they are not used inside a cWebCommandBar and the menu classes use the focused object to determine on which DEO they should perform their operation.

For 19.1, this is improved with a property pbFocusable which defaults to true only when the control is used inside a view. It can be manually overridden if needed.

cWebColumnCheckbox / cWebGrid: Clicks are Swallowed When the Row is Already Selected

Bug 7374, reported by Frank Cheng
When using the cWebColumnCheckbox inside a grid and first clicking on a different column in a grid row and then clicking on the checkbox column, it swallows the first click (it doesn't check/uncheck it).

To reproduce:
1. Open the WebOrder sample.
2. Open the 'Constrained Grid' sample (Demo > Grids and Lists > Constrained Grid).
3. Click on the name column of a random row (so the name column is in edit mode).
4. Now click on the status checkbox and note that it doesn't change.
5. Now click it again and see that it changes.

The click at step 4 seems to be swallowed.

-- HW 2017/12/19 --
This happens because the grid changes the column into edit mode. There is special logic in the checkbox column that 'remembers the click' but it broke in 19.0 because the refactoring of the cWebList & cWebGrid changed the order of things happening.