Fixes and New Features
dBASE PLUS 2.2 (Dec 31, 2003)

dQuery Build 1215

Fixes

• Choice of"Delphi" or "dBASE" versions has been removed.
• Semicolon has been added to the list of name-conversion characters to support SQL Server stored procedures: myprocedure;1 now generates a stored procedure called myprocedure_11.
• dQuery no longer streams report code incorrectly. In previous versions, both the dataModule and the components in the dataModule streamed. Now only the dataModule streams.
• The thumb on the scrollbar on the Design Surface of dQuery now maintains the correct position relative to the number and position of the items you have on the design surface.
• Many Import and Export Bugs have been fixed.
• Better Recovery after using the Report Designer.
• dQuery no longer allows you to open non-dmd files.
• Queries on the Design Surface are now refreshed after you "Save as" from the Table Designer.
• Access master/detail drag-and-drop improved.
• Database Aliases with numeric characters no longer cause problems.
• Datamodules can no longer be saved as incorrect file type (.wfm, etc.).
• One-Click Windows application no longer reports erroneous call to "Remove".
• Reports now respect width settings in Custom View for Memo fields.
• dQuery no longer fails after adding a new report or editing an existing one from the Reports menu.
• Adding records to an existing table now works in the dQuery Export.
• Resetting defaults in the dBASE Preferences Wizard no longer produces an error.
• My Documents has now been added to the dataModule explorer treeview.
• The ESCAPE key is now turned off during dQuery operation.

New Features

• Star Filter
• Borland Delphi Import and Export (File Menu)
• Borland C++ Import and Export (File Menu)

Core Product Builds 1713 — 1746

Fixes

