Home » Developer & Programmer » Forms » Append Data (Windows XP DB 9i - forms 6i)
Append Data [message #359438] Sun, 16 November 2008 03:53 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi Guyz,

I have a problem in my form. the field is List Item

there are 3 field in list item

1) Resignation
2) Termination
3) Vacation

if i select the resignation/Termination some of the field is activate like resignation date etc. and when i select Vacation it will open the new form.

when i select the vacation field it should append some data from the main form most of the field are same how can i append the data before/after vacation from displayed on screen.

can someone give me example how can i append the data.

Regards
Re: Append Data [message #359440 is a reply to message #359438] Sun, 16 November 2008 04:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unless you COMMIT data in one form, another form doesn't know these values exist. Therefore, you might use parameters (or global variables) to transfer data between these forms.
Re: Append Data [message #359444 is a reply to message #359438] Sun, 16 November 2008 05:44 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi Little,

already i have a data in form A im calling form B
im using when-list-change trigger to call the form B after calling form B i want to put some data from form A like Name, Mobile, Address etc etc how can i append some data from form A after calling form B?

Regards
Re: Append Data [message #359493 is a reply to message #359444] Sun, 16 November 2008 21:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why noit do this other work on a second block / canvas of the same form. Then you will all the data all the time.

David
Re: Append Data [message #359511 is a reply to message #359493] Mon, 17 November 2008 00:25 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Thanks Martin,

but im calling this this form in three or four places so i dont think so i use the second block/canvas.

Regards

Re: Append Data [message #359680 is a reply to message #359511] Tue, 18 November 2008 00:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You can't append data AFTER calling form b but you can pass the data from forma to form b by using parameters. There is a builtin block called 'parameters' in each form. Use the help facility to explain how to use parameters.

David

PS My name is 'David'. It is the name that I place at the end of all of my posts.
Re: Append Data [message #359729 is a reply to message #359440] Tue, 18 November 2008 01:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Littlefoot wrote on Sun, 16 November 2008 11:03
... you might use parameters (or global variables) ...

Perhaps I shouldn't use invisible ink next time ./fa/1600/0/
Re: Append Data [message #359771 is a reply to message #359729] Tue, 18 November 2008 02:48 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi all,

thanks for valuable replies..
Im using global variable to insert some data from Form A to form B and when im calling to form B global values also insert in form B but when im adding some more data and commiting the form it gives me this error
frm-40403 a calling form has unapplied changes. save not allowed.

even i commit data before calling form and its giving me same error

im using the below code From form A to Form B and inserting these values in form B and its inserting fine but not commiting. when i use POST; it work fine with the below message

frm-40404 Database apply complete : 1 record applied

:EMPLOYEE.EMP_STATUS='Vacation' then
:GLOBAL.EMPID:=:EMPLOYEE.EMPID;
:GLOBAL.EMP_NAME:=:EMPLOYEE.EMP_NAME;
:GLOBAL.NATIONALITY:=:EMPLOYEE.NATIONALITY;
:GLOBAL.JOB_TITLE:=:EMPLOYEE.JOB_TITLE;
:GLOBAL.DEPT_NAME:=:EMPLOYEE.DEPT_NAME;
post;
CALL_FORM('VACATION',no_hide,no_replace);

is there anyway to bypass this message and commit change normally without this message?

Regards


Re: Append Data [message #359942 is a reply to message #359771] Tue, 18 November 2008 22:50 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum or the help file for 'message_level'.

David
Previous Topic: problem to update record in tabular form
Next Topic: SEND EMAIL IN ARABIC LANGUAGE
Goto Forum:
  


Current Time: Sat Dec 10 04:51:04 CST 2016

Total time taken to generate the page: 0.06996 seconds