Welcome in 2003 ! what i'll doing 2

[monikai]

Welcome in 2003 !
what i'll doing with it ?
I use view to SQL Serve and in my prg:
USE nsptry!nsp_mbud IN 0 ALIAS M1
SELECT M1
SET MULTILOCKS ON
=CURSORSETPROP('Buffering', 5, 'M1')
I updated group of selected records and when i must do TableUpdate:
1. i change one field in this group ?
2. i change all fields (one by one) in this group ?
3. i change allrecords (before using view) ?

Thanks for advices Kind regards from Warsaw !!!!!
Monika (monikai@yahoo.com)

 

[bon011]

Hi,

I use the same tablebuffering and after I changed some fields so I call Tableupdate(.t.)
It saves all changes you have done before.

 

[ramani]

Hi

If you want all the records to be updated or none to be updated.. then use a TRANSACTION PROCESSING
BEGIN TRANSACTION
lSuccess = TABLEUPDATE(.t.)
IF lSUccess
END TRANSACTION
ELSE
ROLLBACK
ENDIF

On the contrary, if you do not want to rollback.. you dont have to use the ROLLBACK command.


ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Happy New Year

 

[monikai]

Sorry, yesterday i worked hard (i needed extra head an hands) and i forgot about title.
Bon011, Ramani ! Thanks for answers.
Ramani. tell me; when i use Transaction - i don't use 'buffering', isn't it?
Kind regards from Warsaw !!!!!
Monika (monikai@yahoo.com)

 

[ramani]

You can use BUFFERING while you use TRANSACTION processing. These two act separately. TRANSACTION helps to batch the updates as a whole for all tables .. what BUFFERING can do a signle table at a time.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Happy New Year