Write to a BLOB type field in nav2015

kanika
Member Posts: 247
Hi experts!
I need to put a lot of text in fields of a new nav2015 table but in this version there are no BigText fields and the text is at most 250 characters. I have thought of using the BLOB fields but will not let me write the values just create them; In this version the TempBlob table has no function, I tried to copy the functions of the nav2017 WriteAsText and ReadAsText but they give compilation error.
I need that when you run the page the client can write the text in the Blob field.
Is there another way? How does this version manage the notes?
Thank you all very much.
I need to put a lot of text in fields of a new nav2015 table but in this version there are no BigText fields and the text is at most 250 characters. I have thought of using the BLOB fields but will not let me write the values just create them; In this version the TempBlob table has no function, I tried to copy the functions of the nav2017 WriteAsText and ReadAsText but they give compilation error.
I need that when you run the page the client can write the text in the Blob field.
Is there another way? How does this version manage the notes?
Thank you all very much.
0
Best Answer
-
Try something like this:
TempBlob.blob.createoutstream(OutStreamObj);
OutStreamObj.WRITETEXT ('First line of text that you want to write to text file');
OutStreamObj.WRITETEXT ('This is not the second line of text to be outputed but to concatenate with the first line');
OutStreamObj.WRITETEXT(); // This command is to move to next line
OutStreamObj.WRITETEXT('Second line will start here') ;
message('HasValue: %1',tempblob.blob.hasvalue);
5
Answers
-
Try something like this:
TempBlob.blob.createoutstream(OutStreamObj);
OutStreamObj.WRITETEXT ('First line of text that you want to write to text file');
OutStreamObj.WRITETEXT ('This is not the second line of text to be outputed but to concatenate with the first line');
OutStreamObj.WRITETEXT(); // This command is to move to next line
OutStreamObj.WRITETEXT('Second line will start here') ;
message('HasValue: %1',tempblob.blob.hasvalue);
5 -
TallyHo,
There is no WRITETEXT function in this release for an instream field
0 -
WRITETEXT is a function of OUTSTREAM, always has been, INSTREAM has READ onlySlawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-030 -
OK, I have it and I return that the BLOB field does have value. But how do I put the value on the page for the customer to see?
Outstreamobj has no function ReadAsText
-I do not understand why if a field is BLOB subtype bitmap You can put the image directly in the field when you run the table without code and for the memo no-0 -
WRITETEXT is a function of OUTSTREAM, always has been, INSTREAM has READ only0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions