Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldBox » Errors exporting notes in Goldbox 2010-A
Post new topic  Reply to topic View previous topic :: View next topic 
Errors exporting notes in Goldbox 2010-A
PostPosted: Tue Feb 22, 2011 4:39 pm Points: 0 Reply with quote
lisa_at_aeg
n00b
Joined: 22 Feb 2011
Posts: 2




I'm having issues exporting history notes from Goldmine. I am getting a "Database Engine Error: Invalid BLOB handle in record buffer"
View user's profile Send private message

PostPosted: Tue Feb 22, 2011 8:13 pm Points: 1 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




It's the BLOBS TO CACHE setting. click on the Database in the BDE and change. Number you put in there is the max number of records returned when a Blob type field is included in a SQL Query. If it exceeds, however, you'll usually get an error, Invalid BLOB Handler..

The max setting is 65535, If you are trying to return more non-Empty Notes fields than that, you'll need to devise a filter that will enable you to break the data into 2 or more exports.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

Errors exporting notes in Goldbox 2010-A
PostPosted: Wed Feb 23, 2011 10:42 am Points: 0 Reply with quote
lisa_at_aeg
n00b
Joined: 22 Feb 2011
Posts: 2




that seemed to work! It's now exporting. Thanks!
View user's profile Send private message

PostPosted: Wed Feb 23, 2011 10:43 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




Glad to be of help.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

Errors exporting notes in Goldbox 2010-A
  ContactReview Forum Index » GoldBox
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin