Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: temporary VT?

  1. #11
    Senior Member
    Join Date
    Oct 2012
    Posts
    234
    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).

  2. #12
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,714
    Blog Entries
    17
    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.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us