Re: # of items in a select

[Chris Snow <chris_snow@EMAIL.MSN.COM>]

This is a known limitation in the Maximo/SQR3 dynamic $where clause link.
The limitation is 254 characters in the $where clause.  Supposedly, the
problem has been corrected in the latest patch, however I have not had a
chance to test it yet.  Patch 02 is available on the Maximo user's web site.

-----Original Message-----
From: Randle Boyd <rboyd@RUAN.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: June 03, 1998 12:16 PM
Subject: # of items in a select


Greetings,

We are using NT4, Oracle 7.3, Sqr 3, and Maximo 3.x.

we are having a problem with some of our reports.  The problem is length
of the $where statement generated by Maximo when the selected records
option is chosen.

By choosing 'selected records when running a report from Maximo, Maximo
uses an 'IN' in the select statement

ex.     select xxxx from yyyy
        where ddd in ('a1', 'a2', 'a3', ....., 'an')

as opposed to an '=' for current record or no input.

The 'IN' statements work fine with up to 12 items included
        ... where ddd in ('a1', 'a2', 'a3' ....., 'a12')

But once we have 13 items in the 'IN' statement, we get 'SQR 3722
Couldn't set up cursor.

Does anyone have an idea of what is causing this, or how to fix it?


Thanks in Advance,
Randle
Ruan Transportation
(515) 245-2493