File Size : 2 GB
Records per File : Limited to the file size (see below).
Record Size : 15,000 bytes
Field Size : 15,000 bytes
Fields per Record : 15,000
Keys/Indexes per File: 240
Key Size : 15,000 bytes
Memo fields per File: 255
Memo Field Size : 64,000 bytes
BLOB fields per File: 255
BLOB Size : Hardware dependent (Max size 640 MB)
Open Data Files : Operating system dependent
Table Name : 1,000 bytes
Tables per DOS File : Limited only by the maximum DOS file size–approximately 2^32 bytes (4,294,967,296).
Concurrent Users per File: 1024
Yes Mark is correct - the 2GB limit includes blob data. Try to exceed 2GB and the file will be corrupted.
I seem to recall that in the early versions of CW the help incorrectly stated that the file size was limited only by the operating system so I was a bit surprised when I hit the hard limit. (I recently moved house and unfortunately turfed out all my old Clarion manuals etc as space was now at a premium so I cannot definitively confirm that). I remember I had to work overnight to come up with a scheme where one logical file was split between many physical files so the client was up and running the next morning. Of course these days you would probably use one of the SQL file systems that does not have such limits.