Field Size more than 250 characters ?

NAVKING
Member Posts: 9
Navision has a limit on using 250 characters within a text field, Is there a way round this so that we could use more characters ?
0
Comments
-
Since Version 4 , you can use BigText variable. Maximum size is then 2Gb ! See version 4 doc for details ...0
-
You could create several text fields, each 250 characters wide. Then you could create functions to get and set the text, and use a variable to display the text on forms. Users won't be able to filter on that column, though.
Another approach, which is even more complex but allows you to store gigabytes of text, is a BLOB field.
Otherwise, I think the 250 character limit on fields really is part of the client and cannot easily be circumvented.
HalMdy, that sounds interesting. I think I'll take a look soon!Kind regards,
Jan Hoek
Product Developer
Mprise Products B.V.0 -
Waldo wrote:... Or you can use WaldoNavPad from the download section ... \:D/
About the BigText ...
I understood this could only be used for streaming (XMLPorts ...) ... . You can't display the text in a message, for instance...
That was my understanding too. Textboxes on forms can show up to 1000 characters (I'm doing it since v3.01), but still do that inline editing when trying to edit the field (how anoying! *lol*). And reports cannot display more that 250 characters in a textbox in the sections else it'll crash. Those are the limitations as I know them, but I've not really tried pushing them further in the v4.0 database yet (even though they are supposed to remain the same as v3.70).Kristopher Webb
Microsoft Dynamics NAV Developer0
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