Features in Depth

dBase found and integrated a very powerful Grid component late in the development cycle and was able to get the base functionality in place. However, the new GridEx has a great deal more potential, but we want to work with the dBASE user community to help decide the most critical features that need to be implemented.

ListView is a brand new native data-aware dBASE component designed for efficient display of vertically scrolling lists of changing data.

We have added some small enhancements to the current Grid found inside dBASE. Things like highlighting the current cell focus and other cosmetic wants by the user community.

One of the most requested features over the past 20 years, the product now allows developers to “embed” the dBASE Runtime into a single executable (.exe). This allows users to deploy dBASE applications without having to ship the runtime files. BDE libraries/files are still needed when using dBASE, Paradox, or ODBC access to tables. ADO does not require the BDE!

This highly requested features allows for ultimate control over the install process when using Project Explorer. Use the Embedded Runtime with or without the BDE, all can be done with a click of the mouse.

dBASE now allows developers to pull additional resources out of a resource.dll for better portability and eased of deployment. By adding the /png to the command dBASE now has the ability to pull .png graphic from a resource dll, which adds significant upgrade to .bmp in size and quality. In addition, these resources also handle the Alpha color channel properly and work great with the new Resource Libraries included in the product.

The Massively Updated Compiler and Interpreter allows for a great many new features and functionality. The updated compiler now supports symbol names to contain 255 significant characters (up from 32 previously). It improves the symbol tracking and lookup speeds, which decreases both compilation time and execution time of dBASE code and:

• expands the number of distinct symbols that can exist simultaneously up to 2^30 symbols (up from 32K previously)
• expands the number of procedure files that can be loaded simultaneously up to 2^31) (up from 2K previously)
• removes previous limits on size and complexity of individual source files
• takes advantage of faster and larger memories in today’s computers to speed up compilation and minimize number of disk writes
• upgraded dBASE Object Code File format to handle all of the above changes

The new debugger now adds the same look and feel of dBASE, plus includes the same editor that dBASE uses for better productivity and ease of use. The new dBugger™ 1.0 adds a new communications channel between dBASE and the dBugger™ to allow for faster execution during debugging and removing many of the deadlock situations that occurred in the older debugger. In addition, it also introduces the new fly-by inspection feature that allows for fast variable and object inspection. It is also being compiled with the same compiler as the dBASE product thus making it much more stable over prior included debuggers. It also introduced better window handling for Watches, Variables, Trace, and Call Stack operations.

The Navigator now includes a built-in advanced Image Editor called Fotografix. This open source product will allow users to modify existing images or create new images to be used inside their dBASE PLUS 10 creations. If you already have an Image Editor defined in Windows, no problem, dBASE will use it instead but still give you the option to use Fotografix for advanced image processing whenever it is needed.

dComplete™ 2.0 has been completely updated to support more dBASE specific coding structures. It now supports more commands in the command window, better filtering inside the code editor, and a more complete listing of objects, methods, and events.

These new libraries are based off of the open source Google Modern application specification and are open source and royalty-free for use in your internal and external applications. They have been conveniently located in easy to use Resource dll(s) for ease of deployment.

dBASE™ PLUS 10 now includes integrated Web help. This makes it easier to find crucial information in a timely manner. The help system has also been updated with the latest material on getting the most out of the latest release of dBASE!

dBASE PLUS 10 is built on the quality of dBASE PLUS 9.5.1 and has continued to fix known bugs, and add, update, and replace features to make the product easier to use and give the users the ability to build cutting-edge Windows® based data-aware applications.

The new editor in dBASE PLUS brings new programmer functionality that will help developers increase their productivity and get their jobs done faster and with more consistency. The new editor has an extensive list of valuable built-in features reading dBASE code easier than ever before. Some of these great features include:

