Home » Developer & Programmer » Forms » Record not saved
Record not saved [message #414490] Wed, 22 July 2009 06:21 Go to next message
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

Re: Record not saved [message #414511 is a reply to message #414490] Wed, 22 July 2009 07:20 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
Re: Record not saved [message #414670 is a reply to message #414511] Thu, 23 July 2009 02:46 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have any parameters on your 'call_form'? From which trigger is it called?

David
Re: Record not saved [message #414722 is a reply to message #414490] Thu, 23 July 2009 05:34 Go to previous messageGo to next message
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.
Re: Record not saved [message #414738 is a reply to message #414490] Thu, 23 July 2009 06:04 Go to previous messageGo to next message
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
Re: Record not saved [message #414743 is a reply to message #414490] Thu, 23 July 2009 06:31 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Record not saved [message #414940 is a reply to message #414490] Fri, 24 July 2009 01:58 Go to previous messageGo to next message
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.
Re: Record not saved [message #414964 is a reply to message #414940] Fri, 24 July 2009 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That depends on your operating system. What operating system do you operate?
Re: Record not saved [message #415113 is a reply to message #414490] Fri, 24 July 2009 23:31 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
I am using Windows XP with Service pack 3
Re: Record not saved [message #415128 is a reply to message #415113] Sat, 25 July 2009 01:56 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Start - Control panel - System
Advanced tab - Environment Variables button
Re: Record not saved [message #415275 is a reply to message #414490] Mon, 27 July 2009 00:49 Go to previous messageGo to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Does the directory referred to by 'tmp' and 'temp' have a 'space' in their name?

David
Re: Record not saved [message #415335 is a reply to message #414490] Mon, 27 July 2009 05:24 Go to previous messageGo to next message
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 97 times)
Re: Record not saved [message #415364 is a reply to message #415335] Mon, 27 July 2009 07:16 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
Re: Record not saved [message #415461 is a reply to message #414490] Mon, 27 July 2009 23:54 Go to previous messageGo to next message
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 Go to previous message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks,its working well.
Previous Topic: Problem with Output Form Window.
Next Topic: userenv command
Goto Forum:
  


Current Time: Sat Dec 10 16:35:14 CST 2016

Total time taken to generate the page: 0.08264 seconds