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,

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]",

Re: Stuck on native database functions

cause I do not provide the value as this is autoincrement All the best Terry > On 7 Jul 2021, at 08:50, Terence Heaford via use-livecode > wrote: > > Not sure what to try next ___ use-livecode mailing list use-livecode@lists.runrev.com

Re: Stuck on native database functions

ot;]) into tCategory > > put > merge("[[tUniqueID]],[[tDate]],[[tType]],[[tDescription]],[[tAmount]],[[tBalance]],[[tCategory]]”) > into tValues > > > put ":1,:2,:3,:4,:5,:6,:7" into tPlaceHolders > > put merge("INSERT INTO [[tAccountName]] VALUES(

Re: Stuck on native database functions

laceHolders]])") into tSQL put tSQL & " " & tValues revExecuteSQL dbGetID(),tSQL,tValues > On 7 Jul 2021, at 07:52, Terence Heaford via use-livecode > wrote: > > Here’s an example I have been using, not sure whether it will help: > > function dbAddTr

Re: Stuck on native database functions

Here’s an example I have been using, not sure whether it will help: function dbAddTransaction tAccountName,tValues put q(tAccountName) into tAccountName put q(tValues["uniqueID"]) into tUniqueID put q(tValues["date"]) into tDate put q(tValues["type"]) into tType put q(tValues["description"])

Re: LiveCode convert seconds to dateItems - year is out by 19?

Could it be something to do with the base date on the mac vs the base date of live code? I believe the base date on a mac is 1970, not sure what it is in live code? Terry > On 11 May 2021, at 13:59, Keith Clarke via use-livecode > wrote: > > Thanks Martin & Alex, > > I wasn’t aware of ‘the

Re: Polygons

I also have concluded this. If you miss out lines the opaque setting is irrelevant, it functions as being false. Is this a bug? My work around is two polygons one underneath (filled) and the other on top (with lines) You could just draw lines between the points that need them, using a

Re: Polygons

graphic the opaque property hasn't > changed. > > The only way I can think to overcome this is to create another graphic - > the same size as your first one, place it underneath your graphic and group > them together. Then when all sides are visible you can make this background > graphic

Re: Polygons

Thanks for your example. I am basic filling underneath a line chart to make an area chart but the closing lines to the x-Axis do not have a line. I concluded to draw a polygon twice once with fill and no lines, filled to the x-Axis and overlay it with a similar polygon but not

Re: Polygons

Hi >> Put a space in-between the points where you want the line in not be >> drawn. The shape is still constructed but with missing sides. >> >> Ian >> >> On Sun, 4 Apr 2021 at 15:02, Terence Heaford via use-livecode < >> use-livecode@lists.runrev.com>

Re: Polygons

the right angle > vertex and you're good to go. > > Ian > > >> On Sun, 4 Apr 2021 at 12:12, Terence Heaford via use-livecode < >> use-livecode@lists.runrev.com> wrote: >> >> If I draw a shape using a polygon, as an example assume a right angled >> tr

Polygons

If I draw a shape using a polygon, as an example assume a right angled triangle. Is it possible to hide the line between the points that make up the hypotenuse? Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit

Copy Script vs Behaviours

I have a card with a group which is to hold the objects when I create a chart. I have pie, bar and line chart substack libraries for each with the code contained in the stack script. When the user changes the type of chart I have been using: set the script of myGroup to the script of stack

Browser Widget

I believe the Browser Widget uses the native browser and in that case it uses the same code as Safari on MacOS? I have been using CanvasJS to create some charts and have been rendering the result in the Browser Widget using Set the URL of ….. These charts have been created on the computer and

Re: lock screen

rform the visual effect on the snapshot. You can then delete >> the snapshot when it is no longer needed. >> >> Best regards >> Tore Nilsen >>>> 22. jan. 2021 kl. 17:43 skrev Terence Heaford via use-livecode >>>> : >>> >>> Thanks

Re: lock screen

t; I’m sure someone else can be more clear, but when the engine gets to an idle >> state then locks should be cleared. In your example, it would probably >> clear at the end of that mouseUp handler, but aTest would completely run >> with the s

lock screen

Just looking for clarity with regard to lock screen. Is there only one state for the screen, either locked or not locked and when is that state changed. --- on mouseUp lock screen aTest end mouseUp on aTest — is the screen still locked here end aTest

Re: Building a Standalone MacOS App in 9.6.1

Hi Panos, That’s just a typo correction by MacOS mail. I actually applied the sudo call as you suggested. I have not replied because as a trial I have now done a full install of Xcode 12.3 from the App Store which as usual asked me to install the additional components. I did this. Now when I

