Moving to Texis 7 we are having a new problem comparing counter to blank.
where Profileid=$pid and Queryid = ''
or
where Profileid=$pid where the $pid is a blank.
Error is:
Could not assign type varchar to counter (FTN 66 to 19)
I can make the error go way by using convert, i.e. convert ('' , 'counter') or convert ($queryid, 'counter')
But we have a lot of places in our code that might be affected. I'm wondering, is there a compatibility setting that would let Texis 7 be permissive in these situations (as it is in Texis 6). Is it wise to do it or is it better to just clean up by writing in the converts?
where Profileid=$pid and Queryid = ''
or
where Profileid=$pid where the $pid is a blank.
Error is:
Could not assign type varchar to counter (FTN 66 to 19)
I can make the error go way by using convert, i.e. convert ('' , 'counter') or convert ($queryid, 'counter')
But we have a lot of places in our code that might be affected. I'm wondering, is there a compatibility setting that would let Texis 7 be permissive in these situations (as it is in Texis 6). Is it wise to do it or is it better to just clean up by writing in the converts?