Ask Your Question

Query - criterion

asked 2015-02-22 05:10:49 +0200

jfrasier gravatar image

I am wanting my query to just retrieve a subset of my database but it doesn't work. I type what I am looking for in the criterion box, correct? When I do that all the records are returned and then what I typed has disappeared.


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-02-22 09:53:40 +0200

pierre-yves samyn gravatar image


You give little information about you data, query and how you proceed. Hard to help you... These wiki pages

Show how to do in common cases. If they do not respond to your question, please provide more details.

edit flag offensive delete link more


I have a query for 1 table with a field Firstname. In the Criterion row I type LIKE 'jane' or = 'jane. When I run the query I don't just see Jane and the Criterion row becomes blank.

I can filter by Firstname LIKE Jane successfully


jfrasier gravatar imagejfrasier ( 2015-02-22 14:53:20 +0200 )edit

As indicated in one of the given links search is case sensitive. To allow the search to match the entered string in either upper or lower case (ie case insensitive), the field definition must have type definition "VARCHAR_IGNORECASE". And,if you want to select all records starting with Jane must use the criterion LIKE 'Jane*'

pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-02-22 15:04:45 +0200 )edit

That makes sense but I get the result. Nothing is shown and the criterion is blank after I run it.

I am using version 4.2 and MAC OS 10.9.5

jfrasier gravatar imagejfrasier ( 2015-02-22 15:18:45 +0200 )edit

answered 2015-02-22 23:46:09 +0200

nettings gravatar image

I think I got bitten by the same thing. You must press "Enter" after typing in your criteria, otherwise the field will not be updated. If that's not the cause, it might help to tell us the type of the field you are trying to filter, and what your criteria look like.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-02-22 05:10:49 +0200

Seen: 2,166 times

Last updated: Feb 22 '15