Virtual Table Properties
From Lianjapedia
Revision as of 12:19, 1 August 2016 by Yvonne.milne (Talk | contribs)
Under Construction
See Also
| 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 |
| 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 |
