Select statement from existing VFP tables

[avianmanagement]

I want to continue using Xcase for my data modelling.

To create / update tables in my Lianja database I need to do a select statement from some of my Xcase dbf file, vfp files, and then I just work with that cursor for field info and add or update the Lianja tables using code.

Is there a way in Lianja that I can do a select statement against the vfp tables to do this without having to import them into Lianja tables first

[josipradnik]

Try VFP ODBC driver: https://www.lianja.com/community/sho...FP-ODBC-Driver

Also: https://lianjadeveloper.wordpress.co...p-odbc-driver/

[avianmanagement]

Thanks for that

With this work with free tables as there is no DBC involved with the Xcase tables I believe.

[barrymavin]

You can just open the VFP table with USE in your code.

[HankFay]

Hi David,

Yes, as Barry says you can USE. I USE with an alias, and having done that you can do whatever you want in terms of select statements.

Hank

[avianmanagement]

Thanks Barry and Hank, that was much easier than I expected.