DbfREXX

A REXX extension that allowes you to work with xBase database, index and memo files from your REXX program. Shipped as a compiled royalty free DLL for 32 bit versions of OS/2 and later for the 32 bit version of MS Windows.

Features

According to the company sales blurb:

• Meaningful function names familiar to the xBASE programmer.
• Network support.
• File and record locking.
• Functions for opening, creating, updating, reading, and indexing dBASE files.
• Soundex searching

File format support

• DBF (dBASE, Clipper, Foxpro database)
• DBT (dBASE, Clipper memo fields)
• FPT (Foxpro extended memo fields)
• NDX (dBASE index)
• NTX (Clipper index)

Version

• 2.0 (1995)
• 3.15 for OS/2 and MS Windows

Prerequisites

• OS/2 Warp or later
• A REXX interpreter for the Windows version.

Interpreter & framework support for v.3.1

• Classic REXX built into OS/2
• Object REXX built into OS/2
• Watcom VX-REXX
• Hockware VisPro/REXX
• Quercus Systems Personal REXX for OS/2
• IBM Object REXX for Windows
• Quercus Systems Personal REXX for Windows

Note that this is just what the company explicitly supported, other REXX systems like the Regina REXX interpreter and the GpfREXX GUI builder appear to work as well.

License

• Commercial - Discontinued
• dbfREXX - basic library for each platform, "Gold" version bundles the OS/2 and MS Windows version, per year for a site license
• dbfREXX bundled with dbfLIB

Author

• dSOFT

API

This is a list of the calls the dbfREXX DLL/library accept, they are listed here simply as a reference for those that may have the library but not the handbook.

   RexDbfAppend                 RexDbfDeleteAll          RexDbfRecall
   RexDbfAppendFrom             RexDbfDeleted            RexDbfRecallAll
   RexDbfAppendFromFile         RexDbfFlushWrite
   RexDbfAppendMultiple         RexDbfGetDatabaseType    RexDbfReccount
   RexDbfBottom                 RexDbfGetLastError       RexDbfRecno
   RexDbfClearRecBuf            RexDbfGo                 RexDbfRefresh
   RexDbfClipperLock            RexDbfHandle             RexDbfSeek
   RexDbfClose                  RexDbfLocate             RexDbfSeekNoPad
   RexDbfCloseAll               RexDbfLock               RexDbfSetDeleted
   RexDbfCopyTo                 RexDbfMarkAll            RexDbfSkip
   RexDbfCreate                 RexDbfName               RexDbfSort
   RexDbfCreateExtended         RexDbfOpen               RexDbfSoundex
   RexDbfCreateFile             RexDbfPack               RexDbfTop
   RexDbfCreateFromExtended     RexDbfPackAndReindex     RexDbfUnlock
   RexDbfCreateFromFile         RexDbfQueryLock          RexDbfUpdateRecord
   RexDbfCreateFromHandle       RexDbfReadRange          RexDbfUse
   RexDB3Lock                   RexDbfReadRangeBuf       RexDbfWriteRec
   RexDbfDB4Lock                                         RexDbfZap
   RexDbfDelete

   RexFldChangeName             RexFldReplaceDate
   RexFldCopy                   RexFldReplaceDirect
   RexFldCopyDate               RexFldTrue
   RexFldCount                  RexFldType
   RexFldDecimals               RexFldValue
   RexFldName                   RexFldWidth
   RexFldReplace

   RexIndexBottom               RexIndexOpen             RexIndexGetCurrent
   RexIndexClose                RexIndexReindex          RexIndexSetCurrent
   RexIndexCloseAll             RexIndexSkip             RexIndexKeyExpression
   RexIndexCreate               RexIndexTop              RexIndexKey
   RexIndexKeyLen               RexIndexType             RexIndexNSeek

   RexMemoBlockSize             RexMemoRead
   RexMemoDelete                RexMemoReadFilter
   RexMemoExist                 RexMemoWrite
   RexMemoLen

   RexGetAutoPack               RexGetDbfNormal          RexGetDefaultLockType
   RexGetCentury                RexGetDbfOpenMode        RexGetPadding
   RexGetDbfDateFormat          RexGetDbfReadOnly        RexGetStemName
   RexGetDbfExclusive           RexGetDefaultBlockSize

   RexSetAutoPack               RexSetDbfNormal          RexSetDefaultLockType
   RexSetCentury                RexSetDbfOpenMode        RexSetPadding
   RexSetDbfDateFormat          RexSetDbfReadOnly        RexSetStemName
   RexSetDbfExclusive           RexSetDefaultBlockSize

   RexCvtCharReplace            RexDbfLIBVersion         RexLoadDbfLib
   RexCvtCharToDate             RexDbfVersion            RexUnloadDbfLib
   RexCvtDateToChar