HiDPI scaling on HTML5 works great !

Hello All For all doing HTML5 stuff, try the new 9.6.3 RC-1 Release, finally it can now do HiDPI scaling ! The stacks on webpages now look beautiful ! Thanks to all who made this happen ! Cheers Rolf ___ use-livecode mailing list use-livecode@lists.r

Re: mySQL 8

Tiemo, if i remember right this should be solving your issue. Before you write to or read from the db execute the following command revExecuteSQL databaseID, "SET NAMES 'utf8'" After that try to fetch data. The retrieved data has then to be decoded with textDecode(tRetrievedData,”UTF8”) e.g

That didn't hurt much . . .

No, not the dentist (although, mind you, I have visited the dentist 12 times in the last 3 months), but just lobbed a small donation to LiveCode Community from my PayPal account . . . Why don't you do that as well? ___ use-livecode mailing list use

Re: Stuck on native database functions

Yes, using the numeric placeholders will do that for you. > On Jul 7, 2021, at 4:43 PM, Terence Heaford via use-livecode > wrote: > > It also seems to do the escaping for you as it handled text containing commas > in the description ___ use-livecod

Re: Groups appear as buttons in Project Browser

Ordered by layer is active. Even dataGrid groups show up as buttons. Example @ https://www.dropbox.com/s/d9xbcstp1nwld8d/project_browser.png?dl=0 The “input fields” on these 2 cards are both groups of controls in sub-groups,

Re: Groups appear as buttons in Project Browser

Hello Andrew, Could it be the case you have chosen to order controls by name, instead of layer? (Click on the cog icon at the top right of the Project Browser, then choose "Order Controls By" -> ... ) Kind regards, Panos -- On Wed, 7 Jul 2021 at 15:53, Andrew at MidWest Coast Media via use-live

Re: Stuck on native database functions

It also seems to do the escaping for you as it handled text containing commas in the description All the best Terry > On 7 Jul 2021, at 16:40, Terence Heaford via use-livecode > wrote: > > The routine I have working is > > put "uniqueID,date,type,description,amount,balance,category" into t

Re: Stuck on native database functions

Mark, it certainly helps me. The routine I have working is put "uniqueID,date,type,description,amount,balance,category" into tFields put merge("INSERT INTO [[tAccountName]] ([[tFields]]) VALUES(:1,:2,:3,:4,:5,:6,:7)") into tSQL revExecuteSQL dbGetID(), tSQL, "tValues[uniqueID]", "tValues[date]

Groups appear as buttons in Project Browser

I have a stack that seems to have lost “groups” on several cards (but not all of them). They are still part of the structure but not recognized in the Tree View of the Project Browser. Rather than expandable groups in the PB, they show up as buttons. I can hover over and the tooltip calls them g

Re: Stuck on native database functions

Currently I have this working (Content of tSQL :) INSERT into TABLE1 ("complete", "todo", "itemDate", "category", "purgeDate", "dgOrder") values(:1, :2, :3, :4, :5, :6) revExecuteSQL gConnectID, tSQL, "ptheRowA[complete]", "ptheRowA[todo]", "ptheRowA[itemDate]", "ptheRowA[category]", "ptheRowA

mySQL 8

Hello folks, I have a DB hosted on AWS and need to move it from mySQL 5.6 to 5.7 because of AWS restrictions. In this context I am doing tests and also tried to see what my programs (LiveCode > PHP > mySQL) say about mySQL 8. For this I imported a current 5.6 dump into a mySQL 5.7 and into a

Re: Stuck on native database functions

Out of interest and not sure if it is relevant but I have received this error: "table myTable has 8 columns but 7 values were supplied" Yes the table has 8 columns in total but the first column is recID integer primary key autoincrement Surely it should not give this error because I do not prov

Re: Stuck on native database functions

Just tried this method revExecuteSQL myID, "insert into mytable values(:1,:2,:1)", "valueX",”valueY" It did not work put merge("[[quote]][[tUniqueID]][[quote]],[[quote]][[tDate]][[quote]],[[quote]][[tType]][[quote]],[[quote]][[tDescription]][[quote]],[[quote]][[tAmount]][[quote]],[[quote]][[tBa

Re: Stuck on native database functions

I have now tried your method with the tValues array directly and by deconstructing the array as below and it does not work. I have a recollection of not being able to get this to work with an array which is why I did the way I did. All the best Terry put q(tAccountName) into tAccountName pu