Difference between revisions of "Virtual Table Properties"
From Lianjapedia
Barrymavin (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 26: | Line 26: | ||
|- | |- | ||
|valign=top|concatwhere||To have the existing WHERE clause included in pagination: concatwhere=1 | |valign=top|concatwhere||To have the existing WHERE clause included in pagination: concatwhere=1 | ||
| + | |- | ||
| + | |valign=top|convertuint||Set to 1 to correct the ODBC interpretation of BIT fields in MySQL: convertuint=1. From v5.6. | ||
|- | |- | ||
|valign=top|database|| | |valign=top|database|| | ||
| Line 31: | Line 33: | ||
|valign=top|datasourcehost|| | |valign=top|datasourcehost|| | ||
|- | |- | ||
| − | |valign=top|datasourceoptions|| | + | |valign=top|datasourceoptions||Specify database specific options, e.g.: datasourceoptions=SQL_ATTR_PACKET_SIZE:102410. From v5.6. |
|- | |- | ||
|valign=top|datasourcehost|| | |valign=top|datasourcehost|| | ||
| Line 78: | Line 80: | ||
|- | |- | ||
|valign="top"|translatename||Disable translation of remote table name (underscore to dot): translatename=false | |valign="top"|translatename||Disable translation of remote table name (underscore to dot): translatename=false | ||
| + | |- | ||
| + | |valign="top"|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 v5.6. | ||
|- | |- | ||
|valign=top|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. | |valign=top|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. | ||
Revision as of 11:49, 30 November 2020
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 v5.6. |
| database | |
| datasourcehost | |
| datasourceoptions | Specify database specific options, e.g.: datasourceoptions=SQL_ATTR_PACKET_SIZE:102410. From v5.6. |
| 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 |
| 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 v5.6. |
| 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. From v4.1.
