ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Managing xBase files
  • Known limitations
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
xBase files: Limits
Native Connectors (Native Accesses)Available only with this kind of connection
Known limitations
  • The long names are not supported by the xBase files.
  • Maximum number of records per data file:
unlimited
  • Maximum number of opened xBase files:
1024
  • Maximum number of controls per file:
- dBase 4 file:
255
- DBX file:
512
- Clipper5 file:
1.023
- other:
128
  • Maximum size of a record:
- Clipper5 file:
8.192
- other:
4.000
  • Maximum size of a text control:
- Clipper5 file:
2.048
- other:
254
  • Maximum size of a numeric control:
- dBase 4 file:
20
- FoxPro file:
20
- other:
19
  • Maximum size of a decimal numeric control:
- dBase 4 file:
18
- FoxPro file:
18
- other:
15
  • Maximum number of records per index file:
unlimited
  • Maximum size of a key:
100
  • Maximum length of a key expression:
100
  • Functions allowed in the key expressions:
    • DTOC
    • DTOS
    • LEFT
    • RIGHT
    • STR
      In Clipper, a size must be specified.
    • SUBSTR
    • UPPER
    • LOWER
  • Maximum number of indices in an MDX file (dBase 4 index file):
47
  • Maximum number of records per memo file:
unlimited
  • Maximum size of a text memo (editable):
24 KB
  • Maximum size of a control name:
10
  • Maximum size of a key name:
10
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help