Select fron a vfp table that is not part of a database

[josipradnik]

Hi David,

In the link I mentioned there is an interesting post regarding VFPOLEDB.
Don't know what was result, but interesting alternative maybe for quick and dirty work, if you don't have ODBC driver installed yet...

---------
Q:
I know vfpoledb is really just activex.. Are there any issues using vfpoledb to connect to my vfp tables and doing updates... I'm going to be running parallel with our old system... I was told that lianja itself can open vfp tables and update them, however, the indexes don't update...
A:
I have not tried it but if you install the vfpoledb driver then in Lianja;

SET DEBUG ON
vfpda = createObject("OLEDB.Connection")

I'd be interested to see if it loads and what is in debug_client.txt
-----

Josip