DataGrid 2 swipe actions

[Andrew at MidWest Coast Media via use-livecode]

I was inspired by today’s Lockdown Learning Series presentation and looked at 
adding swipe gestures to a current project. This whole process made WAY more 
sense after re-watching Michael’s presentation (I saw it live too, but was over 
my head last year). I’m struggling with a large DG. I’ve got my custom swipe 
controls working and triggering custom swipe actions. But I’m having problems 
with my mouseDown.

If there is a swipe control open and you tap a different visible row, the open 
swipe control is closed (with or w/o animation). 
If there is a swipe control open and the DG scrolls to a point where that 
control is no longer on-screen, that swipe control doesn’t close even though a 
new row is highlighted. 

The closest workaround I could come up with was to check for vertical scroll 
and just kill all swipe controls. Is this expected behavior or bug?

on scrollerDidScroll pHScroll, pVScroll
if pVScroll > 50 then
dispatch "RowSwipeHideControl" to group "DataGrid" with TRUE
end if
end scrollerDidScroll

The highlighted row when scrolling is a separate bug patched by Mike Wieder  
https://quality.livecode.com/show_bug.cgi?id=22798 
 awaiting a GitHub merge, 
but turning on delayTouches makes the swipe animation jerky because the 
scroller has to decide if it’s scrolling first so the swipe controls aren’t 
very responsive. Would be curious if these two things can live in harmony. Any 
DG2 advice?

-Andrew Bell
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Basic question about behaviors

[William Prothero via use-livecode]

Thanks, Paul. That worked.
Bill

William A. Prothero
https://earthlearningsolutions.org

> On Aug 25, 2020, at 8:03 PM, Paul Hibbert via use-livecode 
>  wrote:
> 
> Bill, try this in the behaviour button script:
> 
> on mouseUp
>  put the long name of this me into theName  —theName will contain the long 
> name of the behaviour button.
> end mouseUp
> 
> put this me into theName - would put the value contained in the text property 
> of the behaviour button into theName. In standard, default and rectangle 
> buttons we don’t normally use the text property, but there’s nothing stopping 
> you from using it if you wish, you just need to populate it first. :)
> 
> Paul
> 
>> On 25Aug, 2020, at 15:48, William Prothero via use-livecode 
>> mailto:use-livecode@lists.runrev.com>> wrote:
>> 
>> on mouseUp
>>  put  this me into theName  —theName is blank.
>> end mouseUP
> 
> 
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Strange behavior between Mysql, MariaDB and SSL.

[Heriberto Torrado via use-livecode]

Hi Matthias,

Do you mean connecting to MySQL using ODBC instead of the built-in LiveCode 
MySQL client?

Best,
Hery

-Original Message-
From: use-livecode  On Behalf Of 
matthias rebbe via use-livecode
Sent: Wednesday, August 26, 2020 10:42 AM
To: How to use LiveCode 
Cc: matthias_livecode_150...@m-r-d.de
Subject: Re: Strange behavior between Mysql, MariaDB and SSL.

There are also free MySQL Connectors/ODBC available for different operating 
systems. The current ones are for Server 8.0,5.7 and 5.6.

https://dev.mysql.com/downloads/connector/odbc/

They connectors can be downloaded without the need to be logged in. So no need 
for an account registration at dev.mysql.com

Maybe this is an option instead of lowering the encryption level?

Matthias
-
Matthias Rebbe
Life Is Too Short For Boring Code

