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)