- Site Admin
- Posts: 274
- Joined: 05 Mar 2017, 20:57
- Location: Tauranga, New Zealand <--> Stroud, England
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 ?
- 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 ?
Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand
Who is online
Users browsing this forum: [Ccbot] and 0 guests