Difference between revisions of "Virtual Table Properties"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 15: | Line 15: | ||
* [[Virtual Tables - Local Stored Procedures]] | * [[Virtual Tables - Local Stored Procedures]] | ||
+ | |||
+ | * [[SET CONNSTR]] Command (default 'ODBC Connection') | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" |
Revision as of 11:01, 7 February 2018
Under Construction
See Also
- SET CONNSTR Command (default 'ODBC Connection')
Property | Notes |
---|---|
allowupdate | Allow updates: allowupdate=1 |
autosync | Keep the local and remote cursor data in sync as changes are made multi-user: autosync=1 |
basetable | Name of the remote table. |
concatwhere | To have the existing WHERE clause included in pagination: concatwhere=1 |
database | |
datasourcehost | |
datasourceoptions | |
datasourcehost | |
dbtype | The dbtype can be: lianja | mssql | mysql | oracle | postgres | vfp.
This makes connections faster as Lianja does not need to use heuristics to determine the remote database type. |
debug | Enable debugging: debug=1 |
fetchasneeded | Enable fetchasneeded: fetchasneeded=1 |
fetchsize | Specify fetchsize: fetchsize=N |
keepalive | Keep the ODBC connection alive when the request completes: keepalive=1 |
keyfieldlist | Synonym of primarykey. Used to uniquely identify the row. |
maxrecords | |
nodata | Open without loading data: nodata=1. Note: this can also be set using object.setNamedParameter("nodata", "false"). The setNamedParameter() method is available on the Section, CursorAdapter and Cursor Framework Classes (from v4.1). |
nosupportsoffset | Enable nosupportsoffset: nosupportsoffset=1 |
pagination | Enable pagination: pagination=1 |
password | Connection password |
postfixwhere | Enable postfixwhere: postfixwhere=1. The WHERE clause will be applied to the resultset. |
precision | Specify precision for float fields (default is 2): precision=N |
quotestring | The quotestring property is used to handle CRUD statements containing embedded ' characters. This should be set according to the requirements of the backend SQL engine. e.g. to replace single quotes by two single quotes for MSSQL: create virtualtable vtmssql_table properties "quotestring='';..." or to replace single quotes by \' for MSSQL: create virtual table vtmysql_table properties "quotestring=\';..." |
rowid | Enable rowid: rowid=1 |
supportslimit | Specify that the backend database engine supports the LIMIT keyword: supportslimit=1 |
supportsoffset | Specify that the backend database engine supports the OFFSET keyword: supportsoffset=1 |
table | |
translatename | Disable translation of remote table name (underscore to dot): translatename=false |
ttl | Specify TTL: ttl=N. Used with keepalive=1, connections are released after the TTL has expired. Default is 30 which causes them to be released after 30 minutes. |
updatenamelist | |
updatefieldlist | Comma-separated list of fields that can be updated. |
username | Connection username |
wheretype |
A property that is unrecognized, e.g. mypar=myvalue, will be added as a "named parameter" and will be the default value to be substituted if no setNamedParameter("mypar", "myvalue") is specified. The setNamedParameter() method is available on the Section, CursorAdapter and Cursor Framework Classes. From v4.1.