Re: ct_get_data() fails
- From: SybaseNeal <nstack21@xxxxxxxxx>
- Date: Tue, 27 May 2008 10:52:28 -0700 (PDT)
Hello,
Information about ct_get_data() can be found here:
http://infocenter.sybase.com/help/index.jsp?topic=/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:
===========================================================================
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–4 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.
===========================================================================
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
.
- References:
- ct_get_data() fails
- From: jitesh120
- ct_get_data() fails
- Prev by Date: ct_get_data() fails
- Next by Date: Re: Error 2580: unexpected key pointer to an overflow data page
- Previous by thread: ct_get_data() fails
- Index(es):
Relevant Pages
|
Loading