I have an Image field on SQL Server 6.5 . An OLE bound control on my VFP 5.0a (SP3) manages the .bmp from the image field, using a remote view. I can add and save new records. If a user choose to put in a .bmp, I just use Append General into the remote view, and TABLEUPDATE(), that's OK.
If a user choose NOT put in a .bmp, I use TABLEUPDATE() without Append General so other fields of the record are sent to the back, it is still ok.
However, I cannot later reload the image-less record. The OLE bound control will complain that the OLE object is invalid or corrupted.
I tried on the SQL Server both to allow or not allow NULL for the image field. The problem remains. I think I should put something as default in the image field, but what should I put?
Pleas help
Chen
Chen Nan