Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread LIKE '%some_value% does not filter as expected in ElevateDB Manager.
Wed, Feb 14 2007 5:12 AMPermanent Link

Dave M
1) Setting a filter to some_column LIKE %some_value% will not return any rows with some_value.

Say there are many table rows with a last_name field containing the letter 'm'.

Then last_name LIKE '%m%', with Case-Insensitive checked displays no records.  

Placing the wildcard first does not work as expected. Have not checked this using LIKE in
an SQL query.


2) A minor user interface oddity....
Scrolling to the last record of a table in EDB Manager, followed by arrow down, then arrow
up, causes a phantom duplicate record to appear.


build 9.

Dave M.
Wed, Feb 14 2007 5:19 AMPermanent Link

Dave M
Forget the previous message!  Posted in the wrong section.

Dave M
Image