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.

[HankFay]

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