Jump to content

DbfREXX: Difference between revisions

From EDM2
Created page with "==Description== 200px|right A REXX extension that allowed you to work with xBase database, index and memo files from your REXX program. Shipped a..."
 
Ak120 (talk | contribs)
35,819 edits
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Description==
[[Image:Redrexx.gif|200px|right]]
[[Image:Redrexx.gif|200px|right]]
A [[REXX]] extension that allowed you to work with [[xBase]] database, index and memo files from your REXX program. Shipped as a compiled royalty free DLL for 16 and 32 bit versions of OS/2 and later for the 32 bit version of MS Windows.
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====
==Features==
According to the company sales blurb
According to the company sales blurb:
* Meaningful function names familiar to the xBASE programmer.
* Meaningful function names familiar to the xBASE programmer.
* Network support.
* Network support.
Line 11: Line 10:
* Soundex searching
* Soundex searching


====File format support====
;File format support
* DBF (dBASE, Clipper, Foxpro database)
* DBF (dBASE, Clipper, Foxpro database)
* DBT (dBASE, Clipper memo fields)
* DBT (dBASE, Clipper memo fields)
* FPT (Foxpro memo fields)
* FPT (Foxpro extended memo fields)
* NDX (dBASE index)
* NDX (dBASE index)
* NTX (Clipper index)
* NTX (Clipper index)


==Version==
==Version==
* '''Last known version:''' v.3.1 for OS/2 and MS Windows.
* 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====
====Interpreter & framework support for v.3.1====
* Classic REXX built into OS/2
* Classic REXX built into OS/2
* Object REXX built into OS/2
* Object REXX built into OS/2
* Watcom VX-REXX
* Watcom [[VX-REXX]]
* VisPro REXX
* Hockware [[VisPro/REXX]]
* Quercus Systems [[Personal REXX]] for OS/2
* Quercus Systems [[Personal REXX]] for OS/2
* Object REXX for Windows
* IBM Object REXX for Windows
* Quercus Systems [[Personal 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.
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.
Line 38: Line 43:


==API==
==API==
This is a list of the calls the dbfLIB dll/library accept, they are listed here simply as a reference for those that may have the library but not the handbook.
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.
<pre>
  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
</pre>


[[Category:Tools]][[Category:MS Windows Tools]][[Category:REXX]][[Category:xBase]][[Category:Databases]]
[[Category:REXX Function Library]][[Category:xBase]]

Latest revision as of 21:42, 12 December 2022

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

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
  • Last known prices for dbfREXX ca. 2003 were USD 129 for the basic library for each platform, USD 189 for "Gold" version that had both the OS/2 and MS Windows version bundled and USD 995 one time payment and USD 395 per year for a site license. dbfREXX could also be bought in a bundle with dbfLIB for USD 329. Prices in the 1990's were higher than this.

Author

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
Retrieved from "https://www.edm2.com/index.php?title=DbfREXX&oldid=79597"