interbase blob update

[lgiancri]

hi!
I'm trying to UPDATE a record in an Interbase table using PHP4, but I haven't found a solution yet. Is there anybody who can kindly help? Thanks
Luigi

[[deleted]]

I supppose you tried an UPDATE query and got some sort of error?

[lgiancri]

Well, yes I tried and got an InterBase error message, then session stopped. I knew it would not work because you can't access blob fields directly. In fact Jouni Ahto and Andrew Avdeev (the two fellows to whom we owe the InterBase functions of PHP) wrote nine (undocumented, but stable [at least as far as I know]) functions for accessing blob fields. The same is stated in the Programmer's guide of Borland InterBase Server. One possible solution is to
1) create a new Blob;
2) update the row and set the blob field in the row to the new blob.
The old blob data will be actually erased when InterBase perfoms cleanup.
If you can find any other solution, please do not hesitate to let me know.
Thanks luigi