HALLOGRAM PUBLISHING
SHOPPING CARTSITE MAPCONTACT USPRODUCTS
HOMEBARCODESDEVELOPER TOOLSUSER TOOLSTRAINING
RaSQL for Clipper

With RaSQL for Clipper you can

    bullet Take advantage of the new, lightening-fast Btrieve 6.15 with its' legendary data integrity.

    bullet Use the RDD to access Btrieve files with the same commands and function you use to access DBF files.

    bullet Create custom screens and reports for any of the wide range of vertical-market applications that use Btrieve. These include Platinum, Macola, Great Plains, PeachTree, Champion, Forest & Trees, SaleMake, DacEasy, TeleMagic...even Compuserve Navigator!

    bullet Speed up your networked application with client-server indexes and filters without having to use SQL.

    bullet Convert between Btrieve and Clipper data types automatically without performing any conversions.

    bullet Practically eliminate the problem of not-enough-file- handles.

    bullet Create Btrieve-for-Windows application without incurring the overhead and limitations of ODBC.


System Requirements || RDD Function List || Library Function List ||
Btrieve Function List || Xtrieve Function List


System Requirements

Clipper versions Library supports CA-Clipper S'87 and 5.x. RDD supports Clipper 5.x
Btrieve versions Btrieve 5.x, 6.x and -for-Windows: standalone or networked
Xtrieve DDF files are supported but not required.
Linkers Supports all popular Clipper Linkers including RTLink & Blinker. 100% overlayable.
DOS Extenders Exospace, Blinker (Dual or Protected mode), Causeway. Generate Windows EXEs with Clip4Win and FiveWin.
DGROUP Required Approx 1K.

Back to list of options


RDD Function List*

N_XDEFEXT() Set the default file type N_XDELSKIP() Force RaSQL to make the next record current after DELETE()
N_XHARDWRITE() Speeds up APPEND BLANK N_XMEMOWIDTH() Set the maximum length of a variable length field
N_XVIA() Specify the default RDD

* Since the RDD primarily uses standard Clipper commands and functions, the RaSQL functions used with the RDD are comparatively few.

Back to list of options


Library Function List

N_XAPPEND() Append into current table from specified table N_XBOF() Determine if pointer is at top of table
N_XCLOSE() Close table in current area, or all tables N_XCLRBUF() Clear all fields in current record buffer
N_XDBF() Get name of Btrieve file open in current area N_XDEC() Get number of decimal positions in specified field
N_XDELETE() Delete current row in current table N_XDNLOAD() Download current table to specified DBF Table
N_XEOF() Determine if row pointer is beyond the end of current table N_XERRLVL() Set RaSQL/B error handling mode
N_XERRMSG() Get text error message by passing error number N_XERROR() Get error code from most recent function
N_XFCOUNT() Get number of fields in the current table N_XFETCH() Store value from field(s) into specified memory variable(s)
N_XFIELD() Get Nth field name in current table N_XFOUND() Determine if exact match was foundfrom N_XSEEK()
N_XGATHER() Move data from array to record in table N_XGOTOBOT() Move pointer to last row of current table
N_XGOTOTOP() Move to top of current table N_XGOTO() Move record pointer to specified physical record position
N_XINSERT() Insert new record into current table N_XLASTREC() Get number of records in current table
N_XLEN() Get display length of specified field N_XNUM() Get the number of the specified field in current table
N_XORDER() Set order to specified index number N_XRASQL() Verify the RaSQL library name
N_XRECNO() Determine current record position N_XRECSIZ() Get display record size
N_XREPLACE() Replace field(s) in current record buffer with specified data N_XRLOCK() Lock current record
N_XSCATTER() Move data from current record into an array N_XSEEK() Retrieve record by index key
N_XSELECT() Select Btrieve table N_XSKIP() Move up or down sequentially incurrent table
N_XSLEN() Get internal, stored length of specified field N_XSOFTSEEK() Turn soft seek On or Off Softseek
N_XSRECCON() Get raw stored record contents as a string N_XSRECSIZ() Get internal, stored length of record
N_XTYPE() Get Btrieve data type of specified field N_XUNLOCK() Release most recent N_XRLOCK in current table or all tables
N_XUPDATE() Write data into table, overwriting current record N_XUPLOAD() Upload a DBF to the current table
N_XUSE() Open Btrieve file in current area N_XZAP() Delete all records in current table

Back to list of options


Btrieve Function List (for RDD and library)

N_XAMAKENDX() Add a supplemental index to a table N_XAMAKETBL() Create table from specified arrays or string definitions
N_XCOLLATE() Specify user-defined collating sequence N_XDROPNDX() Remove supplemental index
N_XFILTER() Create client-server filter N_XFRECSIZ() Get length of fixed length portion of record
N_XINDEXKEY() Get field list for specified index number N_XINDEXTYPE() Get attributes of a specified index
N_XLOGIN() Log program into Btrieve N_XLOGOUT() Log out user from Btrieve
N_XMAKEDBF() Create extended structure DBF from current table N_XMAKENAME() Get valid Clipper field name from Btrieve field name
N_XMAKENDX() Create a supplemental index for the currently open table N_XMAKETBL() Create table from extended structure DBF
N_XMEMOLEN() Get length of variable length field in current record N_XNORESET() Suppress Btrieve reset operation at start of program
N_XOPENMODE() Set specific mode for opening tables N_XOWNER() Set/get owner for opening/creating tables
N_XPACK0C() Specify sign flag for packed decimal (money) fields N_XPAGEMAX() Get maximum pagesize for the current Btrieve configuration
N_XPAGESIZE() Set page size for tables created with N_XAMAKETBL() N_XPATH() Set default path for Btrieve data files
N_XSAFETY() Set overwrite safety on or off N_XSEEKEQ() Seek exact match
N_XSEEKGE() Find key greater than or equal to specified value N_XSEEKGT() Find key greater than specified value
N_XSEEKLE() Find key less than or equal to specified value N_XSEEKLT() Find key less than specified value
N_XSETALLOC() Pre-allocate disk space for a file N_XSETFLAGS() Set Btrieve file definition flags
N_XTRANCAN() Cancel (rollback) transaction N_XTRANOFF() Stop transaction
N_XTRANON() Start transaction N_XVERSION() Returns Btrieve or RaSQL version information

Back to list of options


Xtrieve Function List for users of DDF files*

N_XATABLE() Store Xtrieve dictionary table names in an array N_XCVTYPE() Get an Btrieve data type from a RaSQL type code, or vice versa
N_XDSTRUCT() Returns file structure string from currently open DBF N_XFMAP() Get Btrieve filename associated with an Xtrieve table
N_XFSTRUCT() Returns XTRIEVE file structure N_XVARSTRU() Define variant definition for current Btrieve file

*RaSQL supports DDF files but, unlike many other Btrieve add-ons, does not require them.

Back to list of options


RaSQL for Clipper FAQ
RaSQL for FoxPro
RaSQL for FoxPro Function List
RaSQL for FoxPro FAQ
RaSQL Tech Support


RaSQL/B
RaSQL/B 2.5 for FoxPro - WEB only Knowledgebase $695
RaSQL/B 2.1 for Clipper - WEB only Knowledgebase $695


Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404

SEARCH
14,500+ PRODUCTS:

Order RaSQL

SIMILAR PRODUCTS
  • File Access Components
  • Database Tools
  • Data Modeling Database Design

  • OTHER PRODUCTS
  • Netlib 6.5 for VFP
  • Netlib
  • Y2KFOX

  • PRODUCTS FOR
  • MS-Access
  • ActiveX/OCX Controls
  • C/C++
  • Clipper
  • dBASE
  • Delphi
  • FoxPro/VFP
  • Java
  • Macintosh
  • Oracle
  • Paradox
  • PowerBuilder
  • Visual Basic
  • Visual Objects

  • Keystone Training Videos

  • Copyright ©2001 HALLoGRAM Publishing, Aurora CO. All Rights Reserved
    All products mentioned in this site are trademarks of their respective owners
    Prices are subject to change without notice
    dmcakegkim