FORMS QUESTIONS

[Quoted] If you intend to reply to this message, please consider to reply by email to connecstasy_at_teleweb.at, because maybe I wont be able to read the newsgroups in the next days.

I am porting a client/server application to ORACLE. As far as the data is concerned, it has been moved successfully from MS SQL to ORACLE Server.

Now for the Client, which originally exists in Access95, there are some questions, and whether they are realisable with Oracle Forms.

The client application's forms are all structured in the following way :

Example :

Form Customers :

Name: Miller Andrew                      Address: 5th Avenue...

What topic is the Customer interested in ? (Multiple Answers stored in detail table):

    2 - Erotic Magazines
    1 - Computer Science
    5 - German Literature

What profession has the Customer ? (Single Answer pulled from detail table holding the possible answers, stored into master table)

    2 - Information Technology.

The data structure is represented in the following tables : 1) a "Customer" Table holding fields : Name, Address, and an integer field named "Profession", holding the key for the answer to "Profession"

in the form above. In this case, the field holds the value 2. 2) 2 Tables holding the answers for the single and the multiple answers questions in the form :

    Customer_Profession
    Customer_Interests
3) 1 Table holding the multple answers for the Customer's interest : Customer_Interests_MultipleAnswers. In the above example, it would hold :

Customer ID : 1227, AnswerID: 2
Customer ID : 1227, AnswerID: 1
Customer ID : 1227, AnswerID: 5

Ok, here are the questions :
[Quoted] A) in Access95, the "single answer" is represented by a combo box, holding the entries of the "Customer_Profession" table:

    but : there is no autocompletion in Oracle Forms ! And :     how do I tell Forms to DISPLAY the NAME of the     profession, but to store the NUMBER associated with it in     the Customers Form ?

[Quoted] B) In Access, the multiple answer section is represented by a subform. When Clicking on it, a Multiselection-enabled List Box pops up, showing which answers have already been selected. and the User can select and deselect answers. Acknowledging his selection, the selection is represented in the subform.
Now : there is no multiselection List Box in Forms, or do you know better ?

[Quoted] [Quoted] C) in Access, the whole data structure is mirrored locally while operating on it. So when the User has selected his answers, and inserted

[Quoted] them into the table "Customer_Interests_Multiple_Answers", this change hasnt yet been made on the server, and he can still cancel all he has done, by simply chosing NOT to copy the local data structure to the server.
The Question is : how can I solve this in Oracle ? I thought of chosing a pop-up form (one that pops up so that the user is NOT able to select any other form while this one is showing up) for selecting the answers, and then, having the user click "OK", closing the pop-up form. and inserting the answers into the detail-section for the multiple answers in the Customer Form.
But : what is the transaction structure then, when I chose to make a COMMIT_FORM on "Customers" ? Will I be able to roll back the insertion of the multiple answers on the server when the user finally choses NOT to make his updates on this Customer Record ? [Quoted] [Quoted] D) when updating an entry, the table is locked only at the row level, but what about the detail table Customer_Interests_MultipleAnswers ? When INSERTING new answers, will the whole table be locked until the user commits his update on the master form "Customers" ? This would be unacceptable since other users wouldn't be able to update any of their customers then.

[Quoted] E) same questions arise when not UPDATING a record, but INSERTING a NEW record on the Customer Form. Will the tables then all be locked for other users ? Imagine a User is editing the entry of a new Customer, and

then choses some the Customer's interests by inserting records in the table "Customer_Interests_MultipleAnswers". Which tables will be locked and in which way will they be locked until the user choses to commit ?

[Quoted] F) how do I make such a "pop-up" form ?
[Quoted] [Quoted] G) is it possible to run multiple "Forms" Clients on the same host for testing multi-user access and for detecting multi-user locking conflicts

?
[Quoted] H) I have auto-incremented Primary Keys in some of the tables. When migrating from SQL Server to Oracle, there qere automatic triggers and sequences created for that purpose. But how come the incremented ID doesnt show up when I chose to insert a new record in Forms on such a table ? Instead it asks me to enter it manually...

[Quoted] Well that are really all questions I have and I don't suppose most of them to be answered in this group, but anyhow, thanks in advance,

Jubin Zawar Received on Thu Jul 08 1999 - 18:42:04 CEST