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.