px_retrieve_record(3) [debian man page]

PX_RETRIEVE_RECORD(3)					     Library Functions Manual					     PX_RETRIEVE_RECORD(3)

NAME

       PX_retrieve_record -- Returns record in Paradox file

SYNOPSIS

       #include <paradox.h>

       pxval_t ** PX_retrieve_record(pxdoc_t *pxdoc, int recno)

DESCRIPTION

       Returns the record with the given number in a Paradox file. The first record has number 0, the last one has number_of_records-1.

       If you are accessing several records, do it in ascending order, because this is the most efficient way.

       The return value is an array of field values. Each value is stored in a structure like the following:

       typedef struct px_val pxval_t;
       struct px_val {
       char isnull;
       int type;
       union {
       long lval;
       double dval;
       struct {
       char *val;
       int len;
       } str;
       } value;
       };

       The  element  isnull  is  set  to  1 if the value is NULL otherwise it is set to 0. type 	       is the type of the paradox field as
       defined in paradox.h.  A field value can be either a long int, a double or a string, depending on the paradox field type. The paradox field
       types  pxfShort,  pxfLong,  pxfDate,  pxfTime,  pxfLogical,  and  pxfAutoInc are returned as long int values.  pxfTimestamp, pxfNumber, and
       pxfCurrency are returned as double values and all remaining paradox field types are stored as strings with the length in value.len. You can
       rely on strings being Null terminated. Blobs are stored as string but are not guarented to be Null terminated.

       The  paradox  field  types  pxfTimestamp,  pxfTime,  an	pxfDate  use an uncommon format which can be converted into a string with PX_time-
       stamp2string(3), PX_time2string(3), and PX_date2string(3).

RETURN VALUE

       Returns a pointer on success and NULL on failure.

SEE ALSO

       PX_update_record(3), PX_timestamp2string(3), PX_time2string(3), PX_date2string(3)

AUTHOR

       This manual page was written by Uwe Steinmann uwe@steinmann.cx.

															     PX_RETRIEVE_RECORD(3)

PX_CREATE_FP(3) 														   PX_CREATE_FP(3)

px_create_fp - Create a new paradox database

SYNOPSIS

       bool px_create_fp (resource  $pxdoc, resource  $file, array  $fielddesc)

DESCRIPTION

	Create a new paradox database file. The actual file has to be opened before with fopen(3). Make sure the file is writable.

       Note

	      Calling this functions issues a warning about an empty tablename which can be safely ignored. Just set the tablename afterwards with
	      px_set_parameter(3).

       Note

	      This function is highly experimental, due to insufficient documentation of the paradox file format. Database files created with this
	      function can be opened by px_open_fp(3) and has been successfully opened by the Paradox software, but your milage may vary.

PARAMETERS

	      o $pxdoc
		- Resource identifier of the paradox database as returned by px_new(3).

	      o $file
		-File handle as returned by fopen(3).

	      o $fielddesc
		-  fielddesc is an array containing one element for each field specification. A field specification is an array itself with either
		two or three elements.The first element is always a string value used as the name of the field. It may	not  be  larger  than  ten
		characters.  The  second  element  contains  the  field type which is one of the constants listed in the table Constants for field
		types. In the case of a character field or bcd field, you will have to provide a third element specifying the length  respectively
		the  precesion of the field. If your field specification contains blob fields, you will have to make sure to either make the field
		large enough for all field values to fit or specify a blob file with px_set_blob_file(3) for storing the blobs.  If  this  is  not
		done the field data is truncated.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Creating a Paradox database with two fields

	      <?php
	      if(!$pxdoc = px_new()) {
		/* Error handling */
	      }
	      $fp = fopen("test.db", "w+");
	      $fields = array(array("col1", "S"), array("col2", "I"));
	      if(!px_create_fp($pxdoc, $fp, $fields)) {
		/* Error handling */
	      }
	      px_set_parameter($pxdoc, "tablename", "testtable");
	      for($i=-50; $i<50; $i++) {
		$rec = array($i, -$i);
		px_put_record($pxdoc, $rec);
	      }
	      px_close($pxdoc);
	      px_delete($pxdoc);
	      fclose($fp);
	      ?>

SEE ALSO

       px_new(3), px_put_record(3), fopen(3).

PHP Documentation Group 													   PX_CREATE_FP(3)