Results 1 to 2 of 2

Thread: Extended VirtualTable support coming in Lianja App Builder RC5.2

  1. #1
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,301

    Extended VirtualTable support coming in Lianja App Builder RC5.2

    I've been busy fixing tickets that have been reported as well as adding some finishing touches.

    VirtualTables have now been extended to use the following syntax:

    Code:
    CREATE VIRTUALTABLE tablename 
        [IF NOT EXISTS] 
        CONNSTR "odbc_dsn" 
        [PRIMARYKEY 'column'] 
        [PROPERTIES 'prop=value;...'] 
        [AS select_statement]
    The primarykey column if specified will be used to update data e.g. WHERE primarykey = value

    The properties is a ; separated list of name=value pairs corresponding to cursoradaptor properties. This therefore allows you to switch databases in the connection string.
    Last edited by yvonne.milne; 2013-04-04 at 05:39. Reason: TABLE and ALIAS clauses removed as no longer required - these are handled automatically
    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

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,079
    This is HUGE for being able to create once, and run everywhere, meaning any backend. This will make ISV's very happy: we can develop entirely against Lianja SQL Server, and then run wherever the customers insists we run. Thanks!

    Hank

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