Numeric Operators in SQL Where clauses
On Feb 2, 2018, at 17:20, Das Goravani <das@goravani.com> wrote:
> I have a where clause which searches multiple fields from one text entry field.
I recommend building a server-side function to handle this. This will mean a single roundtrip to the database. If you try to run all the SQL from Omnis, you’ll get a network hit for each additional column you search.
This also lets you encapsulate the search logic and handle interesting cases like numbers, dates, booleans, etc.
Alex
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com