Home » Developer & Programmer » Forms » Dummy Fields (Oracle 10g)
Dummy Fields [message #641064] Mon, 10 August 2015 07:20 Go to next message
ORA2015
Messages: 49
Registered: March 2015
Member
Hi,

Is there a way that values can be queried when entered in 'dummy' fields and then validated against a LOV listing?

Report message to a moderator

Re: Dummy Fields [message #641065 is a reply to message #641064] Mon, 10 August 2015 07:24 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you call "dummy" fields? Non-database items? If so, then yes - you can use those values when creating ONETIME_WHERE block property (in SET_BLOCK_PROPERTY).

What do you mean by "validating" those values? Does it mean that you already stored invalid values into the database (as query retrieved them into a form)?

Report message to a moderator

Re: Dummy Fields [message #641066 is a reply to message #641065] Mon, 10 August 2015 07:26 Go to previous messageGo to next message
ORA2015
Messages: 49
Registered: March 2015
Member
could you give me an example?

Report message to a moderator

Re: Dummy Fields [message #641067 is a reply to message #641066] Mon, 10 August 2015 07:28 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What example?

Report message to a moderator

Re: Dummy Fields [message #641069 is a reply to message #641067] Mon, 10 August 2015 07:37 Go to previous messageGo to next message
ORA2015
Messages: 49
Registered: March 2015
Member
An example of the set block property you mentioned / more details....

Just saw another part of your initial response--- Here's more detail...i created a datablock...within that datablock i have 3 non-database item fields. There is also a button than brings up a list of values that i can select to populate these fields and then i can query. A post query trigger was created at the datablock level to return the actual values. However, i would also like to enter values in these fields that would validate against the listing from the LOV so as to have an alternative to perform a query. As such the query can be done both ways...

Thanks

Report message to a moderator

Re: Dummy Fields [message #641072 is a reply to message #641069] Mon, 10 August 2015 07:45 Go to previous messageGo to next message
ORA2015
Messages: 49
Registered: March 2015
Member
An example of the set block property you mentioned / more details....

Just saw another part of your initial response--- Here's more detail...i created a datablock...within that datablock i have 3 non-database item fields. There is also a button than brings up a list of values that i can select to populate these fields and then i can query. A post query trigger was created at the datablock level to return the actual values. However, i would also like to enter values in these fields that would validate against the listing from the LOV so as to have an alternative to perform a query. As such the query can be done both ways...

Thanks

[Updated on: Mon, 10 August 2015 07:45]

Report message to a moderator

Re: Dummy Fields [message #641073 is a reply to message #641069] Mon, 10 August 2015 07:47 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SET_BLOCK_PROPERTY is described in Forms Help - open it and read what it says. Try to do it yourself. If you don't succeed, come back here, post what you did and someone will assist.

As of the rest of your question: although you can do it that way, it doesn't mean that you should do it that way. Why making thins complicated, if you can have them simple? Use as much of Forms built-in capabilities as you can. Does Quote:

i would also like to enter values in these fields
mean that you'd want to perform INSERT operation through those non-database items? If so, that's possible as well - you'll have to create your own trigger (such as PRE-INSERT) which would use non-database items as a source for database items).

As LoV works on non-database items as well as on database items, I'm not sure what is the problem regarding LoVs ...

Report message to a moderator

Re: Dummy Fields [message #641074 is a reply to message #641073] Mon, 10 August 2015 08:05 Go to previous message
ORA2015
Messages: 49
Registered: March 2015
Member
thanks. there is no issue with the LOv though. Its with inserting and allowing me to query from that insert.

I'll try

Report message to a moderator

Previous Topic: wnri Trigger problem
Next Topic: tab change
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 18:10:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.