Fixes and New Features
dBASE PLUS 2.02 Public Gold Beta (Mar 19, 2003)

dQuery Build 1210

Fixes

• Screen "whiteout' no longer occurs on dQuery startup.
• The Animate class now finds the assigned AVI file at runtime.
• Removing a query or table that's linked to the View no longer produces an "Expecting Object" error.
• When you inherit a new dataModule and a dataModule is already displayed, dQuery II now opens a new "Untitled" inherited dataModule correctly.
• No-Click Report now right-justifies numeric headings, columns and totals correctly.
• No-Click Report now displays totals below the double line at the end of the report instead of above it.
• Removing a View column now deletes the correct column regardless of how the columns have been moved previously.
• Fixed bug in Field Mapper when exporting View so that you no longer get "subscript error". Upper() function was missing.
• Fixed Database Wizard - "add database to dataModule" displayed an empty list of BDE aliases. DataSource was missing.
• Fixed Master-Detail Wizard. It was trying to do the same link for indexed or non-indexed tables (MasterRowset instead of MasterSource).
• Format Toolbar has been turned off for all Wizards and for One-Click applications.
• Access 2000+ tables now show data correctly despite ODBC driver bug that causes problems when there is a space in the table name. Note: Space in table name is allowed in Access but Microsoft recommends against it as they don't work with Visual Basic or VBA.
• F1 Help key has now been enabled.
• Duplicate shortcuts have been removed from dQuery menus.
• Export to HTML now includes a "table" closing </table> tag.
• Import SDF, null value now is empty, instead of false.
• Import now respects non-US date formats.
• Opening "Field Properties" for a calculated field no longer produces an error.
• Parameterized queries (parent/child) no longer reject key words such as "Date" or "Select".
• Parameterized queries now allow links using fieldnames with spaces in them.
• Parameterized queries no longer choke on key words such as "Date" and "Select".
• Exporting a table with a full path with spaces no longer causes an error.
• Exporting a field with a space in it, or a field with a key word (Date, Select) no longer causes an error.
• dQuery now creates the dBASETemp folder if it is missing.
• One-Click Application Field Widths have been widened to a more appropriate size.
• dQuery now respects numeric field sizes when exporting.
• Attempts to cancel parent-child no longer cause an error message.
• Ampersands and other punctuation in file paths no longer cause an error when you add queries to a dataModule.
• dQuery now represents MS SQL Server prefixes. A table names: dbo.mydata will generate a query named: dbo_myData1 instead of dbo1.
• Moving splitters to the top of left of the screen no longer causes an error when resizing the dQuery form.
• Changing an inactive Query to active using the Inspector now refreshes the onscreen display propertly.
• The One-Click Windows application and the One-Click Wizard can now find all needed files correctly.
• Numeric database aliases no longer cause an error when added using the drag-and-drop section of the dQuery ToolPanel.
• Export Wizard now uses two new pages to select database and table instead of the built-in "PutFile" which many found confusing.
• The SQL Wizard no longer causes and error if you use the "is not empty" option.
• Reports now sum correctly even when using parent-child relations.
• Removing a column from a Custom View no longer results in losing user-defined column widths.
• Columns now maintain their user-defined order even when you click away and come back to the Custom View.
• Removing an "Associated Report" no longer results in a subsequent error.
• Using the Export Wizard to export to HTML no longer produces an error and an empty result file.
• MRU (Most Recently Used) file list no longer adds duplicates.
• Output Current Report to HTML no longer produces "Expecting Object" error.
• Inherit New Datamodule now inherits reports and Custom Views.
• Save As.... now behaves appropriately, no longer saves automatically as "Untitled1.dmd".
• BDE Aliases with spaces in them are now handled correctly in all circumstances.
• Error: Undefined Variable "Text" no longer occurs when dragging databases from the dQuery tool Panel.
• Parent database can no longer be removed if their are queries open in dQuery attached to that database.
• dQuery now remains maximized when restarted if it was maximized when closed.
• "New DataModule" button now correctly creates a .dmd instead of a .cdm.
• Parent-Child links are no longer broken when you modify a SQL statement, unless they have to be broken due to the change.
• An error no longer occurs if you delete a parent query if there are more than one child query in a parent-child relation.
• Reports now respect one-to-one and one-to-many settings used in Queries, Views and Navigation Previously, the report's own one-to-many navigation (groups) interfered with the OODML navigation (navigateMaster, navigateByMaster, detailNavigationOverride) etc. causing unexpected results, including the appearance of missing data.
• Opening Calculate Fields and Filter dialogs when a SQL query has focus no longer results in an error "Undefined qLang...."