• QAID 4627 In The Wizard Prompt for new datamodule, cancel now exits instead of going on to dQuery.
• QAID 4489 Fixed GPF that occurred when on Format Menu, toggling "Wrap" option back and forth repeatedly for a columnEditor no longer causes a GPF when grid row height has been increased to display 3 lines of text in columnEditor cell. Can take from 1 to 3 toggles before GPF occurs.
• QAID 4342 Refixed columnEditor so that grid level font changes propagate into columnEditor both in Form Designer and at runtime.
• QAID 4497 Fixed bug where expanded columnEditor is not always on top of adjacent subform such as in dQuery.
• QAID 4496 Expanded columnEditor does not close when clicking mouse on a subform such as used for dQuery's design surface.
• QAID 4339 Embedded color tags in columnEditor are only used to format text when columnEditor cell has focus. When not in focus, embedded color tags are ignored.
• QAID 4463 Fixed bug where "Free memory" was displaying as a negative value in Help | About dBASE Plus dialog. This fix will ensure that Free Memory will display correctly for values up to 4 Gigabytes. Prior to this fix, Free memory would display as a negative value for values above 2 Gigabytes.
• QAID 1496 Fixed bug where if a non-mdi form loses focus and then regains focus, its current control is not given focus and made active.
• Fixed bug where the first control on a form does not receive focus when a toolbar is attached to the form in the form's onOpen event.
• QAID 2427 Fixed Form Designer so that it correctly sets the pageNo property of the control created when dragging an image file, form file, or report file onto a form or a notebook on a form. Previously, dragging an image file to a pageNo greater than 1 on a form or notebook, the image control's pageNo was always set to 1.
• Fixed: When dragging a .wfm or .rpt file onto a Notebook, the pageNo of the button control, that is created, was set to the form's pageNo instead of the notebook's pageNo.
• QAID 3989 ReportViewer NextPage and PrevPage are slow and prone to crashing when used in dQuery. Made core product changes to reduce chance of crashing and to optimize nextpage and prevpage rendering speed.
• QAID 3989 ReportViewer running slowly when running report that uses rowset datalinked to data and/or view grid in dQuery. Modified dBASE streamFrame object so that it internally sets its streamSource.rowset.notifyControls to false before streamFrame's canRender event executes and then resets notifyControls to prior value after streamFrame's onRender event executes.
• QAID 1240 Fixed grid bug where vertical bars appear between columns when hasColumnLines = False and rowSelect = True and user presses up arrow or down arrow to navigate grid and grid's bgColor is set to its default value. An earlier fix for QAID 4484 fixed this problem when bgColor is not set to its default value.
• QAID 4537 When opening a password protected Paradox table, modified runtime code so that if running a dBASE -web- app, the Paradox password dialog will not be displayed. Previously, if an invalid password was passed to the AddPassword() method before opening the table, the runtime would attempt to open the Paradox Password dialog to allow the user to enter the password. When running on a web server, the dialog could not display and would result in the web app waiting in a modal dialog that no one could respond to. With the above change, if no password or an invalid password is used when opening a password protected paradox table, a BDEError will be generated of type: DBIERR_NOTSUFFTABLERIGHTS.
• QAID 1939 Fixed a problem that occurred when specific fields were selected using the SQL property of a Query component, which resulted in a filter condition in the CanGetRow event producing incorrect results. This problem has existed since VDB 7.01 or before.
• QAID 1939 Fixed severe slowdown when using CanGetRow() with a SQL Select that specifies specific fields.
• QAID 4537 Prevented dBASE User Login dialog from displaying when accessing protected dBASE tables when running a dBASE Web App.
• QAID 4036 Fixed reportViewer so that horizontal scrollbar disappears and reappears appropriately as reportViewer is widened or narrowed.
• QAID 4531 When the Insert key state is in Overwrite Mode and an empty character field gets focus, an unprintable character is inserted at the left end of the field. Note, this applies to character fields without a picture property defined. This no longer occurs.
• QAID 4540 Fix problem where a left mouse down on a container object does not trigger grid columnEditor to close when on the same form.
• QAID 4528 Fixed GPF that occurred when closing the debugger after encountering an error and pressing the "Debug" button in the error dialog.
• QAID 4542 Fixed firing of form.onGotFocus() regression caused by fix to QAID 1496 in b1738.
• QAID 4543 Left mouse down on database or session object in dQuery does not close open columnEditor.
• QAID 3965 If grid.hasColumnHeadings=false, the Grid no longer has a 1-2 pixel high hole is at top of grid.
• QAID 4458 Grid.columnHeading = false, tab off grid will no longer cause some columns to appear to adjust up 1-2 pixels.
• QAID 4533 In grid with form code below, pressing PgDn and then Up Arrow results in a horizontal line or gap being left in grid at bottom of row just scrolled from.
• QAID 4534 In grid with hasIndicator = false, hasColumnHeadings = true, most of the bottom border of the leftmost columnheader is no longer not displaying.
• QAID 4545 If hasIndicator is false - there is no longer a gap to left of leftmost column line.
• If gridLineWidth > 1, grid lines no longer looks strange as gridLineWidth increases.
• If columnHeadings = false, topmost grid line is no longer painted too low.
• Vertical grid lines no longer extend slightly past bottommost horizontal grid line.
• Table Designer has been fixed to respect decimal places in numeric data.
• Table Designer has been fixed to pad fields properly.
• Source Editor now jumps to the method icon in the left (object) pane when cursor position is changed in the right pane (source).
• Picture statements now work properly when there is a placeholder in the first position to the left of the entryfield.
• The Designer Object now receives notification when the Source Editor or the Report Designer closes. They use the following constants: REPORT_DESIGNER_CLOSE and SOURCE_EDITOR_CLOSE.
• Clicking on a Grid Column Header now selects that column.
• dBASE no longer streams incorrect code when saving dataModules under certain circumstances in dQuery.
• The Source Editor now respects remark-block markers (/* */) when adding items to its object pane.
• Clicking on a method in the object pane of the Source Editor now moves the cursor to the first line of the method in the source pane, even if the cursor is already somewhere within the selected method.
• Format toolbar is turned off for all Subforms
• Many improvements and fixes in data-entry in entryfield, including both insert and overwrite modes.

New Features

• New dBL Project Explorer replaces ActiveX Project Manager
• New inline editor control in grid (columnEditor)