|
Dear sir,
I am now developing application for multiuser networked database and
I am really confused with these things:
1. Begin transaction, rollback, and End Transaction
2. Tableupdate and Tablerevert.
3. Buffering mode
If I have operations on five tables, let's say table TA,TB, TC,TD, and TE
like the following:
Begin transaction
select TA
append blank
replace whatever with whatever
insert into TB (f1,f2,f3) values (x,y,z)
select C
set filter to whatever
replace ALL f1 with value2
select TD
set filter to whatever
go top
Do while !eof()
select TE
append blank
replace f1 with TD.f1
replace f2 with TD.f2*f4*... whatever
select TD
skip
Enddo
End transaction
Are these valid operations? And How can I know whether the commit operations
are performed successfully? Does EndTransaction commit all changes made above?
Or should I issue Begin and End transaction for each respectively?
Another question is about buffer mode. Does begin transaction open buffers for each
table automatically? Or should I issue a setcursorpro statement for each table respectively,
or set form's buffer mode properties?
What is the difference between tableupdate, end transaction, and tablerevert, rollback?
When to use these pairs?
I really need more detailed explaination about all of these, and thanks in advance to any information
that could help me clarify these things.
|
