OraFAQ Forum: Forms » how ca i save?????

Home » Developer & Programmer » Forms » how ca i save?????

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

how ca i save????? [message #227570]

Wed, 28 March 2007 12:19

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

hi everyone,
actually i create a module in which i have 2 canvas belonging to 2 different windows.
both canvas having 2 different database blocks(created by wizard).
1st canvas is logon screen.
which having a button titel "logon" ,if the username and password are valid then the user is logged on and go to screen having data related to employees (by clicking "logon" button).
now on the 2nd screen there are 10-12 text items .
here on 2nd canvas there is a button title "save" ,
now after filling these fields when i click the save button,
data belonging to both the canvases saved to corresponding tables.

i think this is clear.........

whhat i want...........
when i click the "save" button on 2nd canvas the data belonging to 2nd canvas( obviously 2nd database block) commits,not the 1st also.
please send me a solved module.......(because i need it perfectly right).

so please make it fast ,buddy

RAJAT CHAUDHARY

Report message to a moderator

Re: how ca i save????? [message #227611 is a reply to message #227570]

Wed, 28 March 2007 15:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Can't be done (at least, as far as I can tell). In Forms, you commit all (changes in all blocks) or nothing. If you need to distinguish those blocks, consider moving one of them into another form and open it (from the first one) using the OPEN_FORM built-in.

Report message to a moderator

Re: how ca i save????? [message #227647 is a reply to message #227611]

Wed, 28 March 2007 20:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you only have a few items on the first canvas/window and there is only one row of them, then store the information in a non-database block, clear the information from the first area, do your commit, and then put the information back.

Other than that, rethink your whole design.

David

Report message to a moderator

Re: how ca i save????? [message #227833 is a reply to message #227647]

Thu, 29 March 2007 11:58

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

YA DAVID,
ACTUALLY THIS I ALREADY APPLIED TO MAKE ONE BLOCK NON-DATABASE AND OTHER DATABASE AND THEN SAVE,IT WORKS ....
IS THERE ANY OTHER ALTERNATE OF THIS ANSWER.........

THANX IN ADVANCE.............

RAJAT

Report message to a moderator

Re: how ca i save????? [message #227861 is a reply to message #227833]

Thu, 29 March 2007 19:17

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

To my knowledge - No. A 'commit' saves EVERYTHING, unless there is an error at which point EVERYTHING is rolled back.

David

Report message to a moderator

Previous Topic:	Problem in join relation
Next Topic:	how to get it........

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 12:56:59 CST 2025