Virtual Table Properties
From Lianjapedia
Revision as of 05:39, 4 January 2021 by Yvonne.milne (Talk | contribs)
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 base table to be used for insert, update and delete operations When combining data from multiple tables using a join you need to specify this and the updatefieldlist described below. |
concatwhere | To have the existing WHERE clause included in pagination: concatwhere=1 |
convertuint | Set to 1 to correct the ODBC interpretation of BIT fields in MySQL: convertuint=1. From v6.0. |
database | |
datasourcehost | |
datasourceoptions | Specify database specific options, e.g.: datasourceoptions=SQL_ATTR_PACKET_SIZE:102410. From v6.0. |
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. |
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 |
translatequeryfunc | Specify a function to be called to translate a native Lianja SQL WHERE condition for a target SQL database syntax. The function is called with two arguments: cWhereCondition, cDBtype. It should reside in the database container, e.g. : translatequeryfunc=yourFunc. From v6.0. |
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 inserted or updated. Prefix a field with a - to exclude it and use * to select all remaining fields. e.g. -custid,-custballance,* |
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.