• End of Line: (now know where the end-of-line mark is)
• Code Folding: (lots of code, reduce the length and focus on only the code you need)
• Indentation Guides: (help better document the code)
• Line Numbers: (Know the exact line number in the code and use in combination with bookmarks)
• Comment line: (Simple key-combination for commenting out a line or uncommenting a line)
• Comment Block: (Simple key-combination for commenting out a block of code or uncommenting out a block of code)
• Make selection upper case: (Simple editor tool, make the selected text ALL UPPER CASE)
• Make selection lower case (Simple editor tool, make the selected text all lower case)

The #1 requested feature of dBASE, code completion. Now dBASE PLUS has dComplete™ our version of code completion, code insight, intellisense, or whatever you want to call it, is now available inside dBASE. dComplete™ is very useful in the new editor, when the prediction is based on a list of words in one or more languages. dBASE PLUS displays the technical texts a word list of terms in that field is used and auto-fills the text in place. dComplete™ speeds up human-computer interactions in environments to which it is well suited.

Allows users to use code-shortcuts to enable snippets of code to be inserted in to the editor. Not only does this save time and speed development it also reduces common typing mistakes. dBlocks™ can be user-enhanced with individual additions to the dBlocks™ file.

Productivity is all about not breaking the flow and dBASE PLUS increases the number of functions that can be accomplished in the new editor with keyboard shortcuts. No longer having to stop typing to click the mouse to do an operation, now just combine a few keys and get the operation done fast!

Zoom in the Editor
CTRL-{num pad} + (zoom bigger) CTRL-{num pad} – (zoom smaller)

Toggle Comments on/off in the Editor – CTRL-Q (Toggle Comments – lines or blocks)

Now preview what could be printed before wasting paper. This feature works with dBASE Forms, Programs, or Reports. Click for CTRL-P to preview, then click the Print to finish the task.

Now allows for incremental search, faster search and replace, and also brings the Search in Files features to the product.

No need to have multiple editors on a machine now, dBASE can handle the work. The new editor allows various other languages to be worked with from within the IDE. These languages include xBASE and dBL of course, but it also allows for plain Text, SQL, JavaScript, HTML, XML, and others. The support currently brings context sensitive highlighting, code folding and other coding tools to dBASE 9.

The new editor now allows you to export out your source code, forms, reports, etc. in various useful formats that make working with and sharing much easier and safer than before. The new output formats include HTML, RTF, PDF, LaTex, and XML.

The new editor will now display code hints to help people create code quickly with updated material from the documentation.

The new dBASE PLUS IDE with the new Look & Feel introduced with dBASE PLUS 8, now allows those UI Themes to be used in your projects as well. A couple of lines can be added to the shipping applications .ini file or use the Project Manager to add the specific UI Theme during the build process.

[button url=”#” bg=”EB1A22″ color=”FFF” bg_hover=”#EB1A22″ target=”blank”] New in 9.0 [/button]

Code Folding: (lots of code, reduce the length and focus on only the code you need).

Know the exact line number in the code

Now with one ‘.’ representation, know exactly where the spaces are in a line, used in combination with End of Line Indicators and Indentation Guides makes a very powerful set of tools.

Know where the line ends and how it was ended. The End of Line Indicators work in combination with White Space Indicators and Indentation Guides.

Well-defined and well-structured code makes it easier to read and ultimately understand. Use the new Indentation Guides to ensure code is lining up from line to line and from indentation to indentation.

dBASE PLUS allows the new editor to be fully customized, which allows the users to make the environment fit their personalities and make using the product easier, faster, and more enjoyable to use.

Simplify the readability and understanding with full Context Sensitive Highlighting of dBASE programs as well as other programming languages. dBASE PLUS now gives the ability either through the configuration property editor or through the properties files the ability to customize the display of information for easier consumption.

This new dbf Utility allows users to quickly see what the dBASE file extensions are all about. Now with this Windows® plug-in the user can click on a dBASE based file and understand in depth information about the file and its extension.

dBASE 8.1 brings back the popular Multi-lingual support that users of dBASE have come to expect. The latest release of dBASE adds back the support for German, Japanese, Italian, Spanish and of course the default language of English.

[button url=”#” bg=”EB1A22″ color=”FFF” bg_hover=”#EB1A22″ target=”blank”] New in 8.1 [/button]

dBASE 8.1 has enhanced the ActiveX capability in every way. ActiveX support has been limited over the past couple of releases. Microsoft® has changed many of the underlying frameworks and interfaces and now dBASE better supports well-behaved ActiveX controls and automation.

[button url=”#” bg=”EB1A22″ color=”FFF” bg_hover=”#EB1A22″ target=”blank”] New in 8.1 [/button]

dBASE 8.1 updates a number of key components to enhance the capability of prior releases. Updates to Notebook and Menus allows users to use the components as they expect.

[button url=”#” bg=”EB1A22″ color=”FFF” bg_hover=”#EB1A22″ target=”blank”] New in 8.1 [/button]

dBASE 8.1 introduces a new level of convenience with the addition of the User BDE Alias page found in the Desktop Properties dialog. Now there is no need to jump into BDE Administrator to add a User Alias.

[button url=”#” bg=”EB1A22″ color=”FFF” bg_hover=”#EB1A22″ target=”blank”] New in 8.1 [/button]

dBASE 8.1 introduces a new internal graphics engine that allows for better support of the most commonly used graphics formats available today. This means support for BMP, PNG, ICO, GIF and others like animated GIF format.

[button url=”#” bg=”EB1A22″ color=”FFF” bg_hover=”#EB1A22″ target=”blank”] New in 8.1 [/button]

Implemented via 128 bit decimal floating point numbers that support up to 34 digits of precision. A decimal floating-point number is stored using a base 10 value, which reduces conversion errors that normally occur switching back and forth to base two floating-point values.

Being able to use an ADO data source is great, but we did not stop there. We have also added in several custom ADO components that make working with ADO a breeze in dBASE PLUS.

More has changed under the hood of dBASE PLUS than just support of Microsoft’s latest operating system. We have also added support for connecting to ADO datasets.

The new support for ADO includes the ability to create and use Microsoft based UDL files. A UDL File stands for universal data link (.udl) file is essentially a text file that contains the connection string for an OLE DB data source. This connection string can then be loaded into dBASE and used by the components and tools to connect to ADO data sources.

Completely redesigned, the SQL Designer can be used to quickly pull all of your data together in a visual way. You can see the relationships between each dataset, and create result sets that meet the true business needs of your application.

dBASE has always had the ability to run ActiveX controls since they were introduced by Microsoft. dBASE has started to add additional ActiveX controls to the product to fill-in areas of functionality that is currently missing from the standard components included in dBASE PLUS.

The new controls are focused on areas people have requested:

• dJvClockX Control – A quick clock control for standing time management. Support both digital and analog look and feel, support Dates, and it also has full support for Alarms.
• dJvDriveComboX Control – This is a simple window Drive combobox. It will show all the registered drives on a system. Find and interact with those drives in a couple clicks.
• dJvDirectoryListBox Control – This is a Directory listing component and can be easily connected to the dJvDriveComboX component. This will allow for traversing a drive and directory on a registered drive. Many advanced features are included with its Properties, Methods, and Events.
• dJvFileListBoxX Control – dJvFileListBoxX is a file listbox that shows all of the files inside a particular directory on a registered drive. This component works very well with both the dJvDriveCombo Control and the dJvDirectoryListBox control. This component has many advanced features that are exposed from its Properties, Methods, and Events.
• dJvRichTextEdit Control – Have full RTF capability with the ActiveX control.

In addition to supporting themes inside of dBASE PLUS, it also support docking of tool windows. Therefore, tool windows like Component, Format, Fields, and the Inspector can now be docked to the sides of the screen, stacked on top of each other with a tab interface, or strategically laid out to the developer content. In addition to supporting tool windows, the product also supports movable menus as well.

dBASE PLUS now includes an updated and modernized interface. These additional features include new professional icons, updated wizard graphics, and support for Microsoft Themes. The product appearance has been updated as the new default theme is based on the black color scheme, which is configurable by the user at any time including while the product is running.

dBASE PLUS has a wide range of new graphical features, that include Icons, Application Themes, new components, and also new textures. Developers can now use these textures to create modern looking interfaces that are very common today. These textures are used in the background property of the form and the product supports all common window sizes for easy application building.

There is more to staying current than just maintaining functionality. While the user interface for dBASE PLUS has itself been enhanced to look more modern, we realize that the applications dBASE users have created also need to be updated with the times. That is one reason dBase, LLC has partnered with Glyfx to provide a rich set of visually stunning graphics that can be used to enhance the look of any dBASE application.

The new IDE supports Microsoft’s themes, these are packaged colors, fonts, and window looks. The current themes supported in dBASE PLUS include most of the standard themes using in Microsoft office 2007 and 2010.

One of the important features of an MDI interface, which dBASE PLUS is based, is the ability to quickly find Windows, Wizard, tool windows in the interface. The new Window tab manager can be customized to the developer’s desire and really help find and manage open windows.

The updated project file allows users to build applications with all needed resources (tables, forms, queries, bitmaps, and so on). In addition to keeping things organized, having a project file lets you Compile and build a project. It also allows you to set properties for the project as a whole and set properties for individual files. It will allow you to designate which file should be the first to open when your executable file is run.

Getting help when and where you need it is important to everyone. In dBASE PLUS we have updated the content and enhanced the in app help system just as we have been expanding our available training solutions for dBASE users. Knowing how to get things done right in dBASE PLUS is as important to us here at dBase, LLC as it is to you.

One of the biggest concerns on the minds of current dBASE users is the future. Will dBASE continue to work on future operating systems. With dBASE PLUS, we have certified that all major and minor features of the product continue to work well on Microsoft’s latest operating system, Windows 8.

A callback allows you to write a function or method in dBL code and setup a pointer to it that can be passed to an external program – such as Windows or the BDE or some other 3rd party software that supports callbacks. Callbacks can be used to notify your program of specific events occurring with an external program OR to allow your program to modify what an external program is doing.

These are included tools to help migrate from prior releases of dBASE.

Specialized tools for building applications for the web.

Allows dBASE application exe’s to be deployed and run on user’s workstations, servers, and web-servers.

Compiles source code into a highly compact object code (also called “byte code”) either on demand or only when needed – prior to running it.

A debugger that has a graphical user interface inside of the development environment and is a used to test and debug other programs (the ‘target’ program).

A highly optimized interpreter for executing dBASE object code (byte code) that has been generated by the dBASE compiler.

The Command window is used to directly execute one-line dBL commands. It is handy for testing simple expressions and immediately seeing the results in the results pane.

The Navigator provides a visual way to create, locate, access, and open individual files. It also lets you establish your working directories and search paths.

The form design window is a visual design surface on which you position the components you need for your form, then set their properties in the Inspector and code their event handlers and other methods.

The report window is a visual design surface to which you drag and drop the components you need for your report, then set their properties in the Inspector.

Building basic menus through the designers is a simple two-step process of adding items, then adding code to make the items do what you want them to do.

Use the Label designer to create labels and other reports that use more than one report band.

The Source editor lets you view or edit code for any dBASE Plus form, report, menu, query, data module, program, or any other type of text file.

3rd party libraries support for extending dBASE applications.

Use the Table designer to design or restructure a table.

The Data Module design window is a visual design surface for designing data modules that you can use in your forms, reports, and labels.

A set of non-visual classes that make working with databases easier.

dBASE can interact with any ODBC (Open DataBase Connectivty) data source and manipulate its data.

Supports all dBASE DBF table structures from level 3 thru level 7.

dBASE can interact with Paradox data structures.

dBASE can interact with FoxPro and Visual FoxPro data structures.

A set of components that are visual in design and make creating Microsoft Windows applications fast and easy.

A set of components that allow for simple integration to the underlying Operating System items like the File System.

One of the first functional database programming languages that the dBASE product pioneered.

dBL (dBASE Language) is an object Oriented language for building rich database applications in dBASE.

Local SQL (sometimes called “client-based SQL”) is a subset of ANSI-92 SQL for accessing DB (Paradox) and DBF (dBASE) tables.