> Am 26.08.2020 um 16:08 schrieb panagiotis merakos via use-livecode 
> :
> 
> Hello all,
> 
> This is because MySQL 8 supports a stronger authentication method 
> based on SHA256, and this method is used by default.
> 
> LiveCode (as well as some other MySQL connectors/clients) do not 
> support this authentication method yet. In this case, you could 
> configure your MySQL installation to use the legacy authentication 
> (password encryption) method.
> 
> See the suggested answers in this link:
> https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not
> -support-authentication-protocol-requested-by-server/50961428
> 
> Hope this helps.
> 
> Kind regards,
> Panos
> --
> 
> On Tue, 25 Aug 2020 at 18:41, Bob Sneidar via use-livecode < 
> use-livecode@lists.runrev.com> wrote:
> 
>> mySQL for which platform? Last I checked, the build for Windows did 
>> NOT support encryption. There is a special branch that does, but I 
>> could never get it to work.
>> 
>> What I came up with is an agent that resides on the SQL server, built 
>> in Livecode that listens for connections. It then handles the queries 
>> locally and returns the data.
>> 
>> The client and Server encrypt the data before sending it using a 
>> method only I know, so it’s very secure. The communications are done 
>> but I haven’t done the actual query side yet. That will be a half day’s work 
>> at most.
>> 
>> I think this client server approach is far better than native 
>> encryption, because I control the method and use a technique where 
>> even if someone tried brute force, or somehow discovered the key, 
>> they still could not decrypt the data, and wouldn’t know why.
>> 
>> Bob S
>> 
>> 
>> On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode < 
>> use-livecode@lists.runrev.com>
>> wrote:
>> 
>> Dear livecode programmers,
>> 
>> For a few years we ran an internal app that accessed a MariaDB 
>> database (no PHP or LiveCode Server middleware, just a raw connection) using 
>> SSL.
>> The server running the database is old, so we moved to a new one.
>> 
>> The new one comes with a Mysql 8 Database instead of MariaDB and the 
>> SSL encryption suddenly stopped working.
>> 
>> The new MYSQL database has a working SSL encryption cert (Let's encrypt).
>> 
>> There are the tests:
>> 
>> *From the server:*
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Strange behavior between Mysql, MariaDB and SSL.

[Heriberto Torrado via use-livecode]

Hi Panagiotis,

It makes sense, I'm going to try it.

Thank you very much for your recommendations.
I would like to say that this list is great.

Best,
Hery


-Original Message-
From: use-livecode  On Behalf Of 
panagiotis merakos via use-livecode
Sent: Wednesday, August 26, 2020 10:09 AM
To: How to use LiveCode 
Cc: panagiotis merakos 
Subject: Re: Strange behavior between Mysql, MariaDB and SSL.

Hello all,

This is because MySQL 8 supports a stronger authentication method based on 
SHA256, and this method is used by default.

LiveCode (as well as some other MySQL connectors/clients) do not support this 
authentication method yet. In this case, you could configure your MySQL 
installation to use the legacy authentication (password encryption) method.

See the suggested answers in this link:
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server/50961428

Hope this helps.

Kind regards,
Panos
--

On Tue, 25 Aug 2020 at 18:41, Bob Sneidar via use-livecode < 
use-livecode@lists.runrev.com> wrote:

> mySQL for which platform? Last I checked, the build for Windows did 
> NOT support encryption. There is a special branch that does, but I 
> could never get it to work.
>
> What I came up with is an agent that resides on the SQL server, built 
> in Livecode that listens for connections. It then handles the queries 
> locally and returns the data.
>
> The client and Server encrypt the data before sending it using a 
> method only I know, so it’s very secure. The communications are done 
> but I haven’t done the actual query side yet. That will be a half day’s work 
> at most.
>
> I think this client server approach is far better than native 
> encryption, because I control the method and use a technique where 
> even if someone tried brute force, or somehow discovered the key, they 
> still could not decrypt the data, and wouldn’t know why.
>
> Bob S
>
>
> On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode < 
> use-livecode@lists.runrev.com>
> wrote:
>
> Dear livecode programmers,
>
> For a few years we ran an internal app that accessed a MariaDB 
> database (no PHP or LiveCode Server middleware, just a raw connection) using 
> SSL.
> The server running the database is old, so we moved to a new one.
>
> The new one comes with a Mysql 8 Database instead of MariaDB and the 
> SSL encryption suddenly stopped working.
>
> The new MYSQL database has a working SSL encryption cert (Let's encrypt).
>
> There are the tests:
>
> *From the server:*
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Strange behavior between Mysql, MariaDB and SSL.

[Heriberto Torrado via use-livecode]

Hi Bob,

It worked from Linux, Mac, and Windows.

Your idea sounds really good, but to be honest, I'm pretty busy these days and 
I wouldn't like  to deal with making middleware.
I just looking for a quick fix.

Maybe in the future, I’ll have to do it.


Best,
Hery

-Original Message-
From: use-livecode  On Behalf Of Bob 
Sneidar via use-livecode
Sent: Tuesday, August 25, 2020 11:40 AM
To: How to use LiveCode 
Cc: Bob Sneidar 
Subject: Re: Strange behavior between Mysql, MariaDB and SSL.

mySQL for which platform? Last I checked, the build for Windows did NOT support 
encryption. There is a special branch that does, but I could never get it to 
work.

What I came up with is an agent that resides on the SQL server, built in 
Livecode that listens for connections. It then handles the queries locally and 
returns the data.

The client and Server encrypt the data before sending it using a method only I 
know, so it’s very secure. The communications are done but I haven’t done the 
actual query side yet. That will be a half day’s work at most.

I think this client server approach is far better than native encryption, 
because I control the method and use a technique where even if someone tried 
brute force, or somehow discovered the key, they still could not decrypt the 
data, and wouldn’t know why.

Bob S


On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

Dear livecode programmers,

For a few years we ran an internal app that accessed a MariaDB database (no PHP 
or LiveCode Server middleware, just a raw connection) using SSL.
The server running the database is old, so we moved to a new one.

The new one comes with a Mysql 8 Database instead of MariaDB and the SSL 
encryption suddenly stopped working.

The new MYSQL database has a working SSL encryption cert (Let's encrypt).

There are the tests:

*From the server:*

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Big Sur issues

[Dev via use-livecode]

I tried to build a stand alone to my desktop under Big Sur, but my Mac would 
not let me because of permissions or provisions or some other such new 
restriction (I haven’t paid my $99, so I’m not a real Dev as far as Apple is 
concerned) so I went back to Catalina and everything worked. 

Sent from my iPhone

> On Aug 26, 2020, at 11:59 AM, Richmond via use-livecode 
>  wrote:
> 
> I am running Lc 9.6.1 on macOS 11 beta 5 without a backward glance, happy to 
> say.
> 
>> On 26.08.20 5:54, Marty Knapp via use-livecode wrote:
>> I haven’t tried the LC development environment on Big Sur yet, just ran an 
>> already-built app. As far as the tabbed button, the issue is that the 
>> highlighted tab on Mac has a white background on Big Sur. So with the 
>> default white text you can’t see it, though the text is there.
>> 
>> Marty
>> 
 On Aug 25, 2020, at 6:04 PM, Colin Holgate via use-livecode 
  wrote:
>>> 
>>> In related news, I have an ARM64 Mac mini, and LC seems to be running ok.
>>> 
>>> With the Tab Panel issue, did you notice that as you dragged it into place 
>>> you could see the first tab’s text? That suggests that the highlighter for 
>>> the tab has transparency issues, not that text is missing.
>>> 
>>> WindowShape does work, but there is a card size backdrop. Also, while 
>>> LiveCard is open all of your desktop is obscured by a backdrop as well.
>>> 
>>> 
 On Aug 25, 2020, at 6:31 PM, Marty Knapp via use-livecode 
  wrote:
 
 Thanks Bob, I may have to take you up on that. Hopefully it will get 
 fixed. I did tinker with it a bit and found that if I set the 
 backgroundColor of the button to something dark the text shows up, so the 
 issue is the change in appearance to the active tab being white - so the 
 default white text  is there, just not visible against a white background.
 
 Marty
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Adding items to a group

[Bernard Devlin via use-livecode]

Whilst Mark provided what Phil needed, I too cannot believe how easy and
reliable Geoff's Navigator is.  I use it for everything. When I need an
Inspector a double-click on a line in Navigator brings it up.  I love it.

On Wed, Aug 26, 2020 at 7:14 PM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Also, Geoff Canyon wrote a GREAT utility called Navigator, which among
> other things, allows you to drag objects around in a hierarchical list. If
> you drag an object in a group to somewhere outside that group, into another
> group let’s say, it does all the relaying for you.
>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Adding items to a group

[Bob Sneidar via use-livecode]

Also, Geoff Canyon wrote a GREAT utility called Navigator, which among other 
things, allows you to drag objects around in a hierarchical list. If you drag 
an object in a group to somewhere outside that group, into another group let’s 
say, it does all the relaying for you.

I cannot tell you how many times this saved my bacon because I was editing 
groups and copy/pasting things into and out of other groups, and screwed it up.

Bob S


On Aug 26, 2020, at 2:27 AM, Mark Waddingham via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

On 2020-08-26 10:06, Jimmieson, Phil via use-livecode wrote:
One thing I’m considering is having a set of dummy hidden items
already in the group and making one of those look like the word the
user just dragged in - thus it’s already a member of the group and can
be scrolled etc with the rest. Can anyone think of any better ways of
doing it?

Take a look at the 'relayer' command in the dictionary. It allows you to move 
controls up and down the layer order and in and out of groups easily (without 
any need to ungroup/regroup).

Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ 
http://www.livecode.com/
LiveCode: Everyone can create apps

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Big Sur issues

[Richmond via use-livecode]

I am running Lc 9.6.1 on macOS 11 beta 5 without a backward glance, 
happy to say.


On 26.08.20 5:54, Marty Knapp via use-livecode wrote:

I haven’t tried the LC development environment on Big Sur yet, just ran an 
already-built app. As far as the tabbed button, the issue is that the 
highlighted tab on Mac has a white background on Big Sur. So with the default 
white text you can’t see it, though the text is there.

Marty


On Aug 25, 2020, at 6:04 PM, Colin Holgate via use-livecode 
 wrote:

In related news, I have an ARM64 Mac mini, and LC seems to be running ok.

With the Tab Panel issue, did you notice that as you dragged it into place you 
could see the first tab’s text? That suggests that the highlighter for the tab 
has transparency issues, not that text is missing.

WindowShape does work, but there is a card size backdrop. Also, while LiveCard 
is open all of your desktop is obscured by a backdrop as well.



On Aug 25, 2020, at 6:31 PM, Marty Knapp via use-livecode 
 wrote:

Thanks Bob, I may have to take you up on that. Hopefully it will get fixed. I 
did tinker with it a bit and found that if I set the backgroundColor of the 
button to something dark the text shows up, so the issue is the change in 
appearance to the active tab being white - so the default white text  is there, 
just not visible against a white background.

Marty


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Cross Platform Font Layout - current workarounds

[J. Landman Gay via use-livecode]

The problem was the lack of any mouseUp message at all when swiping 
horizontally, making it impossible to swipe for navigation over a scroller. 
We used a kludgy workaround, but the problem has been fixed now, so the 
next update can be completely cross platform without any diversions.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
On August 26, 2020 9:25:55 AM Ralph DiMola via use-livecode 
 wrote:



J,

I take it you referring to the premature mouse "down/up"s you get with
Android while perusing in a native scroller.




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Basic question about behaviors

[Keith Clarke via use-livecode]

Certainly best to avoid any made backwards.

> On 26 Aug 2020, at 15:20, Martin Koob via use-livecode 
>  wrote:
> 
> Is there a rule regarding puns?
> 
> Martin
> 
>> On Aug 26, 2020, at 9:30 AM, Paul Pystcat via use-livecode 
>>  wrote:
>> 
>> ROFL
>> 
>> THAT was gouda!
>> 
>> (I know, I know!  I broke one of the rules… no politics, no religion and no 
>> cheese)
>> 
>>> On Aug 26, 2020, at 9:09 AM, Mike Kerner via use-livecode 
>>>  wrote:
>>> 
>>> On Tue, Aug 25, 2020 at 12:41 PM Sean Cole (Pi) via use-livecode <
>>> use-livecode@lists.runrev.com> wrote:
>>> 
 I LOVE 'this me'. This extraordinary use of coding language is truly where
 LC  shines and why I love it so much, - sometimes. [sigh]
 
 Sean
 
>>> 
>>> and that's why your fonts break - because you "LOVE" - not "love", not
>>> "Love", not "l-o-l-o-l-o-v-e", but "LOVE" "this me".
>>> you're welcome.
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Basic question about behaviors

[Devin Asay via use-livecode]

Only cheese puns.

> On Aug 26, 2020, at 8:20 AM, Martin Koob via use-livecode 
>  wrote:
> 
> Is there a rule regarding puns?
> 
> Martin
> 
>> On Aug 26, 2020, at 9:30 AM, Paul Pystcat via use-livecode 
>>  wrote:
>> 
>> ROFL
>> 
>> THAT was gouda!
>> 
>> (I know, I know!  I broke one of the rules… no politics, no religion and no 
>> cheese)
>> 
>>> On Aug 26, 2020, at 9:09 AM, Mike Kerner via use-livecode 
>>>  wrote:
>>> 
>>> On Tue, Aug 25, 2020 at 12:41 PM Sean Cole (Pi) via use-livecode <
>>> use-livecode@lists.runrev.com> wrote:
>>> 
 I LOVE 'this me'. This extraordinary use of coding language is truly where
 LC  shines and why I love it so much, - sometimes. [sigh]
 
 Sean
 
>>> 
>>> and that's why your fonts break - because you "LOVE" - not "love", not
>>> "Love", not "l-o-l-o-l-o-v-e", but "LOVE" "this me".
>>> you're welcome.
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

Devin Asay
Director
Office of Digital Humanities
Brigham Young University

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Strange behavior between Mysql, MariaDB and SSL.

[matthias rebbe via use-livecode]

There are also free MySQL Connectors/ODBC available for different operating 
systems. The current ones are for Server 8.0,5.7 and 5.6.

https://dev.mysql.com/downloads/connector/odbc/

They connectors can be downloaded without the need to be logged in. So no need 
for an account registration at dev.mysql.com

Maybe this is an option instead of lowering the encryption level?

Matthias
-
Matthias Rebbe
Life Is Too Short For Boring Code

> Am 26.08.2020 um 16:08 schrieb panagiotis merakos via use-livecode 
> :
> 
> Hello all,
> 
> This is because MySQL 8 supports a stronger authentication method based on
> SHA256, and this method is used by default.
> 
> LiveCode (as well as some other MySQL connectors/clients) do not support
> this authentication method yet. In this case, you could configure your
> MySQL installation to use the legacy authentication (password encryption)
> method.
> 
> See the suggested answers in this link:
> https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server/50961428
> 
> Hope this helps.
> 
> Kind regards,
> Panos
> --
> 
> On Tue, 25 Aug 2020 at 18:41, Bob Sneidar via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> 
>> mySQL for which platform? Last I checked, the build for Windows did NOT
>> support encryption. There is a special branch that does, but I could never
>> get it to work.
>> 
>> What I came up with is an agent that resides on the SQL server, built in
>> Livecode that listens for connections. It then handles the queries locally
>> and returns the data.
>> 
>> The client and Server encrypt the data before sending it using a method
>> only I know, so it’s very secure. The communications are done but I haven’t
>> done the actual query side yet. That will be a half day’s work at most.
>> 
>> I think this client server approach is far better than native encryption,
>> because I control the method and use a technique where even if someone
>> tried brute force, or somehow discovered the key, they still could not
>> decrypt the data, and wouldn’t know why.
>> 
>> Bob S
>> 
>> 
>> On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode <
>> use-livecode@lists.runrev.com>
>> wrote:
>> 
>> Dear livecode programmers,
>> 
>> For a few years we ran an internal app that accessed a MariaDB database
>> (no PHP or LiveCode Server middleware, just a raw connection) using SSL.
>> The server running the database is old, so we moved to a new one.
>> 
>> The new one comes with a Mysql 8 Database instead of MariaDB and the SSL
>> encryption suddenly stopped working.
>> 
>> The new MYSQL database has a working SSL encryption cert (Let's encrypt).
>> 
>> There are the tests:
>> 
>> *From the server:*
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Basic question about behaviors

[Martin Koob via use-livecode]

Is there a rule regarding puns?

Martin

> On Aug 26, 2020, at 9:30 AM, Paul Pystcat via use-livecode 
>  wrote:
> 
> ROFL
> 
> THAT was gouda!
> 
> (I know, I know!  I broke one of the rules… no politics, no religion and no 
> cheese)
> 
>> On Aug 26, 2020, at 9:09 AM, Mike Kerner via use-livecode 
>>  wrote:
>> 
>> On Tue, Aug 25, 2020 at 12:41 PM Sean Cole (Pi) via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>> 
>>> I LOVE 'this me'. This extraordinary use of coding language is truly where
>>> LC  shines and why I love it so much, - sometimes. [sigh]
>>> 
>>> Sean
>>> 
>> 
>> and that's why your fonts break - because you "LOVE" - not "love", not
>> "Love", not "l-o-l-o-l-o-v-e", but "LOVE" "this me".
>> you're welcome.
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Strange behavior between Mysql, MariaDB and SSL.

[panagiotis merakos via use-livecode]

Hello all,

This is because MySQL 8 supports a stronger authentication method based on
SHA256, and this method is used by default.

LiveCode (as well as some other MySQL connectors/clients) do not support
this authentication method yet. In this case, you could configure your
MySQL installation to use the legacy authentication (password encryption)
method.

See the suggested answers in this link:
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server/50961428

Hope this helps.

Kind regards,
Panos
--

On Tue, 25 Aug 2020 at 18:41, Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> mySQL for which platform? Last I checked, the build for Windows did NOT
> support encryption. There is a special branch that does, but I could never
> get it to work.
>
> What I came up with is an agent that resides on the SQL server, built in
> Livecode that listens for connections. It then handles the queries locally
> and returns the data.
>
> The client and Server encrypt the data before sending it using a method
> only I know, so it’s very secure. The communications are done but I haven’t
> done the actual query side yet. That will be a half day’s work at most.
>
> I think this client server approach is far better than native encryption,
> because I control the method and use a technique where even if someone
> tried brute force, or somehow discovered the key, they still could not
> decrypt the data, and wouldn’t know why.
>
> Bob S
>
>
> On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode <
> use-livecode@lists.runrev.com>
> wrote:
>
> Dear livecode programmers,
>
> For a few years we ran an internal app that accessed a MariaDB database
> (no PHP or LiveCode Server middleware, just a raw connection) using SSL.
> The server running the database is old, so we moved to a new one.
>
> The new one comes with a Mysql 8 Database instead of MariaDB and the SSL
> encryption suddenly stopped working.
>
> The new MYSQL database has a working SSL encryption cert (Let's encrypt).
>
> There are the tests:
>
> *From the server:*
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: MySQL Client on

[panagiotis merakos via use-livecode]

Hello all,

This is because MySQL 8 supports a stronger authentication method based on
SHA256, and this method is used by default.

LiveCode (as well as some other MySQL connectors/clients) do not support
this authentication method yet. In this case, you could configure your
MySQL installation to use the legacy authentication (password encryption)
method.

See the suggested answers in this link:
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server/50961428

Hope this helps.

Kind regards,
Panos
--



On Wed, 26 Aug 2020 at 07:30, Todd Fabacher via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I am using revOpenDatabase with the "MySQL" parameter on LiveCode server.
>
> I am getting an error:
>
> *Client does not support authentication protocol requested by server;
> consider upgrading MySQL client*
>
> What can I do?? I am in a real hole as the version of mySQL was updated to
> the latest version 8.0 and now LiveCode server is NOT working???
>
>
> Please advise,
>
> Todd Fabacher
>
> PS I never got LC server to open a Postgres Database. I need some help
> here.
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Adding items to a group

[Jimmieson, Phil via use-livecode]

Thanks very much Mark, the relayer command is exactly what I needed.


relayer field “xx” to the front of group “thePoem” —adds the field to the poem 
group at the top of the group

relayer field “xx” after group “thePoem” —removes the field from the poem group 
and leaves it in front of the group


On 26 Aug 2020, at 10:27, Mark Waddingham via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

On 2020-08-26 10:06, Jimmieson, Phil via use-livecode wrote:
One thing I’m considering is having a set of dummy hidden items
already in the group and making one of those look like the word the
user just dragged in - thus it’s already a member of the group and can
be scrolled etc with the rest. Can anyone think of any better ways of
doing it?

Take a look at the 'relayer' command in the dictionary. It allows you to move 
controls up and down the layer order and in and out of groups easily (without 
any need to ungroup/regroup).

Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ 
http://www.livecode.com/
LiveCode: Everyone can create apps

--
Phil Jimmieson
University of Liverpool, Computer Science Department
Ashton Bldg, Ashton Street, Liverpool. L69 3BX
0151 795 4236


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: Cross Platform Font Layout - current workarounds

[Ralph DiMola via use-livecode]

J,

I take it you referring to the premature mouse "down/up"s you get with
Android while perusing in a native scroller. This is not a problem for me in
iOS. I put in a simple timer and it does not adversely affect iOS(or affect
it in any way) but does make the scrolling in Android work as expected. If
my supposition is correct I'm just wondering why you do it only for Android?

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of J. Landman Gay via use-livecode
Sent: Wednesday, August 26, 2020 3:08 AM
To: How to use LiveCode
Cc: J. Landman Gay
Subject: Re: Cross Platform Font Layout - current workarounds

On August 25, 2020 7:47:00 PM "Sean Cole \(Pi\) via use-livecode" 
 wrote:
>

> The projects deadline was Monday morning, which was completed. It 
> doesn't take away from the fact that next time I will face it all 
> again because LC won't fix the fundamentals. They don't live up to 
> their promises. They LIE (Jacque won't accept it, but they make many 
> claims on their site and to me in person that simply are proven 
> false). I'm just tired of people making me out to be irrelevant and any
claim I make to be false.

I don't think you're either irrelevant or incorrect, I only object to the
disrespect you've shown for people who work hard to bring us the tool we
love and depend on. Any bugs you found are certainly based in fact, as
you've shown. But there are much better ways to express discontent than what
we've seen here. I also understand that you are battling some personal
issues that may be out of your control, for which I am very sorry. But you
can't expect warm replies to rants that are hurtful to the very people who
attempt to help. Remember when we were worried about you and took up a fund
to help? You got mad at us for that too.

As for "code once, run anywhere," I've recently completed two apps in four
different flavors. I did not need to make any adjustments between the Mac
and Windows apps, or between the iOS and Android apps with one exception for
the native scroller on Android. And because the two products were siimilar
in many ways (one inspired the other,) I could re-use about 70% of the
desktop code to create the mobile apps.

Two mobile apps with identical code bases, except for native Android
scroller:
https://apps.apple.com/us/app/id1517450678
https://play.google.com/store/apps/details?id=com.friendshippress.wordathand

Mac and Windows apps with identical code bases:
https://thinkingstrings.com/interactive-explorations/  (click product titles
to see screenshots) And the mobile versions:
https://play.google.com/store/apps/details?id=com.thinkingstrings.tsmobile
https://apps.apple.com/us/app/id1496668393

There is one more thing that differs between Android and iOS apps, and
that's native appearance. Your font issue is similar to this. My mobile
products each contain a handler I call "setupUI" which adjusts the
appearance of all controls to conform to the platform's GUI. It sets the
properties of all buttons, fields, text, etc., whatever is necessary to make
the app look as expected for the OS. It's a long handler and I add to it as
I do the initial layout. Then I run the handler manually from the message
box before doing the build for each mobile platform. This is all cosmetic
work, and I don't consider it part of the code base because it isn't what
runs my apps. It just makes them look right. It's an automated way to switch
between iOS and Android appearance, with the advantage of allowing me to
flip between the two GUIs quickly during developent.

I generally don't need to do that for desktop apps, because LC handles most
of the GUI issues for me. The fact that you've found an edge case is
probably why you're so angry; we get spoiled because we take it for granted
that LC is going to do it all for us. The link Mark gave us explains the
reason (and though the author is working with HTML, the reason behind the
problem does apply to LC as well. It isn't as irrelevant as you thought.)

--
Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software |
http://www.hyperactivesw.com



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Basic question about behaviors

[Paul Pystcat via use-livecode]

ROFL

THAT was gouda!

(I know, I know!  I broke one of the rules… no politics, no religion and no 
cheese)

> On Aug 26, 2020, at 9:09 AM, Mike Kerner via use-livecode 
>  wrote:
> 
> On Tue, Aug 25, 2020 at 12:41 PM Sean Cole (Pi) via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> 
>> I LOVE 'this me'. This extraordinary use of coding language is truly where
>> LC  shines and why I love it so much, - sometimes. [sigh]
>> 
>> Sean
>> 
> 
> and that's why your fonts break - because you "LOVE" - not "love", not
> "Love", not "l-o-l-o-l-o-v-e", but "LOVE" "this me".
> you're welcome.
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Basic question about behaviors

[Mike Kerner via use-livecode]

On Tue, Aug 25, 2020 at 12:41 PM Sean Cole (Pi) via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I LOVE 'this me'. This extraordinary use of coding language is truly where
> LC  shines and why I love it so much, - sometimes. [sigh]
>
> Sean
>

and that's why your fonts break - because you "LOVE" - not "love", not
"Love", not "l-o-l-o-l-o-v-e", but "LOVE" "this me".
you're welcome.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Adding items to a group

[Mark Waddingham via use-livecode]

On 2020-08-26 10:06, Jimmieson, Phil via use-livecode wrote:

One thing I’m considering is having a set of dummy hidden items
already in the group and making one of those look like the word the
user just dragged in - thus it’s already a member of the group and can
be scrolled etc with the rest. Can anyone think of any better ways of
doing it?


Take a look at the 'relayer' command in the dictionary. It allows you to 
move controls up and down the layer order and in and out of groups 
easily (without any need to ungroup/regroup).


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Cross Platform Font Layout - current workarounds

[Richard Gaskin via use-livecode]

J. Landman Gay wrote:
> Any bugs you found are certainly based in fact, as you've shown.

That an anomaly is evident is known. The cause and possible remedies, 
however, remain open questions.


Though I briefly dabbled in sending hand-written Postscript to my laser 
printer back in the day (who didn't? Postscript was the future!), I've 
only briefly skimmed the file formats for Postscript and TrueType, and 
of course anyone lacking technical depth in this specialty will be at a 
disadvantage in diagnosing this.


So while I can't presume to know the inner details of what's in play 
here, it may be worth considering Mark Waddingham's input.  There's at 
least some indication he's familiar with how computers work, and he 
knows a thing or two about the internals of LiveCode. :)


Mark had suggested there may be elements within the font file itself 
which can be adjusted to improve rendering across different systems, 
specifically with regard to baseline differences on Windows:

http://lists.runrev.com/pipermail/use-livecode/2020-August/261448.html

A quick search to see how others deal with similar issues yielded a 
corroborating suggestion, described here:


   "One possible solution could be to download the Cutive font (I see
   it has a SIL license) and then run it through the Font Squirrel
   font-face generator. In 'Expert' mode there is an option to 'Fix
   Vertical Metrics' which might be what you are looking for."

And:

   "I came across this problem with a custom font that had been created
   for a client's brand. I opened the TTF font in Font Forge. The way I
   created uniformity with rendering was to adjust the values in
   Element->Font Info->OS/2->Metrics.
   
   I have very limited knowledge about fonts but this did fix my
   problem.

https://stackoverflow.com/questions/11726442/font-rendering-line-height-issue-on-mac-pc-outside-of-element

I can't help but wonder if guidance from experienced people who've 
considered this issue in depth may be worth exploring...




If for some reason making the custom font file more complete is 
prohibitive, LC is flexible enough to compensate in just one line by 
adjusting the margins property where needed:


 if the platform is Win32 then set the margins of btn "Label" to 4,8,4,4

Set the adjustment of the second (top) item to whatever you need and 
you're back in business in just a few seconds.


Of course that's just a quick workaround to keep production work on 
schedule at near-zero cost to any project that may need it.


For the longer term, if adding the Win-specific metrics others have 
found success with doesn't resolve this problem, let's explore it further.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Adding items to a group

[Jimmieson, Phil via use-livecode]

Hi folks,
The app I’m currently working on features a poem presented as a series of 
fields (each containing one word of the poem) all grouped together, so that the 
poem can be scrolled vertically by the user. I need to be able to add extra 
words to the poem as the user drags them in from a set of words above the poem 
area. Currently I am doing this by ungrouping the poem, adding the new field to 
the list of group items and then re-grouping everything.  I know you can 
reorder group items, and move things in from outside, but the documentation 
seems to suggest that the number of items in the group will stay the same - if 
one item is moved in, another will be moved out. Is there another way to add an 
item to a group, or is ungrouping then regrouping but with an additional item 
in the list of items the only way?


One thing I’m considering is having a set of dummy hidden items already in the 
group and making one of those look like the word the user just dragged in - 
thus it’s already a member of the group and can be scrolled etc with the rest. 
Can anyone think of any better ways of doing it?

Thanks

--
Phil Jimmieson
University of Liverpool, Computer Science Department
Ashton Bldg, Ashton Street, Liverpool. L69 3BX
0151 795 4236

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Cross Platform Font Layout - current workarounds

[J. Landman Gay via use-livecode]

On August 25, 2020 7:47:00 PM "Sean Cole \(Pi\) via use-livecode" 
 wrote:





The projects deadline was Monday morning, which was completed. It doesn't
take away from the fact that next time I will face it all again because LC
won't fix the fundamentals. They don't live up to their promises. They LIE
(Jacque won't accept it, but they make many claims on their site and to me
in person that simply are proven false). I'm just tired of people making me
out to be irrelevant and any claim I make to be false.


I don't think you're either irrelevant or incorrect, I only object to the 
disrespect you've shown for people who work hard to bring us the tool we 
love and depend on. Any bugs you found are certainly based in fact, as 
you've shown. But there are much better ways to express discontent than 
what we've seen here. I also understand that you are battling some personal 
issues that may be out of your control, for which I am very sorry. But you 
can't expect warm replies to rants that are hurtful to the very people who 
attempt to help. Remember when we were worried about you and took up a fund 
to help? You got mad at us for that too.


As for "code once, run anywhere," I've recently completed two apps in four 
different flavors. I did not need to make any adjustments between the Mac 
and Windows apps, or between the iOS and Android apps with one exception 
for the native scroller on Android. And because the two products were 
siimilar in many ways (one inspired the other,) I could re-use about 70% of 
the desktop code to create the mobile apps.


Two mobile apps with identical code bases, except for native Android scroller:
https://apps.apple.com/us/app/id1517450678
https://play.google.com/store/apps/details?id=com.friendshippress.wordathand

Mac and Windows apps with identical code bases:
https://thinkingstrings.com/interactive-explorations/  (click product 
titles to see screenshots)

And the mobile versions:
https://play.google.com/store/apps/details?id=com.thinkingstrings.tsmobile
https://apps.apple.com/us/app/id1496668393

There is one more thing that differs between Android and iOS apps, and 
that's native appearance. Your font issue is similar to this. My mobile 
products each contain a handler I call "setupUI" which adjusts the 
appearance of all controls to conform to the platform's GUI. It sets the 
properties of all buttons, fields, text, etc., whatever is necessary to 
make the app look as expected for the OS. It's a long handler and I add to 
it as I do the initial layout. Then I run the handler manually from the 
message box before doing the build for each mobile platform. This is all 
cosmetic work, and I don't consider it part of the code base because it 
isn't what runs my apps. It just makes them look right. It's an automated 
way to switch between iOS and Android appearance, with the advantage of 
allowing me to flip between the two GUIs quickly during developent.


I generally don't need to do that for desktop apps, because LC handles most 
of the GUI issues for me. The fact that you've found an edge case is 
probably why you're so angry; we get spoiled because we take it for granted 
that LC is going to do it all for us. The link Mark gave us explains the 
reason (and though the author is working with HTML, the reason behind the 
problem does apply to LC as well. It isn't as irrelevant as you thought.)


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode