Integra for Notes Banner
  QuickReports Integra4Notes Integra Family of Products



Notes error: Adding entry will cause text list to exceed 64K. Entry not added when using category field formulae

When running a profile using category formulae, Integra will save the category field formula result of every exported document in an array. Running this profile over a large number of documents causes the array to grow above 64K in size which exceeds the Lotus Notes limitation for arrays. If the category field formula will result in the same value across all the documents, then the following advanced script may be used to solve this problem
Const CB_INITIALISE = 3
Const CB_ACTIONONLY = 16
Const CB_BFOREXPORT = 10
Const CB_INVALID = 12
Const CB_CATEGORY = 13
Const CB_TOTAL = 14
Const CB_CONFLICT = 15
Const CB_BFORREADNOTES = 6
Const CB_BFORWRITECOM = 1
Const CB_AFTERWRITECOM = 9
Const CB_BFORCOMACTION = 5
Const CB_BFORNOTESACTION = 2
Const CB_TERMINATE = 4

select case stats.cbstatus
case CB_INITIALISE
case CB_ACTIONONLY
case CB_BFOREXPORT
case CB_INVALID
case CB_CATEGORY
case CB_TOTAL
case CB_CONFLICT
case CB_BFORREADNOTES
case CB_BFORWRITECOM

Dim v as Variant
v = ArrayUnique(stats.category, 5)

Redim stats.category(Ubound(v)) As String

For x = Lbound(v) To Ubound(v)
      stats.category(x) = v(x)
Next

end select

.




FAQ# 0237
Bookmark and Share

 
QUICK LINKS
 
 

 

  © Shireburn Software Ltd. 2008 - 2024