Continue Script

skyzvoir0001 — Wed, 11 Dec 2019 23:12:57 GMT

Hi, so i have a main table (main_dt) which i am going to update (update_dt). However, there are times when update_dt is empty. How do i make it such that the script continues to run? What function do i use for it to continue?

Re: Continue Script

Jeff_Perkinson — Thu, 12 Dec 2019 01:21:48 GMT

@skyzvoir0001 wrote:

Hi, so i have a main table (main_dt) which i am going to update (update_dt). However, there are times when update_dt is empty. How do i make it such that the script continues to run? What function do i use for it to continue?

There are a number of ways to ensure that your script handles potential problems. Here are two ways that you might deal with your situation of a data table with no rows causing a problem.

Try() - The Try() function allows you to attempt something that might not work and recover gracefully. In your case you could surround your << Update() with a Try(). This would allow your script to continue if the << Update() message throws an error.
If() - The If() conditional allows you to test whether a condition is true before executing other statements. So, you can check whether update_dt is empty before doing the <<Update().

When you say that "update_dt is empty," it's not clear whether you mean that the data table doesn't have any rows or that the variable update_dt has no value. Which you mean makes a difference in how you would check for that condition in the If(). If you mean that the data table doesn't have any rows you can use the N Rows() function. Alternatively, the Is Empty() or Is Missing() functions will test whether a JSL variable doesn't have a value.

topic Re: Continue Script in Discussions

Continue Script

Re: Continue Script