-
thanks Barry,
still migrating ... it is an enterprise system VFP, LAN + desktop apps. There are VTs (about 250) in the database used by users and the data is on an SQL server. In addition to the VTs in the database, some applications use custom (different per user) tables. These are defined by the VFP applications in a (temporary) database (created in the user's home directory) with the create sql view ... command (which is the same as the Lianja's create virtualtable ... command).
-
You can create virtualtables and tables in another database like this from the console or in your own code.
Code:
create|alter virtualtable database!table ...
create|alter table database!table ...
If you create tables like this you need to REBUILD DATABASE afterwards to be able to see them with DIR.
I have made some minor changes in the next 6.4 beta to support "free" virtual tables and free tables.
Code:
create|alter virtualtable c:\yourdir\table ...
create|alter table c:\yourdir\table ...
These are created where you want them to be created and not added into the database container.