[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Using Set_item_property default_where

Posted on 2006-03-22
2
Medium Priority
?
2,198 Views
Last Modified: 2013-12-11
I am trying to set the where property on a Block query using the
set_item_property.
When the  user enters  a letter I wan to show a list of names beginning with that letter. I know the syntax should be for example (last_name like  'M%').

WHen the user enters the letter all the user  gets is last_name the match the letter.
 
Please tell how to set the snytax for the set_item_property  default_where clause.

my current syntax is
set_item_property(Block_id,default_where, 'Last_name like :Block.last_name');
where :Block.last_name being the field where the user enters the letter.

0
Comment
Question by:timjshields
2 Comments
 
LVL 16

Accepted Solution

by:
RCorfman earned 2000 total points
ID: 16262222
I'm not sure if this works or not, but can you use...
set_item_property(Block_id,default_where, 'Last_name like :Block.last_name || ''%'' ');
(note, it is two single quotes in a row '', not a double quote "
0
 

Author Comment

by:timjshields
ID: 16268228
It worked perfectly. Thanks alot. Points to you
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question