Tim,

Little expanded info on 07009 which is focusing on Column. Is there any chance that R2PAYEENO is all blanks, resulting in a null value after Trim?

*07*009 SQLBindCol Invalid descriptor index The value specified for the argument ColumnNumber exceeded the maximum number of columns in the result set.
*07*009 SQLDescribeCol Invalid descriptor index The value specified for ColumnNumber was equal to or less than 0. The value specified for the argument ColumnNumber was greater than the number of columns in the result set.


**************************************************************************************************

am doing the following:



remittype char(1) = "C";

getremitpayeelistrec getremitpayeelistrec[0];

sqlstr string = "SELECT concat(R2NAME, concat('
(',concat(trim(R2PAYEENO),')')) ) as namestr FROM RUIPGM2P";

prepare selectStatement from
sqlstr + " where r2type = ? order by namestr";

get getremitpayeelistrec with selectStatement using remittype;



and getting the following error:


>>>>ERROR acbsvc/getremitpayeelist EGL0504E GET: Descriptor index not
valid.[sqlstate:07009][sqlcode:-99999]

EGL0002I The error occurred in acbsvc processing the getremitpayeelist
function.



This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].