Virtual Table Properties
From Lianjapedia
Revision as of 12:02, 21 July 2016 by Yvonne.milne (Talk | contribs)
Under Construction
See Also
ALTER VIRTUALTABLE, CREATE VIRTUALTABLE, CursorAdapter, Virtual Tables, Virtual Tables - Further Configuration and Troubleshooting, Virtual Tables - Local Development, Remote Deployment
Property | Description |
---|---|
allowupdate | |
autosync | |
basetable | Name of the remote table. |
concatwhere | |
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 | Enable keepalive: keepalive=1 |
keyfieldlist | |
maxrecords | |
nodata | Open without loading data: nodata=1 |
nosupportsoffset | Enable nosupportsoffset: nosupportsoffset=1 |
pagination | Enable pagination: pagination=1 |
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 | |
rowid | Enable rowid: rowid=1 |
supportslimit | |
supportsoffset | |
table | |
translatename | Disable translation of remote table name (underscore to dot): translatename=false |
ttl | |
updatenamelist | |
updatefieldlist | Comma-separated list of fields that can be updated. |
username | |
wheretype |