Building a Standalone MacOS App in 9.6.1

I thought I would try to build a standalone app with the Community Edition in Catalina Many errors. Perhaps someone could shed some light. This error is the first. "replacing existing signature xcrun: error active developer path” I did see a comment on the LC Forum that suggested sudo

rotatedText widget and others

Has anyone tried using this widget? The “get the formatted height of widget” function does not appear to return the correct result. Whats the point of Livecode providing a widget that does not function correctly. It may rotate text but try aligning a number of these widgets without the

Printing a com.livecode.widget.browser

Clearly you can’t print a card that contains a browser widget as livecode is unable to do this. I don’t understand why because Safari can and I believe they are both based on webkit. Anyway I have come up with a semi acceptable workflow that involves. 1. Exporting a screenshot of the screen

Re: Segmented Control Widget

I will give this a try. It’s a shame that widgets always seem to be incomplete in one way or another. Thanks for your help. All the best Terry > On 9 Nov 2020, at 16:52, Bob Sneidar via use-livecode > wrote: > > In my custom tabbed object group, I had to put transparent buttons over the

Re: Segmented Control Widget

> On 5 Nov 2020, at 20:10, J. Landman Gay via use-livecode > wrote: > > I've done this with a custom control group, it should work with a widget too. > Calculate the rectangles (or at least the left and right edges) of each > segment and in a mouseEnter handler compare the mouseLoc to the

Re: Segmented Control Widget

for a bonus, it looks in Windows the > same as it loos on the Mac. Really, the Windows UI is really horrible for LC. > I just gotta say. It puts the Ugh in Ughly. > > Bob S > > >> On Nov 5, 2020, at 12:10 PM, J. Landman Gay via use-livecode >> wrote: >> >

Re: Segmented Control Widget

Thanks for your suggestion will give it a try. All the best Terry > On 5 Nov 2020, at 20:10, J. Landman Gay via use-livecode > wrote: > > On 11/5/20 1:47 AM, Terence Heaford via use-livecode wrote: >> I have been messing about with the Segmented Control Widget and ha

Segmented Control Widget

I have been messing about with the Segmented Control Widget and have been trying to apply a tooltip. I noted that the tooltip can only be applied to the whole control, it does not appear possible to have a tooltip for each segment. Is this possible and if so could someone please advise. All

hhOText(community.livecode.hermann.orientedtext)

I have been playing around with this community orientedText widget to see if it is suitable to be used for xAxis Labels at 45 degrees in a bar chart. I’m not sure I am using it correctly. I have set it up similar to this: repeat for each line tLabel in tDataLabels create widget (tLabel) as

Wrapping Text

If you have a field with one long word that is wider than the field it does not wrap, it truncates. Is there a solution to this? Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe

Re: Browser widget scrolling

> On 20 Jul 2020, at 21:06, J. Landman Gay via use-livecode > wrote: > > I'm not sure if this is a bug or a feature. It also seems to happen when the widget is empty? Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com

Browser widget scrolling

This does not appear to work: set the hScrollbar of widget “myBrowser" to false The scrollbar becomes visible when you drag resize a window. I was expecting there to ne no scrollbar at all. Also the checkboxes in the properties section (horizontal and vertical) do not work. They are always

Browser

That’s the solution I was thinking about. It’s probably necessary to capture the screen image at a larger size for printing as I suspect otherwise the printed output will be rather blurred. Thanks Terry > On 21 Jun 2020, at 13:46, Andrew at MidWest Coast Media > wrote: > > >> I am again

Browser

I am again looking at implementing Javascript charts within a LC browser. Looking at amCharts. Got a chart displaying easily within the browser widget. Tries to print the card but the widget does not print. So, I am left wondering if printing is impossible from within LC but then remembered

Re: HTML Colour Groups

I realise I used set in my post but will have used put in the script as you cannot use set and apply the script. Don’t know why it didn’t work originally, sorry for bothering you. All the best Terry > On 31 May 2020, at 17:38, Terence Heaford via use-livecode > wrote: > > Apol

Re: HTML Colour Groups

Apologies, works now. Don’t what I did incorrectly to make it not work. Thanks Terry > On 31 May 2020, at 17:25, Tore Nilsen via use-livecode > wrote: > > put "#FFC0CB" into tColor > > set the backgroundcolor of graphic 1 to tColor ___

Re: HTML Colour Groups

