Operation | Meaning | Example |
---|---|---|
< | Less | FIELD1<123 |
> | More | FIELD1>123 |
= | Equal for numbers, begin with for strings | FIELD1=123 FIELD2=john |
== | Equal for numbers, exact equal for strings | FIELD2==john FIELD2==john lennon |
<> | Do not equal | FIELD1<>123 |
<= | Less or equal | FIELD1<=123 |
>= | More or equal | FIELD1>=123 |
~ | Contain a substring | FIELD2~lennon |
^ | Do not contain a substring | FIELD1^lennon |
{
// your code
dbf.setFilter("FIRSTNAME=john")
print( "Reccount = " + String(dbf.recCount()) )
dbf.caseSensitiveMode(true)
dbf.setFilter("FIRSTNAME=john")
print( "Reccount = " + String(dbf.recCount()) )
// your code
dbf.unsetFilter()
}