OraFAQ Forum: Forms » study task (merged)

Home » Developer & Programmer » Forms » study task (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

study task (merged) [message #489862]

Wed, 19 January 2011 11:42

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

my task is when i press > this button on attached picture
all name should come to my next block ....

for understanding i send form also..

just use scott/ tiger

go to dtl canvas...where u get my screen
on that i created button which is marked as > .

Attachment: issue.JPG
(Size: 122.98KB, Downloaded 591 times)

Report message to a moderator

study task [message #489863 is a reply to message #489862]

Wed, 19 January 2011 11:45

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

i attached my form fmb herewith

Attachment: MODULE1.fmb
(Size: 80.00KB, Downloaded 980 times)

Report message to a moderator

Re: study task [message #489864 is a reply to message #489863]

Wed, 19 January 2011 11:48

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you're going to supply more information/attachments it helps to do so as a reply to your original post. That was one merge that I really shouldn't have needed to do.

Report message to a moderator

Re: study task [message #489865 is a reply to message #489864]

Wed, 19 January 2011 11:50

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

i also attached my study form with this...if u require any information let me know..

Report message to a moderator

Re: study task [message #489866 is a reply to message #489865]

Wed, 19 January 2011 11:56

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

A proper description of what you are trying to achieve would be a good start.
1) Are you copying all the records in the emp block or the emp table?
2) Has the emp data been queried from the DB?
3) Can it be modified?
4) Do you want to insert the data in the salgrade block into the DB?
5) Is the user allowed to modify the data in the salgrade block?

Report message to a moderator

Re: study task [message #489867 is a reply to message #489866]

Wed, 19 January 2011 12:04

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi sir,

By using execute query i bring all record in emp block and write down mark(non-database item) for each emp.

when i press '>' button i want to move all
name and mark from emp block to salgrade block...

Report message to a moderator

Re: study task [message #489868 is a reply to message #489867]

Wed, 19 January 2011 12:05

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

That doesn't answer 3,4 or 5.

Report message to a moderator

Re: study task [message #489870 is a reply to message #489868]

Wed, 19 January 2011 12:09

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

3) Can it be modified?
- yes

4) Do you want to insert the data in the salgrade block into the DB?
- yes

5) Is the user allowed to modify the data in the salgrade block?
- yes

Report message to a moderator

Re: study task [message #489872 is a reply to message #489870]

Wed, 19 January 2011 12:31

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) Go to emp block
2) loop
3) Check each record to see if it should be copied
4) If yes either insert record into salgrade table (using insert statement) or assign salgrade block items to values in current emp record
5) When you reach the end of the emp block exit the loop
6) Go to salgrade block
7) If you did an insert in step 4 execute query to populate the block with the records you inserted in the DB.

Report message to a moderator