Catch exception in universal function? Answered

Cameron Scully

I have a crystal reports form with a universal function on the OK button so that it stores the 5 fields' info in SQL when it is printed. However, this form is used for all crystal reports and some don't have more than one field so when the macro executes @WoNum = $[$1000003.0.0] and it doesn't exist it throws an exception.

Is there a way to either check to see if an element like $[$1000003.0.0] exists before reading from it or the ability to catch the exception when it happens and recover from it?

Thanks

Comments

1 comment

Date Votes
  • Comment author
    Naama Aharoni
    • Official comment

    Hi Cameron,

    You can try and using if/else or case structure into your SQL or Macro to make sure a value exist before if is being transferred to the relevant variable,

    Thanks, Naam

Please sign in to leave a comment.