Discovering DataFlex overview

Discovering DataFlex video overview list

Do you want to build your own IT-system? Even if you are not a developer, you will be able to follow the steps Johan take in building a large scale application using DataFlex.
This is the first video in a series where we will dive in to the details as well as the broader strokes of building software applications. So, do not miss out. Download DataFlex at dataaccess.eu today and follow along.

Currently I have not decided what app to build and I welcome any suggestions in the comments. It is not that important, as we will try to focus on new details of the DataFlex framework on every episode. But it is nice to have some end goal to work against and talk about as we progress.

In this video I just want to give you a tour of the Studio and the useful features that make life easier for a developer.

Among other things we cover the following:
Tabs (code, tables, …)
F1 – To show help
F7 – Toggle code vs visual interface
Ctrl + Space – Auto complete aid
Alt + Arrow – Move selected rows
Ctrl + K – Toggle comments
Ctrl + Mouse wheel – Zoom code
Ctrl + Shift + S – Save all unsaved files
Run and debugging controls

Here is the link to where Harm showing the studio, he highlights some other things that can also be useful to know – https://www.youtube.com/watch?v=M5eSf…

If I missed any nice things then feel free to add it in the comments below.

 
 

If you want to start any coding project that you intend to continuously develop, you should put your code in GIT from the start. Used right GIT can be a life saver and it will save you a lot of time when managing your code further down the road.

Here is a link to my git repository where I will continue to push code I write in these videos https://github.com/virdun/Discovering…

Quickstart: building a Web Application (Mobile/Touch) with Eddy Kleinjan https://www.youtube.com/watch?v=5OUyC…

Create a mobile application with Johan Broddfelt https://www.youtube.com/watch?v=Kimys…

More information about using GIT with DataFlex https://dataflex.wiki/index.php?title…

One of the most important pieces in an application that is supposed to manage data is the database and it’s tables.

This video explains the most basic steps you need to take in order to create tables and relate them in DataFlex and some hints of what you need to think about when creating tables for a DataFlex application.

One of the strengths of DataFlex is that you can generate pre-styled, feature rich views in a few minutes. In this video I show how to build some of the most basic views in DataFlex that can support most of your needs for a simple application. Bare in mind that the video is just over 20 minutes and I also have time to fix a few bugs along the way.
 
If you want to know what DataFlex can do in terms of developer performance in terms of building interfaces. This is the video you want to see.
 
Here is a link to my git repository where I will continue to push code I write in these videos https://github.com/virdun/Discovering…
Many users expect to be able to view the data in a list to get a better overview, because this is the way they are used to look at data in excel. In this video I’m building such a list view with a search form in the top.
 
We will run through some special cases that you want to look out for when selecting data without DataDictionary bindings. You will also see how Constraints are used in DataDictionaries and how to set the list as the start page for the entire applicaition.
 
You can find all the code for this project at GitHub: https://github.com/virdun/Discovering…
DataFlex have its own record-based database, but now days the recommendation is to use an SQL database like MSSQL, MySQL, DB2 or other SQL based databases. In this video I show you how to migrate our database to SQL and I make some updates to the search list.
 
Some of the things we look at is how to join in related tables to be able to search for content in columns in related tables. We also look at how to best manage dates when querying the database.
 
Here is a link to my git repository where I will continue to push code I write in these videos https://github.com/virdun/Discovering…
Just having a list of items might be a bit annoying if you want to edit one of the items. That’s why we add a modal popup where we can edit each item using a proper edit interface.
 
As usual, you can find all the code on git at https://github.com/virdun/Discovering…

Before you run away and show the project to your client, you want to add that little extra touch that will make them go WOW! That feeling will put them in a good mode and a spirit of fixing all the details as well instead of complaining of the things still lacking 😉

In this video I show you a few simple tweaks that will give your application that extra push and reveal a hidden trick to overcome the tedious issue of cached CSS-styles in the browser.

Web App Styler, where you easily can change brand colors of your application https://styler.dataaccess.eu/

Visit the GIT repo to download the code https://github.com/virdun/Discovering…

 
What is a system that is supposed to keep track of your stuff without images? Not, very useful. So, let’s go ahead and add the option to upload images to the items in our application.
 
While I’m at it I’ll also show you some useful trix to get the file management to work in a production environment. Because there are a few security steps to manage along the way.
Visit the GIT repo to download the code
https://github.com/virdun/Discovering…

If your application should be branded you probably also want to change the favicon and title. It makes it easier to find your app if you have many tabs open in the browser, but it will also put your logo on the link document on your desktop or phone when you create shourtcuts which is really nice.

This is one of the core advantages of using DataFlex and it’s Data Dictionaries. By just adding a few lines of code, a total or sum can be maintained regardless of where in the application you change, update or move an item.
If you have a parent child relationship and want to maintain a calculated value from the children in the parent. This is the way to do it in DataFlex.

This week we got a question from Brazil about how to highlight rows in a cWebGrid. This works for cWebList, cWebHtmlList and cWebPromptList to style items separately based on any criteria.
If you want to highligt items with missing data, passed expiration, above or below a threashold or based on a key, this is the way to do it.

Is there any ware you type a search term today where you cannot press enter to get the result? Well we should not be worse then the norm, let’s add this feature to our application as well.

Those of you who have most of your DataFlex experience in Windows and console mode applications are probably familiar with On_Key. This does not work in a web application, so we need to change that to AddKeyHandler instead.

UX (user experience)

 
Sometime you want to prevent regular users to change or delete things in your application. This can be done with user rights that you can find in the WebAppUser. Here is how you do it in the most basic simple way.
 
Visit the GIT repo to download the code

One common thing when working with lists, you often run in to the task of adding a delete button to remove rows from the list. In this video we not only delete the row, we also add a button as an icon and include a yes/no popup question in order to verify the intention to delete.