Database Files

 

 

Create Table

 

Table Name: TEL.DBF (Data Base File)

 

Field

Type

Size

Name

Character

50

Address

Character

50

Phone

Character

15

 

Example - Screen shots:-

 

Domain(Create Table) Component (Create Table)

 

Interaction Page

 

Steps Tree

 

Domain (Create Table) Component (Add Table Field)

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Final Steps Tree

 

Opening & Closing Tables

 

Work Area are used to host a table, you can open more than one table in the same time (up to 250) using work areas.

 

What you need to do for example

 

 

Note that the work area number is not related to the table name

Where you are free to determine what work area host what table

 

To change the active area (moving between tables), all what you need is to select the work are of the table which you want to deal with

 

The table in the active work area (selected area) is under your usage directly

Where you can use its field’s names as variable names to get their content (Reading) or altering their content (writing)

 

When you open table, the active record is the first record, but you can move between records (First Record, Last Record, Next Record & Previous Record) to get their data or alter it

 

Also you can know the record number and number of records inside the table

 

It’s clear that working with database files depend on status which include

 

To close a table, you need to activate the work area of this table then close the table

Also you can close all the opened tables (close database)

 

Add New Record

 

Example - Screen shots:-

 

Domain (xBase) Component (Select Area)

 

Interaction Page

 

Domain (xBase) Component (Open Table)

 

Interaction Page

 

Domain (xBase) Component (Add New Record)

 

Domain (xBase) Component (Replace)

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Domain (xBase) Component (Close Table)

 

Steps Tree

 

Moving between records

 

Domain (xBase) Component (Goto)

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Steps Tree

 

The Final Application

 

 

Record number & records count

 

Domain (xBase) Component (Get Information)

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Interaction Page

 

Final Steps Tree

 

The Final Application

 

 

 

Modify record

 

Be sure that this record is the active record, and then you can alter it using

Domain (xBase)

Component (Replace)

 

 Deleting records

 

Be sure that this record is the active record, and then you can mark it for deletion using

Domain (xBase)

Component (Delete Current Record – mark for deletion)

 

Domain (xBase) Component (Delete Current Record – mark for deletion)

 

You can recall the deleted record using

Domain (xBase)

Component (Recall)

 

Domain (xBase) Component (Recall)

 

 

To exclude the deleted records, you need to set delete on

And to include the deleted records, you need to set delete off

Domain (xBase)

Component (Set Delete)

 

Domain (xBase) Component (Set Delete)

 

Interaction Page

 

To pack database file (deleting records marked for deletion)

 

Domain (xBase)

Component (Pack)

 

 

Domain (xBase) Component (Pack)

 

Search

 

You can locate record which match a condition

 

Domain(xBase) Component (Locate For)

 

Interaction Page

 

 

Also you can continue search to locate another record

Domain (xBase) Component (Continue)

 

 

And after locate of continue you can know if the record is found of not

 

Interaction Page

 

Index Files

 

Domain (xBase) Component (Create Index File)

 

Interaction Page

 

Domain (xBase) Component (Set Index To)

 

Interaction Page

 

Domain (xBase) Component (Reindex)

 

Interaction Page

 

 

 

Shared Data

 

To open database files as shared table

You need to set exclusive off before opening the table

 

Domain (xBase) Component (Set Exclusive)

 

Interaction Page

 

To modify record data in shared environment you need to lock the record before altering the data and unlocking the record after altering the data

 

Also you can lock and unlock the data files (all records) before operations that alter all records.

Domain (xBase) Component (Lock)

 

Interaction Page

 

Domain (xBase) Component (Unlock)