Virtual tables and VFP image files

[barrymavin]

Hi Simon

In 7.1 I have made a lot of performance improvements with oledb as well as fixing up and working round various VFP oledb driver issues which I stumbled upon.

Memos are working well in both desktop and web, even in the data workspace. Full CRUD in the data workspace and sections is also working well in 7.1.

VFP varbinary fields are also handled by Lianja but the VFP oledb driver does not handle them consistently I.e it does not correctly return an image. What i have found is that it returns the name of the image stored in the varbinary field but that image is not to be found on the disk.

You can test this yourself in VFP outside of oledb.

open database northwind
use employees
copy memo photo to filename
type filename.txt

You will see:

EmpID1.bmp

NOTE - In VFP you're not allowed to read the varbinary or general field content. You can bind it to an olebound control and print it in a report via an olebound report control and that's it. This is not a Lianja issue.

This is why I asked you how are you storing images in VFP as Lianja has much better support for the storage and retrieval of images across desktop and web apps.