Agenda

donorflex stands as the UK's premier, award-winning software tailored specifically for the charitable sector. As a robust Windows application, its transition to the web demands innovative thinking. Peter Bragg, the lead DataFlex developer, faced the challenge of reinventing the user interface. The goal? Crafting aesthetically pleasing WebApps that break away from the conventional 'Order Entry' sample application look.

New productivity features are added to each DataFlex release and it's hard to keep up with all of them. You will learn about some you may have missed like...

• How to edit the Filelist in the Studio

• How to remove/add database identifiers from/to several filelist entries in one step

• How to use the SQL Repair wizard and what it can do for you

• How to find and replace data in many records using Database Explorer

• The new Properties panel filters

• The WebApp Styler

DataFlex contains numerous resources and methods to develop applications with speed and efficiency. “Libraries”, added a long time ago, are among those resources. In this presentation, we’ll show you how the new DataFlex Package Manager helps manage and organize Libraries in your workspaces.

Refreshments will be provided.

Many companies’ annual agreements include help desk and all recent program enhancements. But not all enhancements are created equal! Our goal was to create additional revenue streams from existing customers so we created a new model where some new features are not included in the annual subscription but are now sold as “add-on” features with an incremental, ongoing fee. The presentation will revolve on how we have integrated some newer technologies into legacy projects to add additional revenue streams.

Microsoft has consolidated their on-line office productivity APIs, renaming those from Microsoft Office365 to Microsoft Graph. At the same time DataFlex's tools for interacting with RESTful, JSON-based APIs have improved a great deal in recent years. We'll look at how easy it now is to use those tools to interact with the Microsoft Graph API.

Location: TBA

DataFlex applications use connectivity kits to connect to a foreign database. In the current day and time this is often Microsoft SQL, MySQL, PostgreSQL but there are more. Connectivity kits provide an easy way to connect to a SQL database but do not utilize the full power that many of the SQL databases offer. To use ‘bare’ SQL, also called embedded SQL DataFlex 2023 offers a number of great improvements. 

DataTech has transitioned from the embedded database to SQL and learned a lot about development and deployment in the process. Matt will share:

• Our general approach to developing SQL code and the evolution of techniques we’ve used

• Debugging SQL

• How we deploy changes to SQL code to customers

• A scenario where a program automatically tests to verify SQL reports produce the same results as an old embedded report

• How we do “no/low code” SQL reports

• Using a common code base across Windows/Web/API to deliver reports/data

This session describes a new utility that can copy one MS SQL Database to another from within a DataFlex application. The new database can be created by the tool or it will drop an existing one by the same name and recreate it. The utility works in DataFlex 19.0 and newer. The source code is in a business process so it can be called from Windows or a WebApp.

Refreshments and snacks will be provided.

Building a solution for a customer is one thing, but making them run smoothly is another. We'll be looking at DataFlex features that give your applications that competitive edge that both you and your customers want.

DataFlex 2023 empowers developers to make great looking Windows applications in exciting new ways! During this presentation we’ll have a look at how the new "FlexTron" achieves that.