Difference between revisions of "Virtual Table Properties"

From Lianjapedia
Jump to: navigation, search
Line 2: Line 2:
  
 
==See Also==
 
==See Also==
[[ALTER VIRTUALTABLE]], [[CREATE VIRTUALTABLE]], [[CursorAdapter]], [[Virtual Tables]], [[Virtual Tables - Further Configuration and Troubleshooting]], [[Virtual Tables - Local Development, Remote Deployment]]
+
* [[ALTER VIRTUALTABLE]]
 +
 
 +
* [[CREATE VIRTUALTABLE]]
 +
 
 +
* [[CursorAdapter]]
 +
 
 +
* [[Virtual Tables]]
 +
 
 +
* [[Virtual Tables - Further Configuration and Troubleshooting]]
 +
 
 +
* [[Virtual Tables - Local Development, Remote Deployment]]
  
 
{| class="wikitable" width="100%"
 
{| class="wikitable" width="100%"

Revision as of 12:03, 1 August 2016

Under Construction

See Also

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 remote table.
concatwhere To have the existing WHERE clause included in pagination: concatwhere=1
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 Synonym of primarykey. Used to uniquely identify the row.
maxrecords
nodata Open without loading data: nodata=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
ttl
updatenamelist
updatefieldlist Comma-separated list of fields that can be updated.
username Connection username
wheretype