Home » Developer & Programmer » Forms » You suggestion required (Form 6i)
You suggestion required [message #295100] Mon, 21 January 2008 06:03 Go to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

I have 2 users ,My 1st user name is "ro" and 2nd one is "Parts"
.i am extracting invoice information from parts user and insert in into "ro" transaction form but problem is that some time system hang and transaction stuck and when i kill session then exery thing is normal.

please suggest

Re: You suggestion required [message #295254 is a reply to message #295100] Mon, 21 January 2008 21:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is there any reason why you are using two users in stead of one? Does each user have all accesses to the other user's tables, etc? Instead of two forms can you do it through one form using a master - detail relationship? Are there any error messages being displayed?

David
Re: You suggestion required [message #295288 is a reply to message #295254] Tue, 22 January 2008 00:25 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks for the reply ,I have 2 users and both users are using a different system.

RO user is related to all activity related to car maintainance and parts user is related to all parts in and out .

When car comes into our workshop the following activites have done.
1-Ro user input all information of car into RO system (RO no Primary key)
2-RO user enerate request of required part with reference to RO no.
3-Part user received request and issue parts and generate invioce against RO NO.
4-After Issuing of parts from Parts Dept against RO NO ,RO user open RO Form in Enter query mode and then i am using key next item for extracting all parts issue.

at that moment some time the system is look like busy and then hang.

I am giving all grant to ro user for using all parts table

I am attaching my FMB.

Please suggest.


  • Attachment: RoFINAL2.fmb
    (Size: 612.00KB, Downloaded 130 times)
Re: You suggestion required [message #295595 is a reply to message #295288] Tue, 22 January 2008 19:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Okay. I have had a quick look at your form.

General comment: You are referring to items by their item name without their block level qualifier. This is bad practice. I suggest modifying ALL your code to add the block name.

At the form level you have placed 'null;' in the on-error trigger. I suggest that you either let the errors appear on the screen or log them to a flat file.

In 'ro_mst.ro_no' key-next-item trigger you have a 'delete' statement but no 'standard.commit'. It is possible that this statement is locking the row and this could cause contention.

Don't use the 'post-change' trigger as it has been superceded. Use 'when-validate-item'.

Do you have access to TOAD or a TOAD-like development tool? If so, when a contention is reported use the 'Session Browser' to look for 'Locks'.

David
Re: You suggestion required [message #295634 is a reply to message #295100] Tue, 22 January 2008 23:20 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear David

First of all thanks for your reply and valuable suggestion.
As per your advice I will follow your suggestion .

Can you please tell me the following information

Can you please tell me the process of creating flat file?
Can you please tell me the “how to use toad development tool and from where I can get the toad software?

Regards


Muhammad Zuhair Khan
Re: You suggestion required [message #295644 is a reply to message #295634] Wed, 23 January 2008 00:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use 'text_io' or 'utl_file' to create and write to a flat file. Search this forum.

For TOAD either google it or look at this site's FAQ.

David
Previous Topic: Want to dynamically change the file menu of a form
Next Topic: Can I change the appearance of a canvas?
Goto Forum:
  


Current Time: Fri Dec 09 09:53:33 CST 2016

Total time taken to generate the page: 0.07069 seconds