Re: Tinkering with SQL

2018-08-06 Thread Robert McKeever via 4D_Tech
Thanks, Tim. > On Aug 6, 2018, at 5:27 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> So, how do I make the SQL case-insensitive? > > http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html > > Set Database Parameter (SQL Engine case sensitivity) =

Re: Tinkering with SQL

2018-08-06 Thread Robert McKeever via 4D_Tech
So, how do I make the SQL case-insensitive? > On Aug 6, 2018, at 4:57 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 4D query is case insensitive whereas SWL by default is not. > > > > ** > 4D Internet

Re: Tinkering with SQL

2018-08-06 Thread Keisuke Miyako via 4D_Tech
4D query is case insensitive whereas SWL by default is not. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub:

Tinkering with SQL

2018-08-06 Thread Robert McKeever via 4D_Tech
4D v15 I run the following code: The SQL Login goes to the database that is running. DA_SQL_Login2 C_TEXT(tLookFor) tLookFor:="%Mc%" ARRAY TEXT(aFoundNames;0) ARRAY TEXT(aFoundPhones;0) Begin SQL Select FullName, Phone FROM PatientBase WHERE (FullName like :tLookFor) INTO :aFoundNames,