Page 1 of 1

string-counter comparison

Posted: Wed Aug 06, 2014 1:30 pm
by tboyer
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?

string-counter comparison

Posted: Wed Aug 06, 2014 1:47 pm
by Kai
What full version of Texis is this (output of texis -version)?

string-counter comparison

Posted: Wed Aug 06, 2014 1:50 pm
by tboyer
7.02.1401386359 20140529

moving FROM texis 6.01.1342668004

string-counter comparison

Posted: Wed Aug 06, 2014 2:57 pm
by Kai
Can reproduce it here; looks like a bug. Open a tech support ticket, we'll let you know when it is fixed.

string-counter comparison

Posted: Wed Aug 06, 2014 3:25 pm
by tboyer
ok thanks