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.

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