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) = selec
> 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) = selector 44
-Tim
**
4D Internet Users Group (4D i
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 Use
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: mailto:4d_tech-unsubscr..
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, :a
5 matches
Mail list logo