On Sat, Nov 09, 2002 at 00:04:26 -0700, Zhidian Du <duzhidian@xxxxxxxxxxx> wrote: > > I have a question of, when users input some contents in the second page, > then the contents in first and second pages are inserted into tables; > Otherwise, rollback. > > I want to use transction to handle it. > > But when users input the contents in first page, how do I know users have > left( My program will roolback ) or want to continue input sone contents in > the second page (comit)? Usig timer, for example? or some other better > idea. My suggestion would be not to start entering either page until the application has all of the data for both pages. Holding transactions open for long periods of time is not a good idea.
