Automation, generating an error in the variable activity.
After installing the upgrade: Toad Data Point 126.96.36.1994, it generates an error setting a variable in a script that has been running just fine previously.
The error message: mismatched input '00' expecting ')' line nnn
It is occurring on a variable that references a previously defined variable.
For example, the first variable - p_start_dt - gets set as:
Round( add_days( last_day( add_months( current_date(), -2 ) ), 1 ) )
The next variable generates the error, and is defined as:
Issue fixed in version 4.0..1.
The latest version of Toad Data Point can be downloaded at the Support Portal.