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