Our posts just crossed in the post Can you answer my question about using hex in a variable when setting an objects colour. Thanks Terry > On 31 May 2020, at 17:06, Mark Wieder via use-livecode > wrote: > > available colors. ___ use-livecode

Re: HTML Colour Groups

ick > > > > >> On May 31, 2020, at 5:39 AM, Terence Heaford via use-livecode >> wrote: >> >> I thought LC supported HTML Colour Names? >> >> I have been using the Colour Name Groups found here >> >> https://www.w3schools.com/col

HTML Colour Groups

I thought LC supported HTML Colour Names? I have been using the Colour Name Groups found here https://www.w3schools.com/colors/colors_groups.asp and found that some of the colours do not work in LC. For example “Crimson” reports an error in

Re: Go to card has become slow

There is an interesting debate here as to whether it is necessary or not to wrap select statements in transactions for optimisation: https://stackoverflow.com/questions/7349189/optimizing-select-with-transaction-under-sqlite-3

Re: Go to card has become slow

slowed down in the first place but… all is now well until it happens again. Thanks Terry > On 3 Apr 2020, at 09:42, Mark Waddingham via use-livecode > wrote: > > On 2020-04-03 09:25, Terence Heaford via use-livecode wrote: >> Fortunately I have Time Machine running on my mac. &

Re: Go to card has become slow

wrote: > > I have seen delays when going to a card containing a large image with Resize > Quality set to “Best”. It was more of an issue on a mobile device, but it’s > worth looking into. > > Devin > >> On Apr 2, 2020, at 1:27 PM, Terence Heaford via use-livecode &

Go to card has become slow

I have a project that opens at a particular card. When I go to another card (any card) it’s very snappy. When I return to the original card (from any card) I have noticed a second or two delay before it happens. There would appear to be nothing in any script that would account for this. Can

Re: Ordering text

the result in the database column. WY > quicker. > > Bob S > > > On Apr 1, 2020, at 12:13 PM, Terence Heaford via use-livecode > <mailto:use-livecode@lists.runrev.com><mailto:use-livecode@lists.runrev.com > <mailto:use-livecode@lists.runrev.com>>>

Re: Ordering text

This actually works but is very slow (> 800ms) put merge("SELECT *,SUM (amount) OVER (ORDER BY recID) AS balance FROM myAccountName") into tSQL I have settled on my earlier suggestion Earlier suggestion results in 20ms performance. - I believe it’s sorted

Re: Ordering text

; , wrote: >> I believe the reason for the delay comes from the fact that when sorted >> descending, you put tRec & CR before tCellData. Tp put something before a >> container is slower than putting something after a container. >> >> Regards >> Tore Nilsen

Ordering text

I have approx. 7000 lines of tab delimited data. When I execute the code snippet below if the sort order is descending it takes approx 120 milliseconds otherwise it takes 20 milliseconds to process. Can someone explain why and perhaps come up with a faster solution. Thanks Terry ——

Re: Object Fonts

I may have found the problem. Datagrid helper. When I used that it changed to my selection. Does this mean Datagrid Helper changes the font in a different place than LC IDE? Thanks Terry > On 19 Dec 2019, at 08:24, Terence Heaford via use-livecode > wrote: > > Why ca

Object Fonts

Why can’t I choose Helvetica Neue as an object font? Whenever I do it turns out italic. Can someone point me in the right direction please. MacOS Catalina , LC 9.5.1, Community. Thanks Terry ___ use-livecode mailing list

Re: Table Text Livecode vs .....

Here’s another interesting observation. My table is set to Lucida Grande 13 I have some popup menus on the card set to Lucida Grande 13 Why does the text in the popup menus appear larger than the text in the Table? Thanks Terry > On 18 Dec 2019, at 08:00, Terence Heaford via use-livec

Re: Table Text Livecode vs .....

reformatting of every card > in a humungous stack like the one I’m dealing with! > > All the best. > > Sean Cole > Pi Digital Prod Ltd > >> On 17 Dec 2019, at 19:23, Terence Heaford via use-livecode >> wrote: >> >> Firstly I have an iMac, none retina. >

Re: Table Text Livecode vs .....

Firstly I have an iMac, none retina. 1. Just checked Pages & Numbers and they both appear similar to LC. 2. Then checked TextEdit and that appears the same as Filemaker. The rendering of the text in Filemaker & TextEdit appears to my poor eyesight to be more black (if that is possible). My

Re: Table Text Livecode vs .....

