px_get_record

px_get_record -- Returns record of paradox database

Description

array px_get_record (resource pxdoc, int num [, int mode])

Returns the num'th record from the paradox database. The record is returned as an associated array with its keys being the field names. mode can be PX_KEYTOLOWER or PX_KEYTOUPPER in order to convert the keys into lower or upper case. If mode is not passed or is 0, then the key will be exactly like the field name. The element values will contain the field values. NULL values will be retained and are different from 0.0, 0 or the empty string. Currently only values for fields of type PX_FIELD_ALPHA, PX_FIELD_SHORT, PX_FIELD_LONG, PX_FIELD_AUTOINC, PX_FIELD_NUMBER, PX_FIELD_CURRENCY and PX_FIELD_LOGICAL are supported. Fields of unsupported type will not be part of the array. This means, that the return value of px_num_fields() may differ from the number of elements in the array returned by this function.

The record number is an artificial number counting records in the order as they are stored in the database. The first record has number 0.