Results 1 to 5 of 5

Thread: Views Equivalent

  1. #1
    Member
    Join Date
    Sep 2013
    Location
    Bristol UK
    Posts
    95

    Views Equivalent

    Hi,

    We have two very large VFP tables each of which has over 250 columns. In order to facilitate migration from our legacy platform to the Lianja platform we would like to retain the current database and table structures as much as possible. In our current system we use a large number of views to make working with these tables easier.

    Does Lianja have an equivalent to local views?

    Can we use virtual tables linked to local Lianja tables to provide the equivalent of updateable views?

    I know that we can, of course, work directly with the tables and forgo local views so at this point I'm just trying to get a feeling for the Lianja design process.

    Cheers,

    Rob

  2. #2
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Hi Rob,

    Q:
    Something like local view on VFP...
    A:
    A VT can be created against a local table. Just specify "local" as the ODBC Connection and enter a SQL statement.

    Create a virtual table with a "local" DSN. That is proxied directly into the embedded database engine. It does not use ODBC nor talk to a remote server.
    Search "local view" in: http://www.lianja.com/community/show...-Virtual-table for more info.

    Josip

  3. #3
    Member
    Join Date
    Sep 2013
    Location
    Bristol UK
    Posts
    95
    Josip,

    Outstanding. Much Obliged.

    Cheers,
    Rob

  4. #4
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Virtual Table is low ("V") in alphabet, and I've just started to publish new collected articles in [Answers], beginning from "A".

    I can provide you a draft of future post about Virtual tables. It is not published on "Lianja developer", even not edited yet, but can help you with more recent info.
    Link to download it as PDF: https://lianjadeveloper.files.wordpr...ual-tables.pdf

    Josip
    Last edited by josipradnik; 2017-11-30 at 04:07.

  5. #5
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    Rob,

    Some additional info from the roadmap release notes.


    • Added a new attribute to the App Settings "Runtime database". This provides the ability to develop an App against "local" Virtual Tables (you can import these into a development database) and then when the App is generated as an HTML5 JavaScript Web/Mobile App the runtime database is used in production.


    • Added "Create Local Virtual Tables" to the database context menu. This causes a virtual table (name prefixed with vt_) to be created in the database for each native table and its connection string is set to "local".


    • "local" stored procedures are now supported for Virtual Tables. See this forum post for details.
    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

Tags for this Thread

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