Bob Sneidar via use-livecode > wrote: > > It's clear the pixels in one are much larger and that's the one where the > actual letters are smaller! Are these the same font size? > > Bob S > > >> On Dec 17, 2019, at 06:55 , Terence Heaford via use-livecode >> w

Re: Table Text Livecode vs .....

ges. > > Sean Cole > Pi Digital Prod Ltd > >> On 17 Dec 2019, at 08:31, Terence Heaford via use-livecode >> wrote: >> >> Can someone explain why the text in a livecode table displays more poorly >> on screen than other native macos apps? >> >

Table Text Livecode vs .....

Can someone explain why the text in a livecode table displays more poorly on screen than other native macos apps? Here are two screen grabs that display the difference. Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com

AutoUpdater

Why does LiveCode’s AutoUpdater run even though it is turned off in preferences? Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Stack Height/Menubar

Hi Klaus, What an excellent suggestion. Copied my menubar to a card that I never use and pointed everything to that and its associated scripts and this has now sorted the problem. Named my Card “MenusAndImages”. Keep my button icons here as well. Sorted. Thanks for your help Terry > On

Re: Stack Height/Menubar

izes. > You can also use 'effective' with ofther stack position/coordinate > properties (I think) like top,left, right, bottom, height, width. > > > > On 11/15/2018 10:03 AM, Terence Heaford via use-livecode wrote: >> This post is regard the use of Livecode on MacOS(LC 9.0.1) >

Re: Stack Height/Menubar

This all basically means you can’t place anything in the bottom 22 of the card. Terry > On 15 Nov 2018, at 15:03, Terence Heaford via use-livecode > wrote: > > This post is regard the use of Livecode on MacOS(LC 9.0.1) > > When you set the height of this stack t

Stack Height/Menubar

This post is regard the use of Livecode on MacOS(LC 9.0.1) When you set the height of this stack to 800 (for example) The height of this card in the property inspector is 822 and is also returned as 822 in script. This seems to be as a result of the menubar position on none mac systems. I

Re: Open recent File Menu

> On 8 Jun 2018, at 16:56, Klaus major-k via use-livecode > wrote: > > set the cRecentStackPaths of stack "revpreferences" to empty Thanks very much. Terry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to

Open recent File Menu

For the life of me I cannot remember how to clear this menu? Most Mac Apps have a Clear Menu item at the foot of the drop down menu, why can’t Livecode? Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url

Re: DataGrid Column Labels

It’s weird but placing this in the preopenCard script sorts out the issue for now. set the dgProp[ "column labels" ] of group “myTable" to the dgProp[ "column labels" ] of group "myTable" All the best Terry > On 18 Apr 2018, at 18:43, Terence Hea

Re: DataGrid Column Labels

All my tables just say button id 1005 of stack "revDataGridLibrary" Did the copy and paste thing and it did not work. ?? Terry > On 18 Apr 2018, at 15:53, Bob Sneidar via use-livecode > wrote: > > 2. Copy what's in the message

Re: DataGrid Column Labels

I get the behavior of a datagrid that IS working, then set > the behavior of the datagrid that ISN'T working to that behavior. I'm not > sure why but there seem to be more than one datagrid behavior object floating > around. > > Bob S > > >> On Apr 16, 2018, at 08:29 , Teren

Re: DataGrid Column Labels

I see what you have done and when I create a new project with LC9 and create a Data Grid I do not have any problems. The issue I have is when I create a Data Grid within a project that has been created with an earlier version of LC. If this is relevant I do not know. For the moment I have

Re: DataGrid Column Labels

spect these are the culprits because these are associated with the two > new tables I have added to the project. > > Where there problems are, I don’t know. > > > Thanks > > Terry > > >> On 14 Apr 2018, at 08:17, Terence Heaford via use-livecode >> <use-li

Re: DataGrid Column Labels

08:17, Terence Heaford via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Thanks > > Will have a look at that although the column does not have a column behaviour. > > I have changed the properties of the header with DGH but the props listed in > the P

Re: DataGrid Column Labels

s were working fine! > What I did to fix it is I got the behavior of another datagrid that DID work, > and set the behavior of the errant datagrid to the long id of that. > > Bob S > > >> On Apr 13, 2018, at 11:52 , Terence Heaford via use-livecode >> <use-

DataGrid Column Labels

I have just started having an issue with the Column Labels on some newly created tables. Basically they do not show unless I press “Refresh Data Grid" in the Property Inspector. If I then shut down LiveCode and relaunch it they have gone missing again. I am using the community edition of LC9

Re: DataGrid Horizontal Scrollbar

