DBP_FETCHTHROUGH - SQLBase good, SQLServer bad

[Steve Leighton]

Has anyone experienced having to build a Result-set, update a single row in the Result-set, then re-fetch the newly updated row using SqlFetchRow().

In SQLBase, one simply forces a re-read direct from the dB, rather re-reading the Result-Set cache, by setting DBP_FETCHTHROUGH first. Works a treat.

But SQLServer insists on re-reading from the original Result-Set no matter what. DBP_FETCHTHROUGH is ignored, resulting in the pre-updated value being returned every time.
Short of re-building and fetching the entire Result-Set, or upgrading to SQLBase , has anyone any ideas ?

I've tried:
- SqlCommit(hSql),
- SqlResultSet(hSql,FALSE),
- If SqlPrepareAndExecute( hSql1, 'CHECKPOINT' )
Call SqlPrepareAndExecute( hSql1, 'DBBC DROPCLEANBUFFERS WITH NO_INFOMSGS ' )

before the SqlFetchRow()

but SQLServer doggedly returns the old pre-Updated values from the Result-Set ( not the back-end ).

Any clues ?