Btrieve Error 22

[billiard]

In Pervasive 10.3 my INSERT script gives error

Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The data buffer parameter is too short(Btrieve Error 22)

How do I fix this ?

 

[mirtheil]

Sounds like your DDFs may not match the data file. Are the data files / DDFs from a third party application? If so, make sure the DDFs are correct and accurately describe the data files.
The status 22 is caused when a buffer specified is smaller than the Engine expects. If a field in the DDF is defined as a 100 byte character field but the Btrieve file defines a record of less than 100 bytes, the status 22 can occur.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[billiard]

How do I make sure the DDFs are correct and accurately describe the data files? When I insert a record do I have to assign values to all fields in a table?

 

[mirtheil]

You only have to specify values for fields that are defined "NOT NULL".
You can use the "Check Database" function in the DDF Builder tool to check the database. Here's a link to docs for v11 but they should apply for v10 too:
[URL unfurl="true"]http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=ddfbuilder/ddfb_gui.2.3.html#288453[/url]


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com