SqlDbx
You are not logged in.
In the Filter option (Rigth click on the grid ->> Filter), Add an option to write the operation and value to filter
ie:
SELECT * FROM Customers
CustomerID CompanyName ContactName PostalCode
---------- ------------------------------------ -------------------- ----------
ALFKI Alfreds Futterkiste Maria Anders 12209
ANATR Ana Trujillo Emparedados y helados Ana Trujillo 05021
ANTON Antonio Moreno TaquerÃa Antonio Moreno 05023
AROUT Around the Horn Thomas Hardy WA1 1DP
I want to see the customers with PostalCode = 135000, In the grid, rigth click in PostalCode attribute ->> Filter
In the last option i want to write the value "= 135000" or "135000"
------------------------
- PostalCode = 122009 -
- PostalCode != 122009 -
- PostalCode < 122009 -
- PostalCode > 122009 -
- PostalCode = 135000 -
------------------------
when ther isn't operation silbol, the operation is "="
Offline
I am not sure about this one. Why just not to query for 135000
Offline
It is not very important, but I used it in Ms Access and is usefull.
Offline
I'll take a look how MS Access does it and see if it makes sense to implement it
Offline