Difference between revisions of "Virtual Table Properties"

Revision as of 10:53, 14 June 2016

Under Construction

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

@@ Line 43: / Line 43: @@
 |-
 |valign=top|password||
+|-
+|valign=top|postfixwhere||Enable postfixwhere: postfixwhere=1.  The WHERE clause will be applied to the resultset.
 |-
 |valign="top"|precision||Specify precision for float fields (default is 2): precision=N