Difference between revisions of "Virtual Table Properties"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 50: | Line 50: | ||
|valign=top|maxrecords|| | |valign=top|maxrecords|| | ||
|- | |- | ||
− | |valign=top|nodata||Open without loading data: nodata=1 | + | |valign=top|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]] classes (from v4.1). |
|- | |- | ||
|valign="top"|nosupportsoffset||Enable nosupportsoffset: nosupportsoffset=1 | |valign="top"|nosupportsoffset||Enable nosupportsoffset: nosupportsoffset=1 |
Revision as of 10:39, 5 February 2018
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. Note: this can also be set using object.setNamedParameter("nodata", "false"). The setNamedParameter() method is available on the Section, CursorAdapter and Cursor 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.