Re: Unicode characters and SQL queries

2018-02-20 Thread David Rose via 4D_Tech
Miyako, This worked, thanks!: SET DATABASE PARAMETER(SQL engine case sensitivity;0) -- Message: 1 Date: Mon, 19 Feb 2018 20:58:10 + From: Keisuke Miyako To: 4D iNug Technical <4d_tech@lists.4d.com>

QuickReports v16 64-bit Mac on a form

2018-02-20 Thread John DeSoi via 4D_Tech
I have a few legacy reports that I have been keeping alive on quick reports. After upgrading to 4D 16.3, it seems you can still have a quick report on a form, but you can't load it or do anything with it in the form On Load phase. For example, QR BLOB TO REPORT fails in On Load (error -9850

Re: query for empty string

2018-02-20 Thread webmaster namethatplant.net via 4D_Tech
Thank you, Keisuke. I will take this off my list of things to worry about Janie - Date: Thu, 15 Feb 2018 04:03:03 + From: Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > but I'm still trying to wrap my brain around the sorts of situations that > might require using length=0

AW: How to know the result of a spelling check

2018-02-20 Thread Achim Peschke via 4D_Tech
The automatic spell checking does not offer this. If you need you can extract the plain text and hand over to the command SPELL CHECK TEXT. Here you can check the arrays or the variable OK to maybe decide to bring an appropriate message. Achim -Ursprüngliche Nachricht- Von: 4D_Tech

AW: Giving an object the focus

2018-02-20 Thread Achim Peschke via 4D_Tech
I would avoid taking away the focus from the other object. Might be that the user wants to spell check this one. By the way, I use GOTO OBJECT(wp)sets the focus to wp but not for the spell checker in the same object method. The refresh of the area happens only after the object method is