Loading...
 

CX_DBASE_FILE

CX_DBASE_FILE

Class hierarchy
Description:

This class is used to manage the database files of dBase or Clipper (extension .dbf).

Code example: 
Var(dbase, record)

CreateTransObject(CX_DBASE_FILE) -> dbase
"*.dbf" FileDlg("Select dBase", 0) dbase Put(fileName)
dbase Call(Open)

dbase Call(RecordCount)
String("This file contains %i records") Attention(,INFO)

do {
  dbase Call(Read) -> record

  record Cardinality 0 = if { "Reached file end" Attention(,INFO) break }

  //... do something with the record
} loop

dbase Call(Close)

List of methods (MDI)

Function MA* Parameters Return Brief description
Close Closing a dBase file
DataFieldNames VECTOR (STRING) Read out all field names (columns)
NextRecordIndex
192575
INTEGER Returns the index of the next record
Open Opening a dBase file
Read VECTOR (STRING) Read the next sentence
RecordCount
192575
INTEGER Number of available sets
Seek
192575
INTEGER Sets the reading cursor to the specified index

* MA = Member Access Function

Data directory (DDI)
Data field Type Reference class I* Brief description
fileName STRING File name

* I = Indexable data field

Use in AppsWH
Module Brief description