From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00
	autolearn=unavailable autolearn_force=no version=3.4.4
X-Received: by 10.67.5.100 with SMTP id cl4mr3261708pad.48.1414192128961;
 Fri, 24 Oct 2014 16:08:48 -0700 (PDT)
X-Received: by 10.140.88.70 with SMTP id s64mr359qgd.32.1414192128685; Fri, 24
 Oct 2014 16:08:48 -0700 (PDT)
Path: 
 border2.nntp.dca1.giganews.com!nntp.giganews.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!news.glorb.com!uq10no17076914igb.0!news-out.google.com!u5ni10qab.1!nntp.google.com!s7no375935qap.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.lang.ada
Date: Fri, 24 Oct 2014 16:08:48 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com;
 posting-host=71.229.110.218;
 posting-account=wEPvUgoAAABrLeiz_LRhQ3jeEhyfWVMH
NNTP-Posting-Host: 71.229.110.218
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c942e1e9-4936-4bd5-930f-5ca8af788b1c@googlegroups.com>
Subject: Gnatcoll SQL Question on the use of Like or iLike
From: NiGHTS <nights@unku.us>
Injection-Date: Fri, 24 Oct 2014 23:08:48 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: number.nntp.giganews.com comp.lang.ada:190019
Date: 2014-10-24T16:08:48-07:00
List-Id: <comp.lang.ada>

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.