Changing the row status array used by SQLSetPos 
Author Message
 Changing the row status array used by SQLSetPos

I'm using VC++ 6.0 and SQL Server 7.0.  I am using BulkRow recordsets and am
wanting to reallocate my data buffers and status buffers on the fly.
Everything seems to be working fine except for the new status buffers.  When
I call SQLSetPos with either SQL_ADD or SQL_UPDATE, the operation seems to
work fine, but the status is not returned in my new status buffer (stored in
CRecordset::m_rgRowStatus).

I have investigated the use of the status buffer and believe that the
address of the buffer gets sent to the ODBC manager as part of
SQLExtendedFetch.  This buffer is later used by the Manager to report the
status of SQLSetPos operations like SQL_UPDATE and SQL_ADD.  What I want to
do is change the buffer after calling SQLExtendedFetch and prior to calling
SQLSetPos.  I have not been able to find a way of doing this.

The literature says we shouldn't be using SQLExtendedFetch, but rather use
SQLFetchScroll which was introduced in ODBC 3.  VC++ 6.0 is still using the
older functions.  Does anyone know of an easy way to take advantage of the
new functions or how to make SQLSetPos use the new status buffer?

Thanx for any input,
Anne



Tue, 06 Nov 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQLSetPos & Row Binding

2. SQLSetPos hangs when UPDATING rows

3. Can't update row data with SQLSetPos

4. Can't update row data with SQLSetPos

5. SQLSetPos & Row Binding

6. OptimisticBatchUpdate - Using RecordSet Status to check changes.

7. Help on Determining Failed Rows in Array Inser/Update using OCI

8. Help on Determing Failed Rows in Array Insert/Update using OCI

9. Row-Wise Array Insert using CLI

10. Please Help - using SQLSetPos - at my wits end

11. Getting @@IDENTITY using SQLSetPos

12. Updating changed row field using trigger


 
Powered by phpBB® Forum Software