comp.lang.ada
 help / color / mirror / Atom feed
* Gnatcoll SQL Question on the use of Like or iLike
@ 2014-10-24 23:08 NiGHTS
  2014-10-26 20:00 ` NiGHTS
  0 siblings, 1 reply; 2+ messages in thread
From: NiGHTS @ 2014-10-24 23:08 UTC (permalink / 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.


^ permalink raw reply	[flat|nested] 2+ messages in thread
* Re: Gnatcoll SQL Question on the use of Like or iLike
  2014-10-24 23:08 Gnatcoll SQL Question on the use of Like or iLike NiGHTS
@ 2014-10-26 20:00 ` NiGHTS
  0 siblings, 0 replies; 2+ messages in thread
From: NiGHTS @ 2014-10-26 20:00 UTC (permalink / raw)


On Friday, October 24, 2014 7:08:50 PM UTC-4, NiGHTS wrote:
> 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.

I figured out how to use iLike with Gnatcoll. 

use GNATCOLL.SQL;
use GNATCOLL.SQL.Exec;    

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

^ permalink raw reply	[flat|nested] 2+ messages in thread
end of thread, other threads:[~2014-10-26 20:00 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2014-10-24 23:08 Gnatcoll SQL Question on the use of Like or iLike NiGHTS
2014-10-26 20:00 ` NiGHTS

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