to update a dbf file

[Anon]

sorry for my english, i'm french!

I use dbase_replace-record() to update my dbf files, but i don't achieve :
- one time, my fields are null
- other time, it close my toolkit (wap toolkit) saying it is an error from PHP.EXE

$dbase_identifier = dbase_open("test.dbf",2);
$date = date ("Ymd");
$record = array($date, "super", 25, "[e-mail]", 1);
dbase_replace_record($dbase_identifier, $record, 2);
dbase_close($dbase_identifier);

thank,
lucie

[smarlowe]

I just had a chance to try and update a dbf file via the built in dbf support, and every update/insert resulted in a record full of nulls, and nothing I could do would allow me to insert/update data.

I am running php 4.0.4.pl1. I haven't tried 3.0.xx to see if the dbf support still worked back then or not. It could be the version of the dbf file I was using (later model vfoxpro file) that cause my problems.

[Anon]

i have found a solution : delete the record and add a new record, instead of update. Take care to use dbase_pack() after you've deleted to take into account your changes.

lucie

[smarlowe]

Hey, I'll try that. Up til now we've been letting the old hands at foxpro handle all that stuff... :⁾ Thanks