Re: Livecode SQLite

2022-08-11 Thread Mark Waddingham via use-livecode
On 2022-08-11 16:16, Tom Glod via use-livecode wrote: I was interested in implementing a relatively new feature where you can index and query json documents and read the keys directly. https://dgl.cx/2020/06/sqlite-json-support I guess, if this is true, is there any documentation about which

Re: Images and arrays...

2022-08-11 Thread Phil Davis via use-livecode
Hi Paul, sorry I'm so late to the party. I think the best you can do is to capture & then reuse all the properties of the target image. I created a stack and imported an image. Then I ran this button script to make an exact replica of image 1. It worked: on mouseUp     put the

Re: mobileControl placeholderText?

2022-08-11 Thread Bob Sneidar via use-livecode
I see a similar thing when I have a pulldown menu without a label. It will display the menu button name by default. What I will do then is set the label to some prompt or else a space. It's pretty annoying to have to do that though. Bob S > On Aug 11, 2022, at 16:27 , Dan Friedman via

mobileControl placeholderText?

2022-08-11 Thread Dan Friedman via use-livecode
Is there a method to add placeholderText to a native mobile control field? So, if the fields' text is empty, it will show a string in gray. Like a Password field that when empty displays "Enter password here". Dan ___ use-livecode mailing list

Re: Livecode SQLite

2022-08-11 Thread Tom Glod via use-livecode
Hi Sean, The SQLite db i want to read json fields from is local. I know there are lots of workarounds. But in link I provided, the premise was using sqlite function to index and read a jason document's field. like so: sqlite> insert into t values(json('{"d":"42"}')); sqlite> select * from t

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread Klaus major-k via use-livecode
Hi Jaques, > Am 11.08.2022 um 20:13 schrieb J. Landman Gay via use-livecode > : > > On 8/11/22 7:44 AM, Klaus major-k via use-livecode wrote: >> FYI, iPhoneSafeAreaInsets() returns EMPTY on Android. > > It looks like it's for iOS only, Android isn't listed in the dictionary > reference.

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread J. Landman Gay via use-livecode
On 8/11/22 7:44 AM, Klaus major-k via use-livecode wrote: FYI, iPhoneSafeAreaInsets() returns EMPTY on Android. It looks like it's for iOS only, Android isn't listed in the dictionary reference. You'll probably need to use the working screenrect on Android. -- Jacqueline Landman Gay

Re: Fail to test new stack on Android device

2022-08-11 Thread Klaus major-k via use-livecode
Hi Jaques and Brian, > Am 11.08.2022 um 18:42 schrieb J. Landman Gay via use-livecode > : > > Brian was right, but it's the build number that matters rather than the > version number. You can either increase it, or delete the existing app on the > phone before installing the other one. yep,

Re: Fail to test new stack on Android device

2022-08-11 Thread J. Landman Gay via use-livecode
Brian was right, but it's the build number that matters rather than the version number. You can either increase it, or delete the existing app on the phone before installing the other one. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com

Datagrid and new Summer Bundle table/grid widgets

2022-08-11 Thread Paul Dupuis via use-livecode
To anyone with the Summer Bundle: The Datagrid object has a practical limit on the number of columns that I just reported as https://quality.livecode.com/show_bug.cgi?id=23875 (about 327 columns at a default column width of 100px due to the Group objects 32767px width limit) Do any of the

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread J. Landman Gay via use-livecode
Actually some Android phones have notches to imitate iPhones when Apple first introduced that. It wasn't very popular and most Android phones now use punch holes, but those also take up a bit of space, though not much. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software |

Re: Datagrid internal error

2022-08-11 Thread Paul Dupuis via use-livecode
On 8/10/2022 5:02 PM, Trevor DeVore via use-livecode wrote: 32,767 is the max for width as well. If there are enough columns it is possible that the DataGrid is rendering a group that exceeds this limit and hence the error. The DataGrid works around the limit when rendering rows, but not when

Re: Email via IMAP with HTML body from a template

2022-08-11 Thread Pi Digital via use-livecode
Thanks Charles I think that’s going to work. I’m going to do some testing and let you know how I get on. Sean > On 11 Aug 2022, at 07:23, Charles Warwick via use-livecode > wrote: > > Sorry, the last line of the replacement code should have been: > > put

Re: Livecode SQLite

2022-08-11 Thread Pi Digital via use-livecode
How was you accessing the database? Is it locally based? The ones I access are stored on a web host server with a cPanel. I have my own php I POST my sql request to and receive JSON back. I then use JSONtoArray or, recommended, JsonImport encapsulated in a ‘try’ structure to convert the data.

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread Klaus major-k via use-livecode
Hi Bob, > Am 11.08.2022 um 17:27 schrieb Bob Sneidar via use-livecode > : > > It seems to me, someone who has done zero mobile development, that this > function has no meaning on an android, and should therefore return empty to > avoid unanticipated runtime errors. There should be however a

