I'm using a current timestamp that is populated in a backend helper program to figure out if a current user is already logged in to my system or not. Once it determines if they are already logged in, it loads data from a data source using the vvin_virtual syntax in SQL, the issue arises when I try to set an app variable with the value of the timestamp.
Because the setAppVar prototype only accepts character input, I have to convert the timestamp to char and then pass it. but once I try to compare that to a timestamp column in the data source and proceed to the preview it simply says "Invalid SQL Statement." I've tried using SQL CONVERT() and CAST() on the main column to convert it to a char, but both of those return an error saying "SQL0104 - Token ( was not valid. Valid tokens: )." Below is my current SQL statement, any help would be appreciated.
Because the setAppVar prototype only accepts character input, I have to convert the timestamp to char and then pass it. but once I try to compare that to a timestamp column in the data source and proceed to the preview it simply says "Invalid SQL Statement." I've tried using SQL CONVERT() and CAST() on the main column to convert it to a char, but both of those return an error saying "SQL0104 - Token ( was not valid. Valid tokens: )." Below is my current SQL statement, any help would be appreciated.
Comment