Difference between revisions of "System Capacities"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
''Under construction'' | ''Under construction'' | ||
| + | |||
| + | ==Fields and Variables== | ||
| + | |||
| + | [[Data Types]] | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
| Line 7: | Line 11: | ||
|valign="top"|Maximum character variable size||valign="top"|64 KB | |valign="top"|Maximum character variable size||valign="top"|64 KB | ||
|- | |- | ||
| − | | | + | |} |
| + | |||
| + | ==Tables and Indexes== | ||
| + | |||
| + | {| class="wikitable" width="100%" | ||
| + | !width="35%"|Feature||Capacity | ||
|- | |- | ||
| − | |valign="top"|Maximum | + | |valign="top"|Maximum table size||valign="top"|2^64 bytes |
| + | |- | ||
| + | |valign="top"|Maximum number of columns in a table||valign="top"|256 | ||
| + | |- | ||
| + | |valign="top"|Maximum memo/object file size||valign="top"|2^64 bytes | ||
| + | |- | ||
| + | |valign="top"|Maximum index file size||valign="top"|2^64 bytes | ||
|- | |- | ||
|valign="top"|Maximum index key length||valign="top"|192 characters (index keys have an 8 character unique value postfixed, giving 200 characters in total). | |valign="top"|Maximum index key length||valign="top"|192 characters (index keys have an 8 character unique value postfixed, giving 200 characters in total). | ||
| Line 15: | Line 30: | ||
|} | |} | ||
| + | ==Identifiers== | ||
| + | {| class="wikitable" width="100%" | ||
| + | !width="35%"|Feature||Capacity | ||
| + | |- | ||
| + | |valign="top"|Maximum procedure name length||valign="top"|32 characters | ||
| + | |- | ||
| + | |valign="top"|Maximum variable name length||valign="top"|32 characters | ||
| + | |- | ||
| + | |} | ||
| + | |||
| + | ==Programs, Procedures and Commands== | ||
| + | |||
| + | {| class="wikitable" width="100%" | ||
| + | !width="35%"|Feature||Capacity | ||
| + | |- | ||
| + | |valign="top"|Maximum Lianja/VFP command length||valign="top"|16 KB | ||
| + | |- | ||
| + | |valign="top"|Maximum SQL SELECT statement length||valign="top"|8 KB | ||
| + | |- | ||
| + | |} | ||
| + | |||
| + | ==Others== | ||
| + | |||
| + | {| class="wikitable" width="100%" | ||
| + | !width="35%"|Feature||Capacity | ||
| + | |- | ||
| + | |valign="top"| ||valign="top"| | ||
| + | |- | ||
| + | |valign="top"| ||valign="top"| | ||
| + | |- | ||
| + | |} | ||
[[Category:Lianja Scripting Essentials]] | [[Category:Lianja Scripting Essentials]] | ||
Revision as of 08:38, 26 August 2014
Under construction
Contents
Fields and Variables
| Feature | Capacity |
|---|---|
| Maximum character variable size | 64 KB |
Tables and Indexes
| Feature | Capacity |
|---|---|
| Maximum table size | 2^64 bytes |
| Maximum number of columns in a table | 256 |
| Maximum memo/object file size | 2^64 bytes |
| Maximum index file size | 2^64 bytes |
| Maximum index key length | 192 characters (index keys have an 8 character unique value postfixed, giving 200 characters in total). |
Identifiers
| Feature | Capacity |
|---|---|
| Maximum procedure name length | 32 characters |
| Maximum variable name length | 32 characters |
Programs, Procedures and Commands
| Feature | Capacity |
|---|---|
| Maximum Lianja/VFP command length | 16 KB |
| Maximum SQL SELECT statement length | 8 KB |
Others
| Feature | Capacity |
|---|---|