> On 31 Jan 2018, at 15:46, Tom Glod via use-livecode > wrote: > > i just thought you needed the ability to scroll the header while there is > no data in the grid.. so it doesn't defeat the purpose just over-rides > it .maybe i mis-understood what you

Re: DataGrid Horizontal Scrollbar

> On 29 Jan 2018, at 19:29, Tom Glod via use-livecode > wrote: > > set the disabled of the scrollbar to false once you find the name of it. Yes, that’s certainly possible but surely defeats the point of the auto setting. All the best Terry

DataGrid Horizontal Scrollbar

When I have a DataGrid with the show horizontal scrollbar set to auto the scrollbar is hidden when the DataGrid contains no rows. On the face of it this seems correct but when the DataGrid header is wider than the window the scrollbar is still not visible and hence it is not possible to see

Datagrid2

Submitted again due to incorrect address Apologies for previous post I was just trying out LC9 DP11 and noted in the LC Blog that Datagrid2 is available for testing. I am a little confused because on opening DP11 I could only find the previous Datagrid. Is DG2 a widget

Datagrid2

I was just trying out LC9 DP11 and noted in the LC Blog that Datagrid2 is available for testing. I am a little confused because on opening DP11 I could only find the previous Datagrid. Is DG2 a widget or rolled into the old Datagrid format? Is DG2 available in the community edition? Could

Printing a Browser widget

Has there been any progress with the Browser Widget being incorporated into print card? If not is there a timescale for this? Thanks Terry ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe

Re: Capturing screen into image

That’s cracked it. Thanks very much to everyone who has contributed. Not thought about this much but is having the print margins default to 72 the best option for most situations? This is one for better minds than I. Anyway, thanks again to all. Terry > On 2 Jul 2017, at 02:51, Paul

Re: Capturing screen into image

Hi, Thanks for your suggestion but I am afraid it’s not working here: I have prepared a short movie on dropbox so you can see what happens when I print it and then open as PDF in MacOS Preview. Not sure at all what is going wrong. Could it be something to do with the scaling in the amCharts

Re: PrintPaperRectangle

t; of 587 and add 8 and you get 595 > > > On 7/1/2017 2:58 AM, Terence Heaford via use-livecode wrote: >> Thanks for your explanation. It does seem logical. >> >> But where does 587 come from in 8,8,834,587 ? >> >> A4 is 553. >> >> Thanks >

Re: Capturing screen into image

age. > > Kind regards, > > Mark Schonewille > http://economy-x-talk.com > https://www.facebook.com/marksch > > Buy the most extensive book on the > LiveCode language: > http://livecodebeginner.economy-x-talk.com > > Op 30-Jun-17 om 20:38 schreef Terenc

Re: PrintPaperRectangle

Thanks for your explanation. It does seem logical. But where does 587 come from in 8,8,834,587 ? A4 is 553. Thanks Terry > On 30 Jun 2017, at 20:56, Bob Sneidar via use-livecode > wrote: > > Almost no toner based printer can do this. It's called Full

Fwd: Printing a Widget Browser

> Begin forwarded message: > > From: Terence Heaford > Subject: Re: Printing a Widget Browser > Date: 30 June 2017 at 19:21:14 BST > To: jonathandly...@gmail.com > > >> On 29 Jun 2017, at 20:37, jonathandly...@gmail.com wrote: >> >> Could you export to a file, launch

Fwd: Printing a Widget Browser

> Begin forwarded message: > > From: Terence Heaford > Subject: Re: Printing a Widget Browser > Date: 30 June 2017 at 19:19:38 BST > To: jonathandly...@gmail.com > > >> On 29 Jun 2017, at 20:50, jonathandly...@gmail.com wrote: >> >> Also, have you tried this: >> >> Do

Capturing screen into image

This script does not work. export snapshot from rectangle (the rect of widget "Browser") to pictVariable as PNG set the rect of image "myImage" to the rect of widget "Browser" put pictVariable into image "myImage" print card from topleft of image "myImage" to bottomRight of image “myImage"

PrintPaperRectangle

LC 8.1.4, MacOS 10.12.5 Print Paper Rectangle returns 8,8,834,587 for A4 Landscape. This does not seem to match the description in the dictionary? "The printPaperRectangle property contains four comma-separated integers and is in points. The default value reflects the default values of the

Printing a Widget Browser

Not posted for a long time but still keeping an eye on progress. Is there any chance of printing a Browser Widget any time soon? This code just gives a grey printout. I am waiting patiently for this so that I can use for example amCharts within LiveCode. I have implemented a print routine by