The Vertica Database Forums

Hi,
I am facing a strange situation. I have bound 240 columns and when I try to use SQLFetchScroll to fetch the results, it errors out. However, when I reduce the number of bound columns to 230, it works fine. Is there some sort of a limit I am reaching?

What error are you getting?

The bindings on all the columns is successful. But the first call to SQLFetchScroll returns -1.

Hi!

[DELETED]

So I figured out the cause of the problem. I was providing a NULL for StrLen_or_Ind

in SQLBindCol( SQLHSTMT StatementHandle,
SQLUSMALLINT ColumnNumber,
SQLSMALLINT TargetType,
SQLPOINTER TargetValuePtr,
SQLLEN BufferLength,
SQLLEN * StrLen_or_Ind);

I figured it out by using SQLGetDiagRec to print the actual message.