VI. Paradox File Access

Introduction

Note: You will need to get the paradox library (libpx) available at http://pxlib.sourceforge.net.

Note: This module has not been tested on other platforms than Debian/GNU Linux for PPC.

Note: This module is also in development and may change, though I don't expect major changes to the API.

Table 1. Contants for field types

Name	Meaning
PX_FIELD_ALPHA	Character data with fixed length
PX_FIELD_DATE	Date
PX_FIELD_SHORT	Short integer (2 Bytes)
PX_FIELD_LONG	Long integer (4 Bytes)
PX_FIELD_CURRENCY	same as PX_FIELD_NUMBER
PX_FIELD_NUMBER	Double
PX_FIELD_LOGICAL	Boolean
PX_FIELD_MEMOBLOB	Binary large object (not supported)
PX_FIELD_BLOB	Binary large object (not supported)
PX_FIELD_FMTMEMOBLOB	Binary large object (not supported)
PX_FIELD_OLE	OLE object (basically a blob, not supported)
PX_FIELD_GRAPHIC	Graphic (basically a blob, not supported)
PX_FIELD_TIME	time
PX_FIELD_TIMESTAMP	timestamp (like the unix timestamp)
PX_FIELD_AUTOINC	Auto incrementing interger (like PX_FIELD_LONG)
PX_FIELD_BCD	Decimal number stored in bcd format (not supported)
PX_FIELD_BYTES	Array of Bytes with not more than 255 bytes (not supported)

Table 2. Contants for file types

Name	Meaning
PX_FILE_INDEX_DB	Indexed database
PX_FILE_PRIM_INDEX	Primary index
PX_FILE_NON_INDEX_DB	None indexed database
PX_FILE_NON_INC_SEC_INDEX	None incremental secondary index (not supported)
PX_FILE_SEC_INDEX	Secondary index (not supported)
PX_FILE_INC_SEC_INDEX	Incremental secondary index (not supported)
PX_FILE_NON_INC_SEC_INDEX_G	(not supported)
PX_FILE_SEC_INDEX_G	(not supported)
PX_FILE_INC_SEC_INDEX_G	(not supported)

Table 3. Methods of class paradox_doc

Table of Contents
px_new -- Create a new paradox object
px_open_fp -- Open paradox database
px_create_fp -- Create a new paradox database
px_close -- Close a paradox database
px_delete -- Deletes resource of paradox database
px_get_record -- Returns record in paradox database
px_put_record -- Stores record into paradox database
px_numrecords -- Returns number of records in a database
px_numfields -- Returns number of fields in a database
px_get_schema -- Returns the database schema
px_get_field -- Returns the specification of a single field
px_set_targetencoding -- Sets the encoding for character fields (deprecated)
px_set_parameter -- Sets a parameter
px_get_parameter -- Gets a parameter
px_set_value -- Sets a value
px_get_value -- Gets a value
px_set_tablename -- Sets the name of a table (deprecated)
px_get_info -- Return lots of information about a paradox file