Re:Need Suggestion on Data input
Feza writes:
Quote
Suppose ,I have following table design,
Personel
----------
Name
Surname
Place
Tel
Rtf
Drr
Apv
I have 2 forms.User supply data for Name,Surname and place for the
first form.Because the other Rtf,Drr,Apv fields of my table should be
supplied later for some reason.So Do you think, Can i do something
like this? i mean suplly some field with form1 commit then for some
time later supply the rest of data with form2?
I see two possibilities based on your description:
1. The rules are that on inserting a new record, only name/surname/place
are mandatory and the rest can be supplied at some later time. In this case,
yes, wrap the updates from each form in their own transactions.
2. You've split these on two forms, but all must be entered in one
sequence, the record is *not* allowed to exist in the database without all
these fields. In this case, do not start a transaction until you've
successfuly collected data from both forms, then write everything at once to
the database in a single transaction.
--
Wayne Niddery - Logic Fundamentals, Inc. (
www.logicfundamentals.com)
RADBooks:
www.logicfundamentals.com/RADBooks.html
SpaceShipOne; GovernmentZero
