Extended VirtualTable support coming in Lianja App Builder RC5.2

[barrymavin]

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:

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.