PDA

View Full Version : Extended VirtualTable support coming in Lianja App Builder RC5.2



barrymavin
2013-04-03, 02:30
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
2013-04-03, 11:09
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