Home » Developer & Programmer » Forms » how ca i save?????
icon4.gif  how ca i save????? [message #227570] Wed, 28 March 2007 12:19 Go to next message
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
Re: how ca i save????? [message #227611 is a reply to message #227570] Wed, 28 March 2007 15:29 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: how ca i save????? [message #227647 is a reply to message #227611] Wed, 28 March 2007 20:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: how ca i save????? [message #227833 is a reply to message #227647] Thu, 29 March 2007 11:58 Go to previous messageGo to next message
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
Re: how ca i save????? [message #227861 is a reply to message #227833] Thu, 29 March 2007 19:17 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Problem in join relation
Next Topic: how to get it........
Goto Forum:
  


Current Time: Sat Dec 10 16:51:48 CST 2016

Total time taken to generate the page: 0.04267 seconds