calculate field using "left()" function

Originally Posted 6 July 2011, 1:36 am EST

  • Originally Posted 6 July 2011, 1:36 am EST

    Within the schema Designer, I am trying to create a calculated field in a table using the string function left without success.

    The calculation expression I am trying to create is : left([field1],2)

    I get the "invalid variable left" message.

    Can you use these type of functions in the calculate expression? Is there an alternate way to achieve the same?
  • Reply


    Can you check the link below for the same where it elaborates the use of calculated fields

    Also you may check the referred sample at

    C:UsersstduserDocumentsComponentOne SamplesTrue DataControl 8.0TutorialsTutor04

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels