comp.lang.ada
 help / color / mirror / Atom feed
From: NiGHTS <nights@unku.us>
Subject: Gnatcoll SQL Question on the use of Like or iLike
Date: Fri, 24 Oct 2014 16:08:48 -0700 (PDT)
Date: 2014-10-24T16:08:48-07:00	[thread overview]
Message-ID: <c942e1e9-4936-4bd5-930f-5ca8af788b1c@googlegroups.com> (raw)

I can't find any examples on how to use Like or iLike using the Gnatcoll Library.

This is how I do a search with exact text.

Query_Select := SQL_Select (
    Fields => mydb.Applications.Id_Application & mydb.Applications.Name,
    From   => mydb.Applications,
    Where  => mydb.Applications.Name = "test";

But in this case I want to use the SQL string wildcard with case insensitive filtering.

Query_Select := SQL_Select (
    Fields => mydb.Applications.Id_Application & mydb.Applications.Name,
    From   => mydb.Applications,
    Where  => mydb.Applications.Name ILike "%test%";

That of course does not work. Also tried this:

Query_Select := SQL_Select (
    Fields => mydb.Applications.Id_Application & mydb.Applications.Name,
    From   => mydb.Applications,
    Where  => mydb.Applications.Name.ILike("%test%");

Does not work either. Any suggestions?


Thanks in advance for your help.


             reply	other threads:[~2014-10-24 23:08 UTC|newest]

Thread overview: 2+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-10-24 23:08 NiGHTS [this message]
2014-10-26 20:00 ` Gnatcoll SQL Question on the use of Like or iLike NiGHTS

replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox