Virtual Table Properties

From Lianjapedia
Revision as of 11:08, 1 August 2016 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Under Construction

See Also

ALTER VIRTUALTABLE, CREATE VIRTUALTABLE, CursorAdapter, Virtual Tables, Virtual Tables - Further Configuration and Troubleshooting, Virtual Tables - Local Development, Remote Deployment

Property Notes
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