Difference between revisions of "Virtual Table Properties"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "''Under Construction'' {| class="wikitable" width="100%" !width="30%"|Property||width="70%"|Description |- |valign=top|basetable||Name of the remote table. |- |valign="top"|d...") |
Yvonne.milne (Talk | contribs) |
||
| Line 3: | Line 3: | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
!width="30%"|Property||width="70%"|Description | !width="30%"|Property||width="70%"|Description | ||
| + | |- | ||
| + | |valign=top|allowupdate|| | ||
| + | |- | ||
| + | |valign=top|autosync|| | ||
|- | |- | ||
|valign=top|basetable||Name of the remote table. | |valign=top|basetable||Name of the remote table. | ||
| + | |- | ||
| + | |valign=top|concatwhere|| | ||
| + | |- | ||
| + | |valign=top|database|| | ||
| + | |- | ||
| + | |valign=top|datasourcehost|| | ||
| + | |- | ||
| + | |valign=top|datasourceoptions|| | ||
| + | |- | ||
| + | |valign=top|datasourcehost|| | ||
|- | |- | ||
|valign="top"|dbtype||The dbtype can be: lianja | mssql | mysql | oracle | postgres | vfp. | |valign="top"|dbtype||The dbtype can be: lianja | mssql | mysql | oracle | postgres | vfp. | ||
| Line 16: | Line 30: | ||
|- | |- | ||
|valign="top"|keepalive||Enable keepalive: keepalive=1 | |valign="top"|keepalive||Enable keepalive: keepalive=1 | ||
| + | |- | ||
| + | |valign=top|keyfieldlist|| | ||
| + | |- | ||
| + | |valign=top|maxrecords|| | ||
|- | |- | ||
|valign="top"|nosupportsoffset||Enable nosupportsoffset: nosupportsoffset=1 | |valign="top"|nosupportsoffset||Enable nosupportsoffset: nosupportsoffset=1 | ||
|- | |- | ||
|valign="top"|pagination||Enable pagination: pagination=1 | |valign="top"|pagination||Enable pagination: pagination=1 | ||
| + | |- | ||
| + | |valign=top|password|| | ||
|- | |- | ||
|valign="top"|precision||Specify precision for float fields (default is 2): precision=N | |valign="top"|precision||Specify precision for float fields (default is 2): precision=N | ||
| + | |- | ||
| + | |valign=top|quotestring|| | ||
|- | |- | ||
|valign="top"|rowid||Enable rowid: rowid=1 | |valign="top"|rowid||Enable rowid: rowid=1 | ||
| + | |- | ||
| + | |valign=top|supportslimit|| | ||
| + | |- | ||
| + | |valign=top|supportsoffset|| | ||
| + | |- | ||
| + | |valign=top|table|| | ||
|- | |- | ||
|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|ttl|| | ||
| + | |- | ||
| + | |valign=top|updatenamelist|| | ||
|- | |- | ||
|valign="top"|updatefieldlist||Comma-separated list of fields that can be updated. | |valign="top"|updatefieldlist||Comma-separated list of fields that can be updated. | ||
| + | |- | ||
| + | |valign=top|username|| | ||
| + | |- | ||
| + | |valign=top|wheretype|| | ||
|- | |- | ||
|} | |} | ||
Revision as of 10:45, 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 | |
| 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 |
