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?
SQLFetchScroll not returning results
Moderator: NorbertKrupa
-
- Newbie
- Posts: 5
- Joined: Wed May 22, 2013 8:25 pm
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: SQLFetchScroll not returning results
What error are you getting?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Newbie
- Posts: 5
- Joined: Wed May 22, 2013 8:25 pm
Re: SQLFetchScroll not returning results
The bindings on all the columns is successful. But the first call to SQLFetchScroll returns -1.
Re: SQLFetchScroll not returning results
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:21 pm, edited 1 time in total.
-
- Newbie
- Posts: 5
- Joined: Wed May 22, 2013 8:25 pm
Re: SQLFetchScroll not returning results
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.
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.