General questions

doubtfiredoubtfire Member Posts: 60
Two questions.
How to get the LENgth of a text (BigText/Text) field ?
How to check a text (BigText/Text) field whether is empty or NULL?
Thank you.

Comments

  • nunomaianunomaia Member Posts: 1,153
    // Length

    BigTextVAR.LENGTH;

    If length is 0 then is empty
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • doubtfiredoubtfire Member Posts: 60
    Merci!
    I have another question.
    If I have a cursor, how could I replace that "LENGTH" into it in order to get the length of the cursor's field?
  • nunomaianunomaia Member Posts: 1,153
    Sorry, I didn’t understood your last question.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • doubtfiredoubtfire Member Posts: 60
    Sorry for being not clear.
    My question is if I have a cursor, how I can get the length of a field of that cursor.
    Another question, what is the difference between ".LENGTH" and "STRLEN"?
    Merci, monsieur!
Sign In or Register to comment.