A year ago we had a fine debate on the this topic as well. See http://www.navision.net/forum/link.asp?TOPIC_ID=117 I was wondering if any progress has been made in the area. Have anyone been looking into this problem in Navision Solutions? Best regards, Erik P. Ernst, webmaster Navision Online User Group
In Navision Solutions the text field is expanded to 1024 characters. Still not the optimal solution. But hopefully the In-/Outstream methods implemented can take care of some of these issues. Best regards, Soren Nielsen, moderator Navision Online User Group
At your suggestion, we’ve implemented the use of a blob field, instream/outstream and the 1K field - It works quite well. It also avoids the use of a lines table too. Edited by - simonw on 2002 Mar 27 14:39:45
Simon, Would you mind sharing with the group exactly how you made use of the Blob field? Have you had success in storing and editing text this way? Best regards, Mark. Mark Keener Automated Number Crunching Dayton, OH USA
We use the blob field to capture user notes on interactions. When I’ve got a bit more time, I’ll see if I can construct a test object. The 1k text field is used to show the current memo contents & to allow edit (via assist edit) which has multi-line set to yes This is the code to convert a memo to the text //!LogEntryGetMemo() LogEntry.CALCFIELDS(Memo); LogEntry.Memo.CREATEINSTREAM(MemoInStream); MemoInStream.READTEXT(tmpText); CRLF[1] := 13; CRLF[2] := 10; WHILE tmpText <> ‘’ DO BEGIN MemoText += tmpText + ‘’; MemoInStream.READTEXT(tmpText); END; Here is the code which is called after the external memo control has been run IF isOK THEN BEGIN LogEntry.Memo.CREATEOUTSTREAM(MemoOutStream); CLEAR(LogEntry.Memo); CLEAR(codeField); nLines := MemoOCX2.LineCount; FOR i:=1 TO nLines DO BEGIN MemoOCX2.LineNo := i; lineText := MemoOCX2.LineText; insertLine := TRUE; IF IsHeaderLine(lineText, dateField, codeField) THEN BEGIN IF STRLEN(lineText) = 0 THEN // don’t insert if no other text on this line insertLine := FALSE; END; IF insertLine THEN BEGIN lineText += crlf; MemoOutStream.WRITETEXT(lineText); END; LogEntry.MODIFY; END; END; Hope this gives you some clues
quote:
Originally posted by SNielsen: In Navision Solutions the text field is expanded to 1024 characters.
Are you sure the maximum size for text fields is 1024 chars? Last time I checked, only text vars were capable of holding this much data. Fields were still limited to a mere 250 chars. 
Kind regards, Jan Hoek Weha Automatisering BV Woerden - The Netherlands
The memo text field is a form global variable - Name DataType Subtype Length MemoText Text 1024 Also, this is on Attain GB 3.01.B
I have seen something, that would use notepad is US. I even belive he told me, that it was a gimmick that could be downloaded from the US Partner Website, but I am not sure. I have the code (Wich isn’t much), but since I haven’t done it my self, I need to talk to the guy who did it before I can upload it to the download forum. (Hmm Upload to Download - Almost like “I can’t stand sitting!” Otherwise there have to be a few ideas to borrow from Relationship Managment, that integrates with word. //Henrik Helgesen -: KISS::Keep it Simple, Stupid :- Edited by - hhelgesen on 2002 Mar 27 21:09:47
Recently I have come across the issue that if I put a large text variable (found to be over about 400 chars by trial and error) in a text box in a report, when I run that report I get an application error which kills the Navision session. This was in Attain SQL 3.01. Has anyone else encoutered this? Do you know if it happens on forms too? Nikolai L’Estrange Developer