Hello,
Information about ct_get_data() can be found here:
http://infocenter.sybase.com/help/index.jsp?topic=3D/com.sybase.dc32840_1500=
/html/ctref/CHDGIEJF.htm
Basically what this error is telling you is that the application is
calling ct_get_data() on column 2
but has likely called ct_bind() on column 3. From the manual:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Only those columns following the last bound column are available to
ct_get_data. Data in unbound
columns that precede bound columns is discarded. For example, if an
application selects column
numbers 1=964 and binds column numbers 1 and 3, the application cannot
use ct_get_data to retrieve
the data for column 2, but can use ct_get_data to retrieve the data
for column 4.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
So if you were to change your select statement to something like the
following it should not be a problem:
select Business_unit_id, Open_market, Picture from QUOTEDTL22
I'm not sure how you would reorder the select statement if this is
Replication Server raising the error.
Maybe redefine the table such that the text/image column is listed
last?
Thanks,
Neal
|
