>To all:
>The solution to the problem is that a TableUpdate must be
>issued after each Update in the loop.
>The problem appears not only with the SQL Update command but
>also wilt SQl Delete etc.
>In my case the solution was:
>
>Scan
> M_ CODE= temp_curs.Code
> Update invhed Set katpel= m_sys WHERE invhed.Code=M_CODE
> If ! Tableupdate(0, .T., "INVHED")
> * message code
> endif
>Endscan
>
>In general one must Tableupdate the table each time a record changes
>or appended.
>This is a major change from VFP7 to VFP8, and it should
>have been documented from the very beginnig.
>Practically I must review and change a lot in my code in order
>to move from 7to8.
>
>Yiorgos
Yiorgos,
Could you confirm that performance degradation was not related to TABLEUPDATE, but to SQL-UPDATE called in the scan loop?
Could you please do it on both threads so people will know where the real problem is.
Thank you,
Aleksey.
P.S. You can simply switch to row buffering to avoid explicit TABLEUPDATE calls in the scan loop.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only