New Features

• When inheriting from an existing dataModule, dQuery II now asks if you wish to inherit from the currently displayed dataModule.
• The Export Wizard no longer uses "getFile" to select the target database/table. There are two new pages in the Wizard to select database and table.
• dQuery now supports indexed parent/child links between -any- type of files, including SQL files as long as they have no "Where" statement in their SQL SELECT statement.
• You can now set indexes explicitly for Access, SQL Server, Oracle, InterBase, etc. tables as long as the SQL statement in the query being set does not have a "Where" statement (which causes automatic index selection in the engine).
• Apache Configuration Wizard.
• Delphi tDataModule Import and Export.
• Star Filter (not operational in this Beta version).
• Selecting "Field Properties" on the Query popup menu now brings up the Inspector.
• One-Click Windows applications have been redesigned to allow automatic scrolling through data-entry fields. There is now no limit on the number of fields allowed (until resources are exhaused).
• Export now exports Binary and BLOB field data if possible.
• Deployment of reports, dataModules and applications now drills down to find all superclass files needed to run them correctly.
• One-Click Web Applications and the Web Wizards have been simplified to support easier paths and configurations. HTML and .exes are now stored and run from the same folder.

Core Product Builds 1704 — 1712

Fixes

• The FormatToolBar(true/false) method now works correctly and prevents the format toolbar from showing up when set to false.
• dQuery no longer GPFs if you close a dataModule with more than one database in it.
• Numeric EntryFields now work properly in insert mode. Numbers on the left move to the left, Numbers to the right of the decimal point move to the right. When "SelectAll" is turned off and the Entryfield is in "insert" mode, the entryfield now has an "edit mode" behavior. If the value is less than or equal to 0, the first keystroke removes the 0 and inserts the number typed in its place. This allows heads-up data-entry without having to reposition the cursor before typing a number.
• Subform scrollbars now respect new components when added to the form and adjust their thumb positions and range accordingly.
• detailNavigationOverride settings no longer conflict with the "skip" built into reports. In previous releases, setting the one-to-one, one-to-many and many-to-many overrides for parent- child relations caused a "double-skip" in places when reports were run, resulting in data being omitted from the report.
• In the Source Editor, the cursor position in the right-side editing pane no longer jumps to another position if you click-on or scroll the left object pane. The cursor position now only changes if you select a new object or method in the left pane.
• In the Inspector, when you select a type of "numeric" for a non-datalinked entryfield, the Form Designer now streams the proper numbers to enforce a type of "numeric". Previously, the type changed to "Integer".
• Modified query.sql property so that it will correctly handle parameters in SQL statement (prefixed with a colon) when the parameters contain spaces and are delimited with single or double quotes.
• When you Copy Structure from a SQL Server type table to a dBASE Level 7 table, IMAGE type (SQL Server's large BLOB field type) now converts correctly to a dBASE Binary field, not a dBASE Memo field.

New Features

• isInherited() method of the Designer Object allows you to check whether a component is a member of the current container class (dataModule, report, etc.) or inherited from a higher-level superClass.
• When you click on a Grid Row Indicator, it now changes the currently selected row.
• When you click on a Grid Column Header, the field in the selected column now gets focus.
• Whey you use an invalid character in a fieldName, the Table Designer now produces an error message that lets you know which invalid character you used according to the particular database in use.
• The Listbox now has a "Transparent" property.
• The Table Designer now checks if you have attempted to create more than one AutoIncrement (AutoNumber) field. If you have, it returns an error message.
• Getfile, Putfile and "array getfile" (a.getFile()) now feature a new parameter that lets you define the "files of type" that are displayed in the dialog. The parameter accepts a list of extensions in the form: "prg,wfm,bmp,.*" Note: ".*" displays the "All files (*.*)" option.