INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Btrieve Status 103

Btrieve Status 103

(OP)
I am having this error (the chunk offset is too big) when using a LongVarChar field in my btrieve table. I created the table using the Create Table Wizard in Pervasive V8, and selected the advanced settings option. If the field is empty i am getting the error like when I try to access the table for the first time. Please help.       

RE: Btrieve Status 103

When dealing with Btrieve vs ODBC/SQL, a status 103 usually means that the DDFs don't match the data files.  
Are you trying to create a DDF definition for an existing Btrieve file?  If so, you should know that the LongVarChar/LongVarBinary and the LVAR/NOTE are different structures.  THe LongVarChar/LongVarBinary are stored as an 8 byte integer in the fixed length portion of the record as a pointer to the end of the record.  NOTE\LVAR fields are stored as the actual data at the end of the fixed length record (which is why you can have only one NOTE or LVAR in a table).

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Btrieve Status 103

(OP)
I am trying to create a DDF for a new Btrieve file. I am using Delphi 2006 to populate the data file, plus other 3rd party database aware components. I have one LongVarChar field and when i try to access the file for the first time (that field is empty) I am getting the Btrieve status 103 message. If I enter some data in that field, the error clears but recurs when i try to access another record that has no data in that field.  

RE: Btrieve Status 103

What interface are you using to access the Pervasive data (PDAC, BDE, Btrieve API, ODBC, ADO, etc)?  
Do you get the error if you access the record using the Pervasive Control Center?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Btrieve Status 103

(OP)
Hi,
I am using Titan and Delphi 2006 to access my data, and no, I am not getting the error if I open the file in PCC.  

RE: Btrieve Status 103

Ahh.. That's the problem.  I don't believe Titan has been updated to support the LongVarChar/LongVarBinary field.  I believe it only supports the old Note/LVAR style fields which are considered legacy.  

Have you tried PDAC (http://www.pervasive.com/developerzone/access_methods/pdac.asp)?  
They are VCL components similar to Titan but support the LongVarChar/LongVarBinary.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Btrieve Status 103

(OP)
Thanks,
A research on Titan shows Titan Version 10 for Delphi 2006 supports CLOB (type code 21). My thinking is that it would recognize my LongVarChar since its also type code 21. I have not tried PDAC but thanks for the info.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close