Home » Developer & Programmer » Forms » Really Need Help (form builder 6i)
icon4.gif  Really Need Help [message #338847] Wed, 06 August 2008 02:03 Go to next message
Messages: 61
Registered: April 2008

Hi All

For over a month i studied a new form that i must prepare for the new General Ledger System (Account Use).

I'm new in oracle and of course new in cursor & looping use.

For the first main form,the details like this:

There are 2 parts;Payment(Have line no,payee code,cheque date,reference no,remarks,and total amount) and second part is Payment detail(Have line no,account code,debit amt).these 2 parts have multiple lines based on the user input..

e.g : fisrt record(first payee) may have multiple payments have been made.there for one payee have many payments.
then,the user will key in the second payee.when this happen,the second block will be clear and insert to hidden block(as my boss told me).the total amount at first block is total debit amount at second block.

the problem is i really don't know how to do it.
i can do checking for each items on myself but the whole process is really make me sick..

i hope you guys can help me..i can't copy and paste people system but it will make me learn nothing...

thank you
Re: Really Need Help [message #338885 is a reply to message #338847] Wed, 06 August 2008 03:18 Go to previous message
Messages: 21016
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I understood, it looks like a master-detail form (where master block ("payee" in your example) will have a detail block ("payments")). That's quite straightforward; Forms creates master-detail relationships using Data Block Wizard - just let it do the job (carefully read what Wizard wants to know and answer as good as you can).

Form will - by default - work properly. All other details (for example, fetching foreign key values, date formatting, etc. can be done later).

user will key in the second payee (and) the second block will be clear and insert to hidden block(as my boss told me)

I don't quite understand that; it is a default behaviour - when a new record is opened in the master block, detail block is cleared and waits for user's input. What "hidden block" is your boss talking about? There's nothing "hidden" (at least, I can't remember anything).

You've mentioned cursors and loops. In my opinion, you don't need any of these. List of values in the first block will return "payees", list of values in the second block will return "payments" and that should be all; no cursors, no loops.
Previous Topic: How handle Oracle Form own generated Error
Next Topic: Retrive many rows into a data block??
Goto Forum:

Current Time: Thu Feb 23 10:22:51 CST 2017

Total time taken to generate the page: 0.12987 seconds