Options

BigText data type

alien251alien251 Member Posts: 80
Is a BigText data type the only option I have for strings over 250 characters long?

Comments

  • Options
    ara3nara3n Member Posts: 9,256
    you can store it as blob.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    alien251alien251 Member Posts: 80
    Hello,

    Thank you for your reply! I should have been more specific about what I was doing. I don't want to store the data anywhere. I'm building an HTML formatted string that I'll use to send a notification message using the SMTP code unit. The string will get fairly large about 2000 characters. I'm using several data item events in a report to build the string. At the end of the report I'd like to send the email and include the string as the body of the email. Sounds simple enough but I'm feeling a little restriced in my data type choices and I'm very new to the environment. Any ideas? Is there another way to do email, maybe with templates? Also I'm limited by my license I don't have the developer granule.

    Thanks!!

    Dan
  • Options
    ara3nara3n Member Posts: 9,256
    yes NAV has this limitation especially when you are interfacing with COM objects. 1024 is the limit.

    You can use an array of strings if that makes it easier.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.