Re: Witango-Talk: Issue With Tango 2K to Witango Migration

[Ben Johansen]

I have used parens in select statements in 2k thru latest. but the proper sql syntax is to use AS after the () expresssion example: (SSRRESV_SEATS_AVAIL - SSRRESV_WAIT_COUNT)  AS SSRRESV_REMAINING set up a custom column using the AS and it should be ok. Ben On Nov 8, 2006, at 11:48 AM, Andrew Stevenson wrote: Hi all:   We recently migrated from Tango2K 4.5.20 to WiTango 5.5.  Both are hosted on windows 2000 servers.  After the migration we noticed some search actions were behaving differently under WiTango.  For example, when the sql generated by a particular search is viewed through the editor, we see the following:   SELECT S1.SSRRESV_MAX_ENRL, S1.SSRRESV_ENRL, (SSRRESV_SEATS_AVAIL - SSRRESV_WAIT_COUNT) , S1.SSRRESV_SEATS_AVAIL, S1.SSRRESV_WAIT_COUNT FROM SATURN.SSRRESV S1 ...   This code executed perfectly under Tango2K.  But when the WiTango server executes this action, this is an example of the sql that is generated:   SELECT S1.SSRRESV_MAX_ENRL, S1.SSRRESV_ENRL, S1.SSRRESV_SEATS_AVAIL, S1.SSRRESV_WAIT_COUNT FROM SATURN.SSRRESV S1 ...   It appears WiTango is ignoring the part of the request in parentheses.  When I remove the parentheses from the select column, the code executes perfecly again (under Witango.)  Is it true then that WiTango doesn't accept parentheses in the search actions whereas Tango2K did?  Has anyone else run into anything like this? ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf