OraFAQ Forum: Forms » Record not saved

Home » Developer & Programmer » Forms » Record not saved

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

Record not saved [message #414490]

Wed, 22 July 2009 06:21

gozuhair
Messages: 206
Registered: January 2008

Senior Member

Dear All

I have a customer master form and when i open it individually and try to save some records then its working fine but when i call this form through another form by using call_form builtin then its work fine for a few records but after saving 4 or 5 records its working abnormal and saves nothing and at the same time when i open this form individually and input the same records then its save the record successfully,kindly advice.

Regards

Report message to a moderator

Re: Record not saved [message #414511 is a reply to message #414490]

Wed, 22 July 2009 07:20

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

Senior Member
Account Moderator

Quote:

after saving 4 or 5 records its working abnormal and saves nothing

That doesn't make sense; what has happened after 4 or 5 records have been entered? Was there any error? If so, which one? How does this "abnormal" behaviour look like?

Report message to a moderator

Re: Record not saved [message #414670 is a reply to message #414511]

Thu, 23 July 2009 02:46

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

Senior Member
Account Moderator

Do you have any parameters on your 'call_form'? From which trigger is it called?

David

Report message to a moderator

Re: Record not saved [message #414722 is a reply to message #414490]

Thu, 23 July 2009 05:34

blaxmi
Messages: 36
Registered: May 2008
Location: Hyderabad

Member

Hi,

Are you calling the customer master form from another form?
It is better to use new_form instead of call_form b'cos call_form will opens the required form and as well as it will keep the previous form. where as the new_form will only opens the required form and the previous form will be closed.

I hope this resolves your problem.

Report message to a moderator

Re: Record not saved [message #414738 is a reply to message #414490]

Thu, 23 July 2009 06:04

gozuhair
Messages: 206
Registered: January 2008

Senior Member

First of all thanks for the reply,I have written the following code in key next item trigger into my form.

DECLARE 
  a_value_chosen  BOOLEAN; 
BEGIN 
  a_value_chosen := Show_lov('RO_CUST'); 
   
  IF NOT a_value_chosen THEN 
    Message('Enter a Valid Customer and Then Procced.'); 
     bell; 
     
    call_form('\\server\Software\Service\Ro\forms\ro_cust.fmx', 
             no_hide); 
     
    RAISE form_trigger_failure; 
  END IF; 
END; 
go_item('ro_cust_nm');

I didnt use any parameter in this but facing the problem at the time of saving..

I cant use new_form in this because my user requirement is that if he cancel the lov then customer master form automatically open and when he saves the customer master form then system directly goto the previous form.

Please advice

Report message to a moderator

Re: Record not saved [message #414743 is a reply to message #414490]

Thu, 23 July 2009 06:31

blaxmi
Messages: 36
Registered: May 2008
Location: Hyderabad

Member

Check validate from list property for the text item where lov values is called. Set this value first and check whether it is working or not?

[Updated on: Thu, 23 July 2009 06:41]

Report message to a moderator

Re: Record not saved [message #414751 is a reply to message #414490]

Thu, 23 July 2009 06:50

gozuhair
Messages: 206
Registered: January 2008

Senior Member

I have changed the values from no to yes and lov is still working.

[Updated on: Thu, 23 July 2009 06:54]

Report message to a moderator

Re: Record not saved [message #414881 is a reply to message #414738]

Thu, 23 July 2009 23:19

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

Senior Member
Account Moderator

Do you have the two environment variables 'TMP' and 'TEMP' defined" They need to point to an area of disk, preferably on your local hard-drive, to which you have write access. I think you are running out of temporary storage for your called form. It works once or twice but when called many times you will run out of memory unless there has been disk space allocated or you have LOTS of free memory.

David

Report message to a moderator

Re: Record not saved [message #414940 is a reply to message #414490]

Fri, 24 July 2009 01:58

gozuhair
Messages: 206
Registered: January 2008

Senior Member

No,i didnt define any environmental variable,could you please tell me how can i define these variable,i have also searched forum regarding temp ot tmp environment variable, but didnt find any suitable link.

Report message to a moderator

Re: Record not saved [message #414964 is a reply to message #414940]

Fri, 24 July 2009 03:10

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

Senior Member
Account Moderator

That depends on your operating system. What operating system do you operate?

Report message to a moderator

Re: Record not saved [message #415113 is a reply to message #414490]

Fri, 24 July 2009 23:31

gozuhair
Messages: 206
Registered: January 2008

Senior Member

I am using Windows XP with Service pack 3

Report message to a moderator

Re: Record not saved [message #415128 is a reply to message #415113]

Sat, 25 July 2009 01:56

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

Senior Member
Account Moderator

Start - Control panel - System
Advanced tab - Environment Variables button

Report message to a moderator

Re: Record not saved [message #415275 is a reply to message #414490]

Mon, 27 July 2009 00:49

gozuhair
Messages: 206
Registered: January 2008

Senior Member

Thanks for the reply, i have already defined these environment variables,could you please tell me that how can i reference my code to these environmental variables.

[Updated on: Mon, 27 July 2009 00:50]

Report message to a moderator

Re: Record not saved [message #415297 is a reply to message #415275]

Mon, 27 July 2009 02:41

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

Senior Member
Account Moderator

Does the directory referred to by 'tmp' and 'temp' have a 'space' in their name?

David

Report message to a moderator

Re: Record not saved [message #415335 is a reply to message #414490]

Mon, 27 July 2009 05:24

gozuhair
Messages: 206
Registered: January 2008

Senior Member

please find the attached picture file for your reference because i dont know is there any space or not.

Attachment: error.jpg
(Size: 33.69KB, Downloaded 560 times)

Report message to a moderator

Re: Record not saved [message #415364 is a reply to message #415335]

Mon, 27 July 2009 07:16

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

Senior Member
Account Moderator

Yes, there is a space in directory name.

c:\documents and settings\zkhan.it\local settings\...
            |   |                       |
            three spaces (at least), as we don't see the whole path

What happens if you create a "c:\temp" directory and point both TEMP and TMP environment variables into the newly created directory?

Report message to a moderator

Re: Record not saved [message #415461 is a reply to message #414490]

Mon, 27 July 2009 23:54

gozuhair
Messages: 206
Registered: January 2008

Senior Member

thanks for the reply, i have changed the environment variable path to c:\temp,will let you know after input some records.once again thank you very much all of you.

[Updated on: Mon, 27 July 2009 23:56]

Report message to a moderator

Re: Record not saved [message #416377 is a reply to message #414490]

Sat, 01 August 2009 04:47

gozuhair
Messages: 206
Registered: January 2008

Senior Member

Thanks,its working well.

Report message to a moderator

Previous Topic:	Problem with Output Form Window.
Next Topic:	userenv command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:54:32 CDT 2024