DataFlex Learning Center

01

Databases in DataFlex

(3m 15s)

Databases in DataFlex are relational. Different database types can be used in DataFlex: embedded dataabase, Microsoft SQL and ODBC (generic). In this lesson we will discuss the database types.

02

Creating the database

(3m 03s)

To get started, a workspace needs to be setup, and a create a database.

03

Creating your first table

(6m 31s)

With the workspace prepared, the next step it to create a table.

04

Define related tables

(7m 05s)

Since it is a relational database additional tables are needed to relate to.

05

Access data using global buffer

(10m 33s)

The next step in this series is to start using the prepared database.

06

Access data using local buffer

(11m 40s)

Following is a demonstration of using a local file buffer.

07

Data Entry Objects

(10m 46s)

After learning how to access data from within DataFlex code the next step is to create a data entry view.

08

Grids

(3m 56s)

Building on the view that was created in the last lesson to view and edit existing recipes this lesson will now add the list of ingredients to the view using grids.

09

Manipulating data

(7m 37s)

This lesson will show how to use a business process to manipulate data.

10

Use embedded SQL

(7m 48s)

This lesson will use embedded SQL to show an alternative method to access data. Embedded SQL is only available when working with SQL database. In this lesson Microsoft SQL will be used. This allows SQL statements to be used directly within DataFlex source to access the data. Accessing the SQL database directly is advantageous. For example, when building a business process or when a list needs to be filled quickly.

DataFlex courses

Information

Working with Databases