| Errors exporting notes in Goldbox 2010-A | |
Posted: Tue Feb 22, 2011 4:39 pm |
Points: 0 |
|
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" |
|
|
|
|
Posted: Tue Feb 22, 2011 8:13 pm |
Points: 1 |
|
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. |
|
|
|
| Errors exporting notes in Goldbox 2010-A | |
Posted: Wed Feb 23, 2011 10:42 am |
Points: 0 |
|
lisa_at_aeg |
n00b |
|
|
Joined: 22 Feb 2011 |
Posts: 2 |
|
|
|
|
|
|
|
|
that seemed to work! It's now exporting. Thanks! |
|
|
|
|
Posted: Wed Feb 23, 2011 10:43 am |
Points: 0 |
|
BobTaylor |
GoldBox Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1216 |
Location: Jacksonville, FL |
|
|
|
|
|
|
|
|
_________________ Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|