| Saving into two tables [message #370623] |
Tue, 11 January 2000 07:27  |
josef cihal
Messages: 12
Registered: January 2000
|
Junior Member |
|
|
Please help!
I need to save at one time in one form into two tables.
Need I to create master-detail relation or something others???
Thanks.
Regard
josef
|
|
|
|
| Re: Saving into two tables [message #370626 is a reply to message #370623] |
Tue, 11 January 2000 14:46  |
MikeG
Messages: 14
Registered: August 1999
|
Junior Member |
|
|
|
I believe that you need to understand the concept of a transaction. You can begin a transaction, insert into both tables and then either commit or rollback. by including both inserts in the same transaction they are a logical block and are either committed/rolled back together.
|
|
|
|
| Re: Saving into two tables [message #370632 is a reply to message #370626] |
Wed, 12 January 2000 03:12 |
josef cihal
Messages: 12
Registered: January 2000
|
Junior Member |
|
|
Mike,
O.K>.
I understand now , how it works. Can you help me please,...
Need I to write script for example:
..insert into table ...values...
or I need simply to define master -detail relation, between 3 blocks. Two tables (A and B)are binded with one asociation table(C) (these table(C) include two primary keys from tables A and B).
Thanks.
Regard
josef cihal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
