Re: Speaking of Filter and Match...

2022-03-14 Thread Dick Kriesel via use-livecode
> On Mar 13, 2022, at 1:05 PM, J. Landman Gay via use-livecode > wrote: > > On 3/12/22 8:54 PM, Roger Guay via use-livecode wrote: >> I have a field with about a thousand lines with many duplicate lines, and I >> want to delete the duplicates. Seems like this should be simple but I am >>

Re: Speaking of Filter and Match...

2022-03-14 Thread Roger Guay via use-livecode
Ah, I see. Thank you again, Bob. Roger > On Mar 14, 2022, at 2:37 PM, Bob Sneidar via use-livecode > wrote: > > The UNIQUE clause is the UNIQUE combination of ALL the columns put together. > If I used: > > SELECT city,state UNIQUE FROM zip codes where state = 'CA' > > I would get every

Re: Speaking of Filter and Match...

2022-03-14 Thread Bob Sneidar via use-livecode
The UNIQUE clause is the UNIQUE combination of ALL the columns put together. If I used: SELECT city,state UNIQUE FROM zip codes where state = 'CA' I would get every unique city/state combination in CA, whereas if I used: SELECT state UNIQUE from zip codes where state = 'CA' I would get the

Re: Browser Widget and Images

2022-03-14 Thread Rick Harrison via use-livecode
Thanks! I had forgotten about "import as control" and about set the imagedata of image “my image”. set the imagedata doesn’t fit to the image’s object size though. I would probably have to resize the image beforehand. I also came across: put URL "binfile:///ExportedImageFile.png" into image

Re: Speaking of Filter and Match...

2022-03-14 Thread Roger Guay via use-livecode
Thanks ver much for your clarifications, Bob although I’m not sure I understand your correction. Roger > On Mar 14, 2022, at 8:48 AM, Bob Sneidar via use-livecode > wrote: > > Actually I must correct myself. That will not work because the unique value > column (typically an autoincrementing

Re: Speed up a slow loop

2022-03-14 Thread J. Landman Gay via use-livecode
One last thing. Scott Morrow was good enough to build for iOS and send a screenshot. I was very pleased to see it went cross-platform without any significant problems (thank you LC!) but the custom font was missing, which makes sense since I didn't include any external resources. That reminded

Re: Windows 11 incompatible?

2022-03-14 Thread Bob Sneidar via use-livecode
Ah thanks! That worked. Unfortunately there is no alternative for the Mac. :-( Bob S > On Mar 14, 2022, at 10:29 , Colin Holgate via use-livecode > wrote: > > No, you press Alt and tap the spacebar. Let go of both keys, then tap M, and > tap any arrow key. Move the cursor to see the

Re: revOpenDatabase over SSH tunnel?

2022-03-14 Thread Ben Rubinstein via use-livecode
I can't speak for most of the world, but in the past where we've directly connected to MySQL over the internet that's always been limited by IP (which as you doubtless know is built-in to the permissions system). The difference for me in this case is that instead of talking to a dedicated

Re: revOpenDatabase over SSH tunnel?

2022-03-14 Thread Richard Gaskin via use-livecode
matthias wrote: > As more and more servers do not allow remote MySQL access due to > security restrictions... It's almost like experienced hosting vendors and even the MySQL team itself are trying to tell us something... How does most of the world outside of the LC community handle remote DB

Re: Windows 11 incompatible?

2022-03-14 Thread Colin Holgate via use-livecode
No, you press Alt and tap the spacebar. Let go of both keys, then tap M, and tap any arrow key. Move the cursor to see the frontmost window is attached. > On Mar 14, 2022, at 11:25 AM, Craig Newman via use-livecode > wrote: > > Hi, Colin. > > Hmmm. I assume that all four of those keys are

Re: Windows 11 incompatible?

2022-03-14 Thread Craig Newman via use-livecode
Hi, Colin. Hmmm. I assume that all four of those keys are pressed at the same time? Craig > On Mar 14, 2022, at 11:52 AM, Colin Holgate via use-livecode > wrote: > > Yes it does. The M is for Move, if you’re working on a non-English system you > would type the first letter for Move in your

Re: Windows 11 incompatible?

2022-03-14 Thread Colin Holgate via use-livecode
Yes it does. The M is for Move, if you’re working on a non-English system you would type the first letter for Move in your language. > On Mar 14, 2022, at 9:47 AM, Craig Newman via use-livecode > wrote: > > Do I understand that, on Windows, typing those keys makes the frontmost > window

Re: Speaking of Filter and Match...

2022-03-14 Thread Bob Sneidar via use-livecode
Actually I must correct myself. That will not work because the unique value column (typically an autoincrementing integer) will not be unique for each record. Instead, assuming your lines of text are in a column called "textdata" SELECT textdata UNIQUE FROM... Bob S > On Mar 14, 2022, at

Re: Windows 11 incompatible?

2022-03-14 Thread Craig Newman via use-livecode
Hi. Do I understand that, on Windows, typing those keys males the frontmost window track the cursor??? Craig > On Mar 14, 2022, at 11:41 AM, Bob Sneidar via use-livecode > wrote: > > Is there a Macintosh equivalent to that?? > > Bob S > > >> On Mar 13, 2022, at 14:56 , Colin Holgate via

Re: Windows 11 incompatible?

2022-03-14 Thread Bob Sneidar via use-livecode
Is there a Macintosh equivalent to that?? Bob S > On Mar 13, 2022, at 14:56 , Colin Holgate via use-livecode > wrote: > > There is an issue on Windows that would show similar symptoms. That is, if a > window is opened off screen it’s as if the application has frozen. > > To see if that is

Re: Speaking of Filter and Match...

2022-03-14 Thread Bob Sneidar via use-livecode
They depend on the fact that arrays cannot have duplicate keys. Dumping the data into an SQL database and querying using the UNIQUE statement would do it too. SELECT * UNIQUE from ... Bob S > On Mar 13, 2022, at 13:16 , Roger Guay via use-livecode > wrote: > > Thank you Jacqueline, Alex

LC 10 DP2, does it already support the current multimedia architecture on Windows?

2022-03-14 Thread Klaus major-k via use-livecode
Hi all, the subject says it all. Means do we still need to install e.g. the LIBAV codecs to display MP4 video files? Or is this newer feature not yet implemented in DP2? Thanks for any hints. Best Klaus -- Klaus Major https://www.major-k.de https://www.major-k.de/bass kl...@major-k.de

Re: Windows EXE with browser about 160 MB?

2022-03-14 Thread matthias rebbe via use-livecode
I would say, this is because Microsoft did not embed CEF into Windows. So if you customers are asking why, tell them "because they are using Windows" and if they want to use a smaller download file they should use macOS. ;) I for myself would not have a problem with a download size of 170MB

Re: Browser Widget and Images

2022-03-14 Thread Klaus major-k via use-livecode
Hi Rick, > Am 14.03.2022 um 04:53 schrieb Jim Lambert via use-livecode > : > >> So accessing the URL of the image directly in the image object >> puts the image there, which is a good first step. >> >> How is it stored however? >> >> If one looks at the image source it still shows the URL.