Skip site navigation (1) Skip section navigation (2)

last question.. sorry

From: Matthias Weinert <confusingness(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: last question.. sorry
Date: 2005-09-05 02:21:00
Message-ID: 431BAB8C.7040409@gmx.de (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm afraid, I know that i'm getting on your nerves, sorry... :(

I'm sure that you have written tons of MFC code with
CDatabase/CRecordset which uses cursors. In short words:
Database with > 20000 rows (and blobs in it), i want to use cursors to
fetch them in batchs (when the user wants to see the next batch).
But CRecordset::Open(....) always tries to get the complete statement :(

Already tried wild stuff like a simple copy from dbcore..
AFX_ODBC_CALL(::SQLExecDirect(m_hstmt, reinterpret_cast<SQLTCHAR
*>(pszSQL), SQL_NTS));
after some conversions, but of course this did not work... :)

Would be very kind if you mention some links or something like that.
(limit offset statements work, but it's not really nice...). code would
be great (for sure u wrote tons of it).

Thanks for answers...
Matthias Weinert

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2005-09-05 04:57:18
Subject: Re: Continuing encoding fun....
Previous:From: Dave PageDate: 2005-09-04 18:20:57
Subject: Re: savepoint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group