string-counter comparison

Post Reply
tboyer
Posts: 68
Joined: Mon Aug 28, 2006 4:43 pm

string-counter comparison

Post 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?
User avatar
Kai
Site Admin
Posts: 1263
Joined: Tue Apr 25, 2000 1:27 pm

string-counter comparison

Post by Kai »

What full version of Texis is this (output of texis -version)?
tboyer
Posts: 68
Joined: Mon Aug 28, 2006 4:43 pm

string-counter comparison

Post by tboyer »

7.02.1401386359 20140529

moving FROM texis 6.01.1342668004
User avatar
Kai
Site Admin
Posts: 1263
Joined: Tue Apr 25, 2000 1:27 pm

string-counter comparison

Post by Kai »

Can reproduce it here; looks like a bug. Open a tech support ticket, we'll let you know when it is fixed.
tboyer
Posts: 68
Joined: Mon Aug 28, 2006 4:43 pm

string-counter comparison

Post by tboyer »

ok thanks
Post Reply