OraFAQ Forum: Forms » Text Item Help

Home » Developer & Programmer » Forms » Text Item Help

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

Text Item Help [message #122095]

Thu, 02 June 2005 16:29

Matloob
Messages: 39
Registered: December 2004

Member

Hello

i will describe my problem by simple emp and dept table
i have created a form which displays the employees from emp table and there department name from the dept table.when i want to insert the record i can insert the department no by entring the dept name with the help of LOV depatment name is TEXT ITEM i have ristricted that department name must be match with the list of lov and i made this fiels query oly YES
it all works well
problem i face then when i used to display the name of the department in departmant name field from dept table on POST-QUERY it opens up the LOV and also asks me to save the record.

basically i want to search only on the name and to enter any department through its name not its number

i m attaching the file too plz do reply me soon.

Attachment: problem.fmb
(Size: 48.00KB, Downloaded 1151 times)

Report message to a moderator

Re: Text Item Help [message #122108 is a reply to message #122095]

Thu, 02 June 2005 20:23

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

Senior Member
Account Moderator

In your post-query, I feel that you aregoing to the field and then placing the value in it and you have automatic LOV pop-up enabled.

In your post-query, don't navigate to field, just populate it.

David

Report message to a moderator

Re: Text Item Help [message #122197 is a reply to message #122108]

Fri, 03 June 2005 13:12

Matloob
Messages: 39
Registered: December 2004

Member

can u plz elaborate ur solution
if i try to check the duplicate i have a case like that in whcih the items cant be duplicate but it can be entered by the code or by name

? plz provide me solution as soon as poosible thanks

Report message to a moderator

Re: Text Item Help [message #122317 is a reply to message #122197]

Sun, 05 June 2005 21:34

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

Senior Member
Account Moderator

Do you have a post-query trigger on the block in your form?

[I am not permitted to download and open your form. Sorry.]

David

Report message to a moderator

Re: Text Item Help [message #122483 is a reply to message #122317]

Mon, 06 June 2005 13:22

Matloob
Messages: 39
Registered: December 2004

Member

yes there is a POST-QUERY Trigger which fetch the name of department which is the requirment

Report message to a moderator

Re: Text Item Help [message #122506 is a reply to message #122483]

Mon, 06 June 2005 19:03

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

Senior Member
Account Moderator

Okay. Have you got a 'go_item' to the department name field in this post-query?

[Please paste your post-query trigger in your reply.]

David

Report message to a moderator

Re: Text Item Help [message #122639 is a reply to message #122506]

Tue, 07 June 2005 13:01

Matloob
Messages: 39
Registered: December 2004

Member

no i m not using go_item or go field

Report message to a moderator

Re: Text Item Help [message #122668 is a reply to message #122639]

Tue, 07 June 2005 21:45

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

Senior Member
Account Moderator

Either paste your post-query trigger here or put a message statement between each line of code and do a line by line debug so that you can see everything that your application is doing.

If you can run your form from within Form Builder then try running it in debug mode and watch how each statement is invoked.

David

Report message to a moderator