Home » Developer & Programmer » Forms » Non database item
Non database item [message #643552] Mon, 12 October 2015 00:22 Go to next message
s_akbari
Messages: 7
Registered: October 2015
Location: iran
Junior Member
Hi
I'm a beginner in oracle form builder.I want to search on a non database item, for example when I write %city_name%, other items fill out that their city is city_name.
thanks
Re: Non database item [message #643553 is a reply to message #643552] Mon, 12 October 2015 00:55 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If other items belong to a database block, then use SET_BLOCK_PROPERTY and set its ONETIME_WHERE condition.

If they don't belong to a database block, then you'll have to fill it manually in a loop, record-by-record.
Re: Non database item [message #643554 is a reply to message #643553] Mon, 12 October 2015 01:10 Go to previous message
s_akbari
Messages: 7
Registered: October 2015
Location: iran
Junior Member
Really thanks
Previous Topic: Calendar demo form for Form 6i
Next Topic: Annual leave of the year
Goto Forum:
  


Current Time: Thu Apr 25 07:05:14 CDT 2024