OraFAQ Forum: Forms » You suggestion required

Home » Developer & Programmer » Forms » You suggestion required (Form 6i)

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

You suggestion required [message #295100]

Mon, 21 January 2008 06:03

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

Report message to a moderator

Re: You suggestion required [message #295254 is a reply to message #295100]

Mon, 21 January 2008 21:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: You suggestion required [message #295288 is a reply to message #295254]

Tue, 22 January 2008 00:25

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 989 times)

Report message to a moderator

Re: You suggestion required [message #295595 is a reply to message #295288]

Tue, 22 January 2008 19:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: You suggestion required [message #295634 is a reply to message #295100]

Tue, 22 January 2008 23:20

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

Report message to a moderator

Re: You suggestion required [message #295644 is a reply to message #295634]

Wed, 23 January 2008 00:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 20 08:26:32 CST 2025