Virtual Table Properties
From Lianjapedia
Revision as of 07:32, 14 June 2016 by Yvonne.milne (Talk | contribs)
Under Construction
| Property | Description |
|---|---|
| basetable | Name of the remote table. |
| 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 |
| nosupportsoffset | Enable nosupportsoffset: nosupportsoffset=1 |
| pagination | Enable pagination: pagination=1 |
| precision | Specify precision for float fields (default is 2): precision=N |
| rowid | Enable rowid: rowid=1 |
| translatename | Disable translation of remote table name (underscore to dot): translatename=false |
| updatefieldlist | Comma-separated list of fields that can be updated. |
