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) =
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
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:
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,
4 matches
Mail list logo