Insertion of text in code type field in small case

chrispaulchrispaul Member Posts: 174
Dear All

Is there any possibility that we can insert some text in code type field in small case as code type field inherits some property which automatically converts a text in Uppercase.

Thanks in advance

Comments

  • David_SingletonDavid_Singleton Member Posts: 5,479
    MyCode := UPPERCASE('abcde');
    David Singleton
  • DaveTDaveT Member Posts: 1,039
    Hi Chrispaul,

    Unfortunately not, a code field by definition is uppercase. You will need a text field to store the lower case.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • David_SingletonDavid_Singleton Member Posts: 5,479
    Actually rereading th eoriginal post (which wold be easier if there was some punctutation :whistle: ) I think DaveT's reply is more acurate.
    David Singleton
  • jlandeenjlandeen Member Posts: 524
    why are you trying to insert lower case in a code field? Code fields HAVE to be uppercase - so you may want to dig a little deeper into the client requirement and see if this really is "must have functionality".
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.

    http://www.epimatic.com
  • GertjeGertje Member Posts: 1
    You can insert lower case letters in a code field by declaring a TextConst that has lower case characters and assigning that to a code field. This will cause problems in your DB so please do not use this in a production environment.
    This was/is a well known bug in some of the codeunits that initialize the different journals in NAV.

    So, it can be done, but I wouldn´t recommend it.

    br/Gertje
Sign In or Register to comment.