Hi Lianja Team,

I have an app containing approx 70 tables and 130+ local views.

This app started life in the Foxbase days, when Unix was supported, and was reluctantly ported to Windows at clients request, read insistence.
It now runs under VFP 9 SP2+.

At some stage, it shall be re-written to Lianja; imo the only REAL VFP alternative.

Lianja does not import a DBC's local and remote views.

The app's DBC has a few stored procedures, no triggers to speak of. No relationships have been specified; as parametrized views pull data in using the primary keys of the tables required.

I assume that it is possible in Lianja to replace a DBC's views with local and remote virtual tables.

Can someone knowledgeable please enlighten me?

Is it correct to assume that:
1. physical tables can be used in more than 1 virtual table?
2. it is possible to have virtual tables that contain columns from more than one table?

Is the FetchAsNeeded property of a virtual table, comparable to VFP's NoDataOnload? Meaning that virtual tables are only populated after a Requery?

What it boils down to, is that I have know how to work around the absence of views in order to be able to estimate the amount of work required to port the app to Lianja.

Any help is greatly appreciated.

Thanks!