Difference between revisions of "Library Function Table"
From Recital Documentation Wiki
		
		
		
| Yvonnemilne  (Talk | contribs) | Yvonnemilne  (Talk | contribs)  | ||
| Line 2: | Line 2: | ||
| {| class="wikitable" | {| class="wikitable" | ||
| − | + | !FUNCTION||FILE||DESCRIPTION | |
| |- | |- | ||
| |[[dbakey()]]||ndx||Add key to index file | |[[dbakey()]]||ndx||Add key to index file | ||
Latest revision as of 15:03, 3 April 2009
The following table is a quick reference to all of the functions available in the RECITAL/Library. The file column lists the type of RECITAL files that the function works with, that is .DBF, .DBT, .NDX and/or .DBX files.
| FUNCTION | FILE | DESCRIPTION | 
|---|---|---|
| dbakey() | ndx | Add key to index file | 
| dbappend() | dbf | Append record to end of database file | 
| dbatofld() | dbf | Convert ASCII to numeric field | 
| dbatokey() | ndx | Convert ASCII to numeric/date key | 
| dbckey() | ndx | Obtain current key from index file | 
| dbclose() | dbf | Close a database | 
| dbcreat() | dbf | Create a new database | 
| dbcreatx() | dbf | Create a new database with field descriptions | 
| dbdcache() | dbf | Specify database cache size | 
| dbdelete() | dbf | Mark a data record deleted | 
| dbdo() | Execute a RECITAL program | |
| dbfield() | dbf | Extract field value | 
| dbfilemode() | dbf/ndx | Specify file operation mode | 
| dbfldtoa() | dbf | Convert numeric field to ASCII | 
| dbflush() | dbf | Flush I/O buffer cache for a database file | 
| dbfwd() | ndx | Position access pointer to the end of index file | 
| dbgather() | dbf | Returns field buffer data to the record buffer | 
| dbgcache() | dbf | Enables the distributed cache manager on OpenVMS | 
| dbgetf() | dbf | Obtain database information | 
| dbgetfx() | dbf | Obtain extra database information | 
| dbgetm() | dbt | Get memo from memo file | 
| dbgetnr() | dbf/ndx | Retrieve next data record by key | 
| dbgetpr() | dbf/ndx | Retrieve previous data record by key | 
| dbgetr() | dbf | Retrieve a data record | 
| dbgetrk() | dbf/ndx | Retrieve data record by key | 
| dbgetseqno() | dbf | Return the next sequence number | 
| dbicache() | ndx | Specify index cache | 
| dbiclose() | ndx | Close index file | 
| dbicreat() | ndx | Create an index file | 
| dbiflsh() | ndx | Flush I/O buffer cache for an index file | 
| dbiopen() | ndx | Open an existing index file | 
| dbkexpr() | ndx | Obtain index file information | 
| dbkeytoa() | ndx | Convert numeric/data key to ASCII | 
| dblockf() | dbf | Lock database file | 
| dblocki() | ndx | Lock index file | 
| dblockr() | dbf | Lock a record in a database file | 
| dbmclose() | dbt | Close memo file | 
| dbmcreat() | dbt | Create a memo file | 
| dbmemoformat() | dbt | Toggles memo input formatting | 
| dbmopen() | dbt | Open an existing memo file | 
| dbnkey() | ndx | Obtain next key | 
| dbonerror() | Enable/disable recovery from I/O errors | |
| dbopen() | dbf | Open an existing database | 
| dbpkey() | ndx | Obtain previous key | 
| dbputm() | dbt | Put memo in a memo file | 
| dbputr() | dbf | Insert record in database file | 
| dbputrk() | dbf/ndx | Add key to index file and insert record into database file | 
| dbrecall() | dbf | Recall deleted data record | 
| dbrecin() | dbf | Place contents of fields into buffers | 
| dbrecout() | dbf | Place contents of buffers into fields | 
| dbrewind() | ndx | Position access pointer to the top of index file | 
| dbrmvkey() | ndx | Remove key from index file | 
| dbrmvr() | dbf | Physically remove a data record | 
| dbrun() | Run an operating system command | |
| dbscatter() | dbf | Splits the record buffer into individual field buffers | 
| dbset() | Issues a Recital SET COMMAND | |
| dbsetseqno() | dbf | Set the sequence number in a table | 
| dbsize() | dbf | Obtain number of records in a database | 
| dbstrcpy() | Format string for fields and keys | |
| dbstring() | Convert non 'C' string to a 'C' null terminated string | |
| dbtkey() | ndx | Translate key to record number | 
| dbtlockf() | dbf | Test to see if a database is locked by another user | 
| dbtlockr() | dbf | Test to see if a record is locked by another user | 
| dbunlockf() | dbf | Unlock a database file | 
| dbunlocki() | ndx | Unlock a index file | 
| dbunlockr() | dbf | Unlock a record in a database | 
| dbupdm() | dbt | Update a memo in a memo file | 
| dbupdr() | dbf | Update a data record | 
| dbxakey() | dbx | Add keys to all tags in a tagged index file | 
| dbxckey() | dbx | Read current key | 
| dbxclose() | dbx | Close an open tagged index file | 
| dbxcreate() | dbx | Create a tag in a tagged index file | 
| dbxdroptag() | dbx | Drop the specified tag from a tagged index file | 
| dbxflsh() | dbx | Flush I/O buffer cache for a tagged index file | 
| dbxfwd() | dbx | Position access pointer to end of active tag | 
| dbxgetnr() | dbx | Get next data record by key in active tag | 
| dbxgetpr() | dbx | Get previous data record by key in active tag | 
| dbxgetrk() | dbx | Get data record by key in active tag | 
| dbxgoto() | dbx | Go to specified record number and reposition keys in tag | 
| dbxkexpr() | dbx | Get the key expression for a specified tag | 
| dbxlocki() | dbx | Lock tagged index file | 
| dbxnkey() | dbx | Read next key in active tag | 
| dbxnotags() | dbx | Return the number of tags in a tagged index file | 
| dbxopen() | dbx | Open a dbx index file | 
| dbxpkey() | dbx | Read previous key in active tag | 
| dbxrewind() | dbx | Position access pointer to beginning of active tag | 
| dbxrmvkey() | dbx | Remove key from all tags in tagged index file | 
| dbxtag() | dbx | Change the active tag | 
| dbxtkey() | dbx | Translate tag key to record number | 
| dbxunlocki() | dbx | Unlock tagged index file | 
| dbxupd() | dbx | Update all tags in the tagged index file for the specified record | 
