| Oracle Forms Question [message #437771] |
Tue, 05 January 2010 23:34  |
DBase482
Messages: 6
Registered: January 2010
|
Junior Member |
|
|
Scenario: I have 3 data-blocks: a, b, c.
data-block a has 3 items: customer_number, customer_name, account_id
Dataflow: In data-block a, the user enters a customer_number. This will automatically populate items customer_name and account_id (if the account_id already exists in the database) as well as the other two data-blocks (b and c). HOWEVER, if the account_id doesn't already exist in the database, the user must enter one, and once it's entered it's implicitly saved, and the next time the user logs in the account_id will already be in the database.
Question: How do I implement this logic? What kind of triggers should I use?
Thank you.
|
|
|
|
|
|
| Re: Oracle Forms Question [message #437876 is a reply to message #437771] |
Wed, 06 January 2010 05:50  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
DBase482once it's entered it's implicitly saved
Why "implicitly" (by the way, what do you call "implicit saving")? Let user commit changes, because soon you might come back asking how to delete unwanted implicitly saved records from the database.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
