Concatenate '%' with textbox [message #506417] |
Mon, 09 May 2011 03:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bc527a3a024fa498a3a8c878ec82e08d?s=64&d=mm&r=g) |
new_oracle2011
Messages: 174 Registered: March 2011 Location: Qatar
|
Senior Member |
|
|
I want to concatenate '%' with the textbox.
Actually, presently my program is searching for list number 1 to 5. but now the lists are increased and some sub lists are made. eg sub list of list 1 is 11, 12 , 13, 14 or more
Now it is working as getting the input value of the list then it can be display in the data block as a result search query. I want to make the textbox concatenate with '%' so whenever user put 1 in the field it shows all records present in list 1, 11, 12 ... till the list starts with 1.
I did check by changing the field like below
:block.variable := :block.variable||'%';
Also I changed the '=' with LIKE in query.
is there any solution for this??
|
|
|
|
|
Re: Concatenate '%' with textbox [message #506766 is a reply to message #506753] |
Wed, 11 May 2011 03:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
new_oracle2011 wrote on Wed, 11 May 2011 08:28what i was doing before i just sending this
:block_name.field_name||'%';
Sending it where? What trigger is that code in?
new_oracle2011 wrote on Wed, 11 May 2011 08:28
but this gives some error.
What error?
You should not need that function at all.
|
|
|