px_get_field(3) [debian man page]

PX_GET_FIELD(3) 					     Library Functions Manual						   PX_GET_FIELD(3)

NAME

       PX_get_field -- Returns single field definition in Paradox file

SYNOPSIS

       #include <paradox.h>

       pxfield_t *PX_get_field(pxdoc_t *pxdoc, int fieldno)

DESCRIPTION

       Returns	the  meta  data  of  the  field  with  the  given  number  in  a Paradox file. The first field has number 0, the last one has num-
       ber_of_fields-1. pxfield_t is defined as

       typedef struct px_field pxfield_t;
       struct px_field {
       char *px_fname;
       char px_ftype;
       int px_flen;
       int px_fdc;
       };

       The meaning of px_ftype is as following:

       Values and meaning of px_ftype

       Value							  Meaning
       pxfAlpha 						  T{
       Character string with a maximum of px_flen charackters.
       T}
       pxfDate
       pxfShort 						  Short interger (16 Bit)
       pxfLong							  Long Integer (32 Bit)
       pxfCurrency
       pxfNumber
       pxfLogical
       pxfMemoBLOb
       pxfBLOb
       pxfFmtMemoBLOb
       pxfOLE
       pxfGraphic
       pxfTime
       pxfTimestamp
       pxfAutoInc
       pxfBCD
       pxfBytes 						  Array of bytes.

RETURN VALUE

       Returns pointer to field on success and NULL on failure.

SEE ALSO

       PX_get_record(3), PX_get_fields(3)

AUTHOR

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

																   PX_GET_FIELD(3)

PX_INSERT_RECORD(3)					     Library Functions Manual					       PX_INSERT_RECORD(3)

NAME

       PX_insert_record -- Inserts a new record in the Paradox file

SYNOPSIS

       #include <paradox.h>

       int PX_insert_record(pxdoc_t *pxdoc, pxval_t **dataptr)

DESCRIPTION

       Inserts a new record stored in the array dataptr 	into a Paradox file. The position of the record will be determined by the function
       itself, starting at the beginning of the file and searching towards the end for a free slot. A free slot can be the result of former  calls
       of  PX_delete_record(3) or not completely filled data blocks in the input file. If there is no free slot within the file, then a new record
       will be added at the end.

       Blobs will be automatically written if a blob file was set with PX_set_blob_file(3).

       The memory for dataptr and the field values can be freed after PX_insert_record has been called.

       Each single element in the array of pointers to pxval_t can be easily created with MAKE_PXVAL(pxdoc_t *pxdoc, pxval_t *val)	       and
       setting the actual value afterwards. A quite common way to build up the record is the following:

       dataptr = (pxval_t **) malloc(PX_get_num_fields(pxdoc)*sizeof(pxval_t *));
       MAKE_PXVAL(pxdoc, dataptr[0]);
       dataptr[0]->type = pxfLong;
       dataptr[0]->value.lval = 45;
       dataptr[1]->type = pxfAlpha;
       dataptr[1]->value.str.val = "test";
       dataptr[1]->value.str.len = 4;
       PX_insert_record(pxdoc, dataptr);
       free(dataptr[0]);
       free(dataptr[1]);
       free(dataptr);

       There is currently no need to set the type, though it is recommended.

       The field types pxfMemoBLOb and pxfFmtMemoBLOb are treated like strings.

       Fields  of  type pxfAutoInc are automatically incremented if its value is set to NULL. In such a case the value is taken from the header of
       the database. You should not have more than one field of type pxfAutoInc in your database, otherwise the automatic incrementation will  not
       work.

RETURN VALUE

       Returns the record number on success or -1 on failure. The number of the first record is 0.

SEE ALSO

       PX_retrieve_record(3), PX_delete_record(3), PX_update_record(3)

AUTHOR

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

															       PX_INSERT_RECORD(3)