Re: Tinkering with SQL

[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) = selector 44
> 
> -Tim
> 
> 
> 
> **
> 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...@lists.4d.com
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




**
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...@lists.4d.com
**

RE: Tinkering with SQL

[Timothy Penner via 4D_Tech]

> 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 iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Tinkering with SQL

[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 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...@lists.4d.com
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




**
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...@lists.4d.com
**

Re: Tinkering with SQL

[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:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Tinkering with SQL

[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, :aFoundPhones ;
End SQL
DA_SQL_Logout 

  //TRACE
OpenWindow (530;345;Regular window;"")
set window title("Records found "+string(size of array(aFoundNames)))
DIALOG("NamesAndPhonesFound")
CLOSE WINDOW
`TRACE

QUERY([PatientBase];[PatientBase]FullName="@mc@")
SELECTION TO 
ARRAY([PatientBase]FullName;aFoundNames;[PatientBase]Phone;aFoundPhones)
OpenWindow (530;345;Regular window;"")
set window title("Records found "+string(size of array(aFoundNames)))
DIALOG("NamesAndPhonesFound")
CLOSE WINDOW

The SQL Login goes to the database that is running. 

The SQL select returns 34 records. The 4D Query returns 404.

So what is wrong?
_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




**
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...@lists.4d.com
**