Re: Email via IMAP with HTML body from a template

2022-08-11 Thread Bob Sneidar via use-livecode
I have to say, I've learned more about programming just from being a member of this list, than any book on the suject. Admittedly, I've read very few, as is manifestly evident when going back and re-reading my code. :-) Bob S > On Aug 10, 2022, at 23:23 , Charles Warwick via use-livecode >

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread Bob Sneidar via use-livecode
It seems to me, someone who has done zero mobile development, that this function has no meaning on an android, and should therefore return empty to avoid unanticipated runtime errors. There should be however a function to get the screen rects of an android. Does the effective working

Livecode SQLite

2022-08-11 Thread Tom Glod via use-livecode
Hi Folks, I have a question about Livecode's SQLite implementation. Looking at the official SQLite specs there seem to be json related functions. https://www.sqlite.org/json1.html but none of them seem to work using Livecode's driver. I was under the impression we had a full implementation I

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread Klaus major-k via use-livecode
Hi all, > Am 11.08.2022 um 14:44 schrieb Klaus major-k via use-livecode > : > Hi all, >> Am 15.07.2022 um 13:14 schrieb Klaus major-k via use-livecode >> : >> Hi friends, >> quick question, cannot test it myself in the moment. >> Will -> iPhoneSafeAreaInsets() >> a. work or >> b. throw an

Re: iPhoneSafeAreaInsets() and Android

2022-08-11 Thread Klaus major-k via use-livecode
Hi all, > Am 15.07.2022 um 13:14 schrieb Klaus major-k via use-livecode > : > > Hi friends, > > quick question, cannot test it myself in the moment. > > Will -> iPhoneSafeAreaInsets() > a. work or > b. throw an error when being used on Android? > > If a. I presume it will return "the

Re: Fail to test new stack on Android device

2022-08-11 Thread Klaus major-k via use-livecode
Hi Brian, > Am 11.08.2022 um 13:30 schrieb Brian Milby via use-livecode > : > > Change the app name or version string info. You have an app with the same > name and an earlier version already on the device. thanks, will try that! > Sent from my iPhone > >> On Aug 11, 2022, at 6:39 AM,

Re: Fail to test new stack on Android device

2022-08-11 Thread Brian Milby via use-livecode
Change the app name or version string info. You have an app with the same name and an earlier version already on the device. Sent from my iPhone > On Aug 11, 2022, at 6:39 AM, Klaus major-k via use-livecode > wrote: > >  > >> Am 11.08.2022 um 12:30 schrieb Klaus major-k via use-livecode

Re: Fail to test new stack on Android device

2022-08-11 Thread Klaus major-k via use-livecode
> Am 11.08.2022 um 12:30 schrieb Klaus major-k via use-livecode > : > > Hi all, > > I just tested an older stack on my Android device, everything is fine. > Then I created a new stack for a little stack and always get this error > when selecting "Test" in the LC dev menu. >

Fail to test new stack on Android device

2022-08-11 Thread Klaus major-k via use-livecode
Hi all, I just tested an older stack on my Android device, everything is fine. Then I created a new stack for a little stack and always get this error when selecting "Test" in the LC dev menu. Only script in that stack:

Re: iPhone simulators

2022-08-11 Thread Klaus major-k via use-livecode
Hi all, > Am 10.08.2022 um 19:30 schrieb Klaus major-k via use-livecode > : > > Hi Jaques, > >> Am 10.08.2022 um 19:23 schrieb J. Landman Gay via use-livecode >> : >> If I remember right you can have an iPhone and an iPad simulator open at the >> same time and choose between them, but if you

Re: Email via IMAP with HTML body from a template

2022-08-11 Thread Charles Warwick via use-livecode
Sorry, the last line of the replacement code should have been: put mimeEncodeAsMIMEMultipartDocument(tContent, “alernative”) into tBody (It was missing the "into tBody" at the end of the line) > On 11 Aug 2022, at 4:17 pm, Charles Warwick > wrote: > > Hi Sean, > > After reading your

Re: Email via IMAP with HTML body from a template

2022-08-11 Thread Charles Warwick via use-livecode
Hi Sean, After reading your second e-mail, I see that you don't want to use mimeEncodeFieldAsMIMEMultipartDocument to generate the HTML version of the e-mail body from a field as it does in that sample stack. If you want to create your own HTML and plain text versions of the e-mail body, you

Re: Email via IMAP with HTML body from a template

2022-08-11 Thread Pi Digital via use-livecode
Hi Charles I know how to add an attachment because there are tutorials on this. That is already being implemented. My question is on how to add in proper html body for the content. Does your stack show how to do that? Sean > On 11 Aug 2022, at 06:45, Charles Warwick via use-livecode >