Two ideas come to mind. 1) Use server side cursors if available. 2) If only
reading the data, and if I am not mistaken, you need to go through Allbase
to get to Turbo Image with the SE product. Set up views to only the part of
the data you are seeking and have your client use those views instead of the
actual table.
Some products don't allow you to write to a view, thus the restriction of
read-only. When you have client side cursors all the data is scanned and
brought to the client for local processing, while server side cursors keep
the processing at the server and thus you only get the results of your
query.

James

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of ALBERT KARMAN
Sent: Wednesday, November 17, 1999 12:43 PM
To: [log in to unmask]
Subject: SQL error


We're using ODBC-SE from MB Foster for a TurboIMAGE DB which has some
sizable detail sets.
The environment is HP 3000 Series 967/200, MPE/iX C.55 PP7

When we run queries from the client and f you select only a few columns, but
select them from tables which
have, in total, more than 1024 coilumns, you get error
SELECT LIST CONTAINS MORE THAN 1024 COLUMNS ( DBERR 2406 ).

HP's logging this as a problem, but until they get back to us (yeah, yeah,
the Cubs'll win eventually too!)....
ANY thoughts/workarounds, etc????

TIA,

Al Karman
IT Consultant
Administrative Management Group
[log in to unmask]
847.870.9288