|
| |
Knowledgebase
>>ITEM: R00038
>>DATE: March 26, 1996
>>TYPE: Information
>>TITLE: RaSQL/B structure definition errors - Btrieve error 22
>>PRODUCT(S):
RaSQL/B (all versions) for Clipper
RaSQL/B (all versions) for FoxPro DOS
RaSQL/B (all versions) for FoxPro Windows
>>PLATFORM(S):
Btrieve (all versions)
>>SUMMARY:
Program generates error 22 (buffer length too short) when opening
a Btrieve file or when accessing a record.
>>MORE INFORMATION:
>>RESOLUTION/FIX:
The following lists some of the more common causes of error 22.
 | Field names and field types should be upper case. For example:
12345678901234567890123456789012
"name c 36.00 ;" && wrong!
"NAME C 36.00 ;" && RIGHT! |
| The field type should be left-justified, for example:
12345678901234567890123456789012
"NAME C 36.00 ;" wrong!
"NAME C 36.00 ;" RIGHT! |
|
If there is variable length data at the end of a record, make
sure that it is accounted for with a memo field (type "M" or
"ML"). The specified length should be the maximum size memo
field you are expecting. For example, if the variable length
data can be up to 4K, add the following field to the end of the
structure:
12345678901234567890123456789012
"MEMO L 4096.00 ;"
NOTE: If the output of BUTIL -STAT includes "Variable Length:
Yes", then the file contains variable length data. |
| Each field in the structure string must be 32 characters. If
you are obtaining the structure from a text file (e.g., RQB file)
remember that CarriageReturn+LineFeed (CRLF) take up two
characters. The text file should occupy one line, do not break
it up with CRLF as this would make each line occupy 34
characters. |
>>EXAMPLE(S):
>>SEE ALSO:
>>COPYRIGHT 1997 Communication Horizons
All rights reserved worldwide.
No distribution without specific consent of publisher.
Knowledgebase
Top Home
| | |
|
