I have a sub which I use to pass a string to create a table row in a table using DXL. The trouble is - is that if the text contains “&” I get a DXL import error saying “Expected entity name for reference”
I basically use the code below to create the row
stream.writetext {
} & calldate & {
}
I’m assuming that because the text contains the “&” when I call the .process method - its seems to think that I havent closed off the variable?
Is there something which I should be doing? At the moment to get around this all I am doing is checking if the “&” exists in the string and alter the string. Does anybody know if other characters cause this error.
Oh I get it now lol - I didnt quite get what Stan meant.
Thanks for that.
I accidentally posted a response in the wrong section of my last topic (row limit of 255) so Ill post it here-
Heres my other problem
I’m getting the error message “maxium number of memory segments that notes can support has been exceeded” when I try to script out a table with 1000+ rows (I’m breaking up the tables into 100s) Does anyone know what this message means? I think my notesstream is over 5mb when I call the dmp.process - would this be the problem? What should I do to avoid this?
Bram has mentioned that I should have at least a paragraph element between tables to avoid a crash and tables bigger than 64KB - so does this mean
or
Do you think this may contribute to this error?
Thanks for the help so far guys! I really appreciate it.
Subject: 6.x DXL Importer table implementation munches HANDLEs
The 6.x DXL Importer table implementation makes heavy use of HANDLEs, which are a limited resource that can be exhausted. We have rectified this problem in 7.0. It is unlikely to be addressed in 6.x because there were actually some major architectural changes in 7.0 that could not be simply backfilled to 6.x. Perhaps you could break the large table into multiple smaller tables with very little space between them to approximate what you want.