What's New in DataFlex 2023 - Alpha 1

DataFlex 2023 introduces FlexTron, which brings Web views and controls into Windows applications, allowing a more modern look and feel or just adding Web features to more mature Windows applications. DataFlex 2023 provides better tools for working with SQL with a New Embedded SQL API, including new classes, named parameter support, @SQL string with syntax highlighting and a SQL Query Tester in the Studio.

Watch the What’s New in DataFlex 2023 (pre-release) Learning Center course.

Visit the DataFlex 2023 Testing forum to report testing feedback.

 

FlexTron

DataFlex 2023 introduces FlexTron, which brings Web views and controls into Windows applications, allowing a more modern look and feel or just adding Web features to more mature Windows applications.

You can use a single Web control or build entire applications.

The following classes provide support for this:

 

Read more about FlexTron.

 

New Embedded SQL API

DataFlex 2023 comes with a new way to work directly with SQL statements. A new engine for executing statements is built into the runtime that puts result sets directly into native DataFlex types. This means that your results can now go directly into structs, multidimensional arrays and variants with the proper type conversions being done automatically. Parameterized queries now support named parameters and only a single class / object is needed for executing queries. Studio support for working with SQL statements is improved by adding syntax highlighting, code sense and a query test tool for SQL statements.

@SQL String with syntax highlighting

cSQLExecutor class

Note: cSQLExecutor does not work with DB2 as of Alpha 1, but will work in later releases of DataFlex 2023 - 23.0.

Query Tester

A Query Tester has been added to the Studio. It helps you create, test and execute SQL queries and has a Struct Generator.

Read more about the Query Tester.

Include_Text

Include_Text allows .SQL and other text files to be included as constants with a single line of DataFlex code.

 

 

Read more about the New Embedded SQL API.

 

Studio Improvements

Query Tester

A Query Tester has been added to the Studio. It helps you create, test and execute SQL queries and has a Struct Generator.

Read more about the Query Tester.

Web Property Categories

Web properties are now identified in the Properties Panel with a Unicode Earth character.

Due to this, Web Properties are no longer listed in a separate Web Properties category, but in meaningful categories like Appearance and Behavior, along with standard (non-Web) properties.

Properties Panel Filters

The Studio's Properties Panel now allows for filtering of properties.

You can choose whether to show All properties, Standard (non-Web) properties or Web properties.

In addition, you can choose to see only changed properties along with the property type filter above.

Automatic Theme Change based on System Settings

The Studio can now change from Light to Dark Theme when Windows does, rather than having to manually toggle the Studio theme.

Miscellaneous

You can now Import preferences from a prior Studio version (18.2 or higher) from the Tools menu.

Added keyboard shortcut Ctrl+Shift+G for GoTo Definition in the Code Editor.

Copy search results to clipboard now supports Unicode.

 

Connectivity

Drivers

Improvements
Bug Fixes

 

Codejock Version Update

DataFlex 2023 uses the 22.0.0 release of Codejock (both COM and MFC) and all the related components have been updated.

Note: Codejock renamed its Grid control classes from Reportxxx to Gridxxx, which, once imported from the Codejock ActiveX control and "wrapped" to be used with DataFlex, to some classes (including class members and constants) having their names changed from cCJReportxxx to cCJGridxxx. For example, the class cCJReportBehavior is now named cCJGridBehavior.

We have tried to make this transition as seamless and painless as possible, to ensure that your DataFlex applications compile and work as before.

We changed all of the names in our internal classes (most importantly cCJGridControl.pkg). DataFlex Codejock classes that are wrapped, and have additional DataFlex code to improve how DataFlex uses that class mostly already used the Gridxxx naming convention (e.g. cCJGrid, cDbCJGrid, cDbCJGridColumn, etc.). If your code only use these classes, you will be able to compile your applications without any code adjustments.

If your code uses DataFlex Codejock classes that are wrapped, but referenced code using the old Reportxxx naming convention, you may get compiler errors. To resolve these, you can either:

 

Web Framework Improvements

Faster WebApp Startup Times

Faster startup times due to improved web property logic.

New Classes

Added cWebMultiSelectList, cWebColumnSelectionIndicator classes for selecting multiple rows.

Added cWebColumnsTags class.

Miscellaneous

 

WebApp Server Improvements

Improved Crash Logging

WebApp crashes are now logged to the Windows Event viewer with a full stack trace if possible.

 

Language Improvements

/* comment

   goes

   here */.

 

Windows Improvements

 

Compiler Improvements

You can now define/replace symbols from the Console Compiler.

-R adds replaces to the compiler which can either equal symbols or definition. If a symbol is not definined in code, the symbol will be defined as| CI1:

-RPRODUCTION_BUILD

You may also specify the definition, such as:

-RVERSION=1.0

If you want to define a string, it needs to be encapsulated in single or double quotes (‘'' or '“’).

 

Sample Improvements

 

Database Explorer Improvements

 

Various Improvements and Fixes

 

Documentation

 

Welcome

 

Class Ref

 

Language Reference

 

Miscellaneous

 

See Also

FlexTron

New Embedded SQL API

Query Tester

What's New