Update SQL On Buffer Mode Override = Optimistic Table Buffering 
Author Message
 Update SQL On Buffer Mode Override = Optimistic Table Buffering

Hello !

Some help needed

If i put Form DataEnvironment Cursor Buffer Mode Override = 5 Optimistic
Table Buffering
the following code work very strange. In some cases it replaces filed
values with some corrupted string on
even does not replacing anything

Setting
Form DataEnvironment Cursor Buffer Mode Override = 5 Optimistic Row
Buffering
everything works fine

LOCAL oldkood, ckomp,lSuccess2, lSuccess1
oldkood="21"
ckomp="2"
 BEGIN TRANSACTION
         UPDATE Kliit!Oppeplan SET Oppeplan.kavakood=ckomp ;
           WHERE Oppeplan.kavakood==oldkood
     BEGIN TRANSACTION
           UPDATE Kliit!Kavayks SET kavakood=ckomp ;
             WHERE kavakood==oldkood
             lSuccess2=TABLEUPDATE(.T.,.T.,"Kavayks")
             IF lSuccess2
               lSuccess1=TABLEUPDATE(.T.,.T.,"Oppeplan")
               IF lSuccess1
                   END TRANSACTION
                   END TRANSACTION
               ELSE
                 ROLLBACK
                 ROLLBACK
               ENDIF
             ELSE
               ROLLBACK
             ENDIF

Kuido



Mon, 10 Mar 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. HELP - Optimistic Row Buffering and Updating Expressions VFP 5.0a

2. Help-optimistic table buffering TABLEUPDATE() failure

3. Slowdown issues with Optimistic Table Buffering?

4. Table Buffering Problem (using level 5 buffering)

5. table buffering mode

6. Table Buffering Mode???

7. function requires row or table buffering mode

8. Reset appended flag in Table Buffering Mode

9. optimistic row buffering

10. Optimistic buffering and tableupdate/revert

11. Optimistic and Pessimistic Buffering

12. Optimistic buffering limit?

 

 
Powered by phpBB® Forum Software