px_create_fp -- Create a new paradox database


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

Create a new paradox database file. The actual file has to be opened before with fopen(). Make sure the file is writable. The first parameter is the return value of px_new(). 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.

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

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() and has been successfully opened by the Paradox software, but your milage may vary.

Return Values

Returns TRUE on success or FALSE on failure.


Example 1. Creating a Paradox database with two fields

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

© Copyright 2003-2023 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.