Re: LiveCode and SQLite performace
Hi Michael, Haven't come across that before. 600k records is a large number but I've seen dbs with millions of records in them so it's not unusual. In any case, almost every performance problem I've seen revolves around either selecting or changing data not simply opening the database. Try executing a PRAGMA integrity_check command after you open the database. It checks out the physical integrity of the database and returns information about any errors it finds. If that doesn't reveal anything, there are a number of PRAGMA statements that affect cache size, buffer sizes, etc which might help but I'm not very familiar with them. If needed, I can post your problem on the sqlite mailing list and see if anyone can help. What platform is this running on? Pete On Tue, Jul 21, 2015 at 4:59 PM Michael Doub miked...@gmail.com wrote: I need some database consulting help. I have created an SQLite database that has 4 fields: ID, URL, tag, local. IS is integer, unique, URL is text not null unique and tag and local are just text. I have 600,000+ records. I use the ID to access each record in most cases or I am filtering trying to find records based on the contents of the tag, URL or local fields. It seems to take forever to open the database. This is normal? I am primarily using the database to make sure that I do not have non-unique URLs, adding performance and selects seem reasonable. I am just surprised about the open performance Does opening the database load a lot of information into memory thus the long delay? Could I have created the database in someway that is not optimal, thus causing the delay? This is not a livecode issue as I am seeing the same delay when I open the database with sqlitebrowser. Any advise or incites in how sqlite actually works would be appreciated. Regards, Mike ___ 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: New License Idea for Hobbyists
Roger Guay wrote: Well, correct me if I'm wrong, but I am under the impression that Apple will not accept open source code, so I think I need a commercial license. Plus, I think this would give RR a more reliable income scheme than the occasional unsolicited donation. The company used to have an option specifically for that edge case, in which someone wanted to participate in open source and also include iOS among their deployment platforms, along with a few other perks as well, for US$99: http://livecode.com/tag/livecode-membership/ Given how well the other concerns are already addressed, this Membership option seemed useful as it covered the one use case not otherwise handled. I can't find it at the store, however. I've CC'd Ben here to see if he can chime in on what happened to that Membership program. -- Richard Gaskin LiveCode Community Manager rich...@livecode.org ___ 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: New Indy License Pricing
Andrew Kluthe wrote: Richard, It's not an issue of earnestness or integrity but of what has been delivered vs what we were told was going to be delivered. There is a huge gap between the way things looked when they were presented to us in April 2013 and the way they look today. ... Will things all be delivered? Yeah, probably. But how many more major version numbers will it take? We agree that the Road Map as presented and added to since April 2013 is being followed faithfully, and the only question you and I have (in contrast to those who try to raise doubts about their integrity) isn't at all about what is being delivered, but merely when. I mentioned Steven McConnell because not since Fred Brooks have I found a writer whose explorations of software project management are as well researched. In his book Code Complete he notes that more than 80% of software projects are over budget, many by a factor of four and significant minority by a factor of 16, sometimes more. Variance between estimated time and actual is affected by many things, but one of the biggest is the scope of unknowns introduced by dependency on code beyond the control of the team. With seven platform APIs to map LC's internal logic to, we can expect variance to be on the higher end of industry averages. Software project estimation remains a key focus of some of the best minds of our industry specifically because getting it right consistently proves elusive. There's a lot that could be said about the challenges inherent in estimating, and methods to reduce variance. And anyone here who's been able to consistently beat industry averages is encouraged to share their demonstrated experience here. For myself, when I'm able to beat industry averages in large part it's because 90% of my code was written in Edinburgh over many years by people much smarter than me. That's a big part of what keeps me patient with the anticipatable delays with LC's Road Map delivery. How many of them will turn into additional kickstarters when their revenue stream dries up? I doubt there'd be much ROI in a third crowd-funding effort, so I'm not all that worried about that. As for the second one, they promised a proof-of-concept build within a year of closing, and it was delivered last week. Sure, it has a long way to go until it's production-ready, as we would expect. But until it's released any contributions to that campaign for licenses haven't kicked in yet, so that one isn't a concern for me. Are many of these features going to end up being mac specific when it gets down to finding out how hard they are to make cross platform? As much as I enjoy my Macs, I'm doing so much more work on Ubuntu these days that that's an ongoing question for me too. But in practice I've been relieved to find that I'm just not seeing that. So far most of the 2500+ fixes and enhancements put into place over the last year and a half benefit all platforms. Any Mac-specific work at this point seems to be limited to the minimum needed to maintain that platform as a viable deployment option, such as replacing QT after Apple deprecated it and moving to Cocoa as that became necessary. On the contrary, as an Ubuntu user I've been more than pleased by the team's efforts with greater GDK integration in v7. And since like many of us here I make most of my money from Windows deployments, it's been good to see how much attention they've been giving the rendering subsystem to maintain compatibility there with newer display APIs. That's what I mean when I say trust. Brand fetishism just isn't enough to live on anymore. The actual performance as a company lately, frankly, sucks. Since, I know you are going to want examples of why someone might feel this way: - On-rev (do I really need to say more? Search the list for on-rev) On-rev is a separate service that doesn't affect my use of LiveCode, and given how cheap and plentiful hosting is these days I've never used it as I'm already up to my armpits in servers. That said, it is course run by the same company, so I can appreciate how subscribers to that service may have a different view of the company than I do, because we rely on them for different things. There's a lot to be said for the bowling alley strategy Geoff Moore describes in The Gorilla Game. But I don't run Kevin's company and he doesn't run mine, and we both like it that way. I got out of the hosting business 15 years ago when the margins plummeted. On balance I feel compelled to note that I have several friends who are quite pleased with the service, and since I've never used it myself I have no opinion about it beyond that. -The documentation is scattered, sparse, and most of the code samples are images. Fun. A complete overhaul of all documentation has been underway for some time (it's not a small task), and as recently as last week I met with Kevin to discuss ways we
Re: Behavior question
You double-checked the path to the behavior, right? If there are any other handlers in the behavior, do those work? On 7/22/2015 12:48 AM, Peter Haworth wrote: Right, the unhandled is what is throwing me, plus the fact that using send results in a runtime error. As I've found, what I'm doing works in a simplified environment so for some reason, this particular behavior isn't being resolved, just can't figure out why. On Tue, Jul 21, 2015 at 8:44 PM Mark Wieder mwie...@ahsoftware.net wrote: On 07/21/2015 04:55 PM, Peter Haworth wrote: I just tried a very simple test in another stack and it worked so there must be something in the stack with the problem that is preventing the behavior from being resolved. Well, it *should* work. In most cases anyway. The only thing I can think of that would mess it up is if you have a loadData handler somewhere in a frontscript and it isn't passing the message on when it's done. I think of behavior scripts as private backscripts of the parent object. So it should be the next thing in the message path unless a frontscript grabs the message first and never lets go. I don't think that explains the unhandled status though, so there may be something else going on. -- Mark Wieder ahsoftw...@gmail.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 -- 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
Re: Behavior question
Is this one of the behaviors that's dynamically assigned at startup or when a stack opens? I wonder if it's assigned too soon, before everything has finished loading. On 7/22/2015 1:03 PM, Peter Haworth wrote: Yep, checked it over and over, plus the spelling of the command. My lcStackbrowser plugin has a feature where you click on an icon for an object's behavior and it automatically opens its script - that opens the correct script so pretty sure all is OK. I tried dispatching to a different handler - same result. I have got this to work however. I deleted the behavior reference and reset it. After that, all works well again. But after quitting LC and starting it again, the behavior is no longer resolved. For some reason, the behavior is not being resolved at runtime by LC and deleting and resetting it forces it to be resolved. On Wed, Jul 22, 2015 at 9:57 AM J. Landman Gay jac...@hyperactivesw.com wrote: You double-checked the path to the behavior, right? If there are any other handlers in the behavior, do those work? On 7/22/2015 12:48 AM, Peter Haworth wrote: Right, the unhandled is what is throwing me, plus the fact that using send results in a runtime error. As I've found, what I'm doing works in a simplified environment so for some reason, this particular behavior isn't being resolved, just can't figure out why. On Tue, Jul 21, 2015 at 8:44 PM Mark Wieder mwie...@ahsoftware.net wrote: On 07/21/2015 04:55 PM, Peter Haworth wrote: I just tried a very simple test in another stack and it worked so there must be something in the stack with the problem that is preventing the behavior from being resolved. Well, it *should* work. In most cases anyway. The only thing I can think of that would mess it up is if you have a loadData handler somewhere in a frontscript and it isn't passing the message on when it's done. I think of behavior scripts as private backscripts of the parent object. So it should be the next thing in the message path unless a frontscript grabs the message first and never lets go. I don't think that explains the unhandled status though, so there may be something else going on. -- Mark Wieder ahsoftw...@gmail.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 -- 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 -- 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
New Indy License Correction
Hi Heather, I just took advantage of the 2 years of Indy for $499. My old license wasn’t supposed to expire until March of 2016 according to my account when I logged into it. This new license told me it would expire two years from now July of 2017. I believe according to Kevin’s email to me that these 2 years should be tacked onto the end of my other license. Could you please update my account accordingly, and send me a confirmation of what my new expiration date will be? Thanks, Rick On Jul 14, 2015, at 4:12 AM, Heather Laine heat...@livecode.com wrote: Dear list folks, Just to put this one to bed - the Founders package always was and will remain, 100GB storage. If you do not see that in your Founders account then there is either a reporting error or a setup error, both of which we will be happy to correct for you if you email us at the support address for on-rev: supp...@on-rev.com mailto:supp...@on-rev.com (or on-...@runrev.com mailto:on-...@runrev.com will also work). I do not think cPanel is reporting space usage correctly by the sound of it. Regards, Heather Heather Laine Customer Services Manager LiveCode Ltd www.livecode.com On 12 Jul 2015, at 05:29, Simon si...@asato-media.com wrote: Ok I do have to admit that during the HTML5 crowdfunding I went with the Lifetime Pro and there was in the fine print that it meant 10 years. Now for me that indicated some sort of legal speak and that there was probably some enforceable case that 10 years could be deemed a lifetime. But then there is also the case of when I found the Enterprise edition was for $500K (or 50K? some revenue cap) or less on the website. Heather quickly had that fixed. So that fine print may have been wrong. Anyways, I like LiveCode Ltd. so not a big problem. I wonder about the people who have 100 GB storage because though I can't find it, there was a post by Kevin when this came up before (during the move to France) that said we would retain our 50 GB and he'd get right on it. Simon -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Has-the-founders-on-rev-package-been-reduced-to-25-GB-tp4693856p4693902.html Sent from the Revolution - User mailing list archive at Nabble.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 ___ 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: Behavior question
Yep, checked it over and over, plus the spelling of the command. My lcStackbrowser plugin has a feature where you click on an icon for an object's behavior and it automatically opens its script - that opens the correct script so pretty sure all is OK. I tried dispatching to a different handler - same result. I have got this to work however. I deleted the behavior reference and reset it. After that, all works well again. But after quitting LC and starting it again, the behavior is no longer resolved. For some reason, the behavior is not being resolved at runtime by LC and deleting and resetting it forces it to be resolved. On Wed, Jul 22, 2015 at 9:57 AM J. Landman Gay jac...@hyperactivesw.com wrote: You double-checked the path to the behavior, right? If there are any other handlers in the behavior, do those work? On 7/22/2015 12:48 AM, Peter Haworth wrote: Right, the unhandled is what is throwing me, plus the fact that using send results in a runtime error. As I've found, what I'm doing works in a simplified environment so for some reason, this particular behavior isn't being resolved, just can't figure out why. On Tue, Jul 21, 2015 at 8:44 PM Mark Wieder mwie...@ahsoftware.net wrote: On 07/21/2015 04:55 PM, Peter Haworth wrote: I just tried a very simple test in another stack and it worked so there must be something in the stack with the problem that is preventing the behavior from being resolved. Well, it *should* work. In most cases anyway. The only thing I can think of that would mess it up is if you have a loadData handler somewhere in a frontscript and it isn't passing the message on when it's done. I think of behavior scripts as private backscripts of the parent object. So it should be the next thing in the message path unless a frontscript grabs the message first and never lets go. I don't think that explains the unhandled status though, so there may be something else going on. -- Mark Wieder ahsoftw...@gmail.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 -- 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: Behavior question
Peter Haworth wrote: I do recall someone (Richard Gaskin) entering an enhancement request for a command to reestablish behaviors. My handler is very fast, not even noticeable at startup but it would be nice to have an official way to do it. Mark Waddingham's comment #8 here suggests a good path forward, in which the engine takes care of this for us: http://quality.runrev.com/show_bug.cgi?id=8993 That was more than a year ago. I know they've had a lot on their plates, but it would be nice to have this one behind us. Behaviors are very useful, but only when they're not confusing. :) -- 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
Re: Behavior question
Thanks Richard. Read Mark's comment and I agree his solution sounds like the best way forward. On Wed, Jul 22, 2015 at 12:05 PM Richard Gaskin ambassa...@fourthworld.com wrote: Peter Haworth wrote: I do recall someone (Richard Gaskin) entering an enhancement request for a command to reestablish behaviors. My handler is very fast, not even noticeable at startup but it would be nice to have an official way to do it. Mark Waddingham's comment #8 here suggests a good path forward, in which the engine takes care of this for us: http://quality.runrev.com/show_bug.cgi?id=8993 That was more than a year ago. I know they've had a lot on their plates, but it would be nice to have this one behind us. Behaviors are very useful, but only when they're not confusing. :) -- 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 ___ 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
revZip and 64-bit iOS
I’m running into a problem, and wondering if others are/have as well. I have an iPad app that extracts some media files from a zip archive upon first launching. This works great on an iPad Mini 1, but fails with the error “not a zip archive” on an iPad Air 1. I’m running the same exact build with the same exact zip file on both machines. So it’s either a retina device only problem, or it’s a 64-bit problem. Not sure which, but I’m guessing the latter. I created the latest build of the app with LC 6.7.7 rc-1, but the same issue has occurred since LC 6.7.5. Anyone else using revZip at all? Does it work for you with these versions of LC when running an app on a 64-bit compatible device? Thanks, Chris -- Chris Sheffield Read Naturally, Inc. www.readnaturally.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
Re: New Indy License Correction
It should have gone to Helen of course but I'm glad I saw it otherwise I might not have checked the new expiration date when I renew. On Wed, Jul 22, 2015 at 11:42 AM Rick Harrison harri...@all-auctions.com wrote: Hi Matthias, I made the mistake of using “Reply” to an old message which she apparently had sent out to everyone instead of putting her email into the message directly. Sorry about that. My mistake, please ignore my message list members. Thanks Matthias, I just don’t get enough sleep these days. Rick On Jul 22, 2015, at 1:56 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: such requests should be sent to supp...@runrev.com instead of posting here. Regards Matthias ___ 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: Behavior question
Well now it's one of the ones that is assigned at startup - it wasn't when I started this thread. I'm pretty sure this all has to do with the engine's resolution of behavior references happening before all stacks are loaded. I have all my behaviors in a separate mainstack which is opened in a preOpenCard handler of the stack whose controls reference the behaviors. It appears even preOpenCard doesn't happen soon enough to allow the engine to resolve the behavior references. I wonder if putting a reference to the behaviors stack in the application stack's stackFiles property would fix this. I will try and post the result. On Wed, Jul 22, 2015 at 11:22 AM J. Landman Gay jac...@hyperactivesw.com wrote: Is this one of the behaviors that's dynamically assigned at startup or when a stack opens? I wonder if it's assigned too soon, before everything has finished loading. On 7/22/2015 1:03 PM, Peter Haworth wrote: Yep, checked it over and over, plus the spelling of the command. My lcStackbrowser plugin has a feature where you click on an icon for an object's behavior and it automatically opens its script - that opens the correct script so pretty sure all is OK. I tried dispatching to a different handler - same result. I have got this to work however. I deleted the behavior reference and reset it. After that, all works well again. But after quitting LC and starting it again, the behavior is no longer resolved. For some reason, the behavior is not being resolved at runtime by LC and deleting and resetting it forces it to be resolved. On Wed, Jul 22, 2015 at 9:57 AM J. Landman Gay jac...@hyperactivesw.com wrote: You double-checked the path to the behavior, right? If there are any other handlers in the behavior, do those work? On 7/22/2015 12:48 AM, Peter Haworth wrote: Right, the unhandled is what is throwing me, plus the fact that using send results in a runtime error. As I've found, what I'm doing works in a simplified environment so for some reason, this particular behavior isn't being resolved, just can't figure out why. On Tue, Jul 21, 2015 at 8:44 PM Mark Wieder mwie...@ahsoftware.net wrote: On 07/21/2015 04:55 PM, Peter Haworth wrote: I just tried a very simple test in another stack and it worked so there must be something in the stack with the problem that is preventing the behavior from being resolved. Well, it *should* work. In most cases anyway. The only thing I can think of that would mess it up is if you have a loadData handler somewhere in a frontscript and it isn't passing the message on when it's done. I think of behavior scripts as private backscripts of the parent object. So it should be the next thing in the message path unless a frontscript grabs the message first and never lets go. I don't think that explains the unhandled status though, so there may be something else going on. -- Mark Wieder ahsoftw...@gmail.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 -- 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 -- 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: Underscore uncomment bug in OSX
Hi Jerry, The keyboard shortcut to uncomment works for me. This is on OSX 10.10.4 and LC 6.6.5 On Wed, Jul 22, 2015 at 1:20 PM Jerry Jensen j...@jhj.com wrote: Hello bug chasers, This is regarding bug report 11142: http://quality.runrev.com/show_bug.cgi?id=11142list_id=33024 I first reported this almost 2 years ago, and it had been happening for a while before that. I just received a note from Panos that it is fixed in 6.7.6 and probably before. It is still broken for me so I reopened the bug report. I just tested it in LC 5.5.4 and 6.7.6 with no externals or plugins and it still fails. It has never been observed to fail at RR HQ. I’m running OSX 10.10.4 with a stock Apple wired keyboard. Anybody else? Its quick to check with the recipe there. Thanks, Jerry ___ 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: New Indy License Correction
such requests should be sent to supp...@runrev.com instead of posting here. Regards Matthias Am 22.07.2015 um 19:43 schrieb Rick Harrison harri...@all-auctions.com: Hi Heather, I just took advantage of the 2 years of Indy for $499. My old license wasn’t supposed to expire until March of 2016 according to my account when I logged into it. This new license told me it would expire two years from now July of 2017. I believe according to Kevin’s email to me that these 2 years should be tacked onto the end of my other license. Could you please update my account accordingly, and send me a confirmation of what my new expiration date will be? Thanks, Rick On Jul 14, 2015, at 4:12 AM, Heather Laine heat...@livecode.com wrote: Dear list folks, Just to put this one to bed - the Founders package always was and will remain, 100GB storage. If you do not see that in your Founders account then there is either a reporting error or a setup error, both of which we will be happy to correct for you if you email us at the support address for on-rev: supp...@on-rev.com mailto:supp...@on-rev.com (or on-...@runrev.com mailto:on-...@runrev.com will also work). I do not think cPanel is reporting space usage correctly by the sound of it. Regards, Heather Heather Laine Customer Services Manager LiveCode Ltd www.livecode.com On 12 Jul 2015, at 05:29, Simon si...@asato-media.com wrote: Ok I do have to admit that during the HTML5 crowdfunding I went with the Lifetime Pro and there was in the fine print that it meant 10 years. Now for me that indicated some sort of legal speak and that there was probably some enforceable case that 10 years could be deemed a lifetime. But then there is also the case of when I found the Enterprise edition was for $500K (or 50K? some revenue cap) or less on the website. Heather quickly had that fixed. So that fine print may have been wrong. Anyways, I like LiveCode Ltd. so not a big problem. I wonder about the people who have 100 GB storage because though I can't find it, there was a post by Kevin when this came up before (during the move to France) that said we would retain our 50 GB and he'd get right on it. Simon -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Has-the-founders-on-rev-package-been-reduced-to-25-GB-tp4693856p4693902.html Sent from the Revolution - User mailing list archive at Nabble.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 ___ 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: Behavior question
This now ringing a bell with a problem I had a few months ago where many behaviors were not being resolved. In that thread, somebody recommended a repeat loop at startup to go through all objects in the stack, find the ones with behaviors and set the behavior to its existing property. That fixed the problem. But the current problem is happening in a stack which was excluded from the behavior reset. I just changed the reset behavior handler to include it and now all works fine. Still don;t know why all that should be necessary, maybe it's because the behavior objects are in a different stack than the objects that reference them (the stack is referenced in a start using command at startup) but it works so moving on. I do recall someone (Richard Gaskin) entering an enhancement request for a command to reestablish behaviors. My handler is very fast, not even noticeable at startup but it would be nice to have an official way to do it. On Wed, Jul 22, 2015 at 11:03 AM Peter Haworth p...@lcsql.com wrote: Yep, checked it over and over, plus the spelling of the command. My lcStackbrowser plugin has a feature where you click on an icon for an object's behavior and it automatically opens its script - that opens the correct script so pretty sure all is OK. I tried dispatching to a different handler - same result. I have got this to work however. I deleted the behavior reference and reset it. After that, all works well again. But after quitting LC and starting it again, the behavior is no longer resolved. For some reason, the behavior is not being resolved at runtime by LC and deleting and resetting it forces it to be resolved. On Wed, Jul 22, 2015 at 9:57 AM J. Landman Gay jac...@hyperactivesw.com wrote: You double-checked the path to the behavior, right? If there are any other handlers in the behavior, do those work? On 7/22/2015 12:48 AM, Peter Haworth wrote: Right, the unhandled is what is throwing me, plus the fact that using send results in a runtime error. As I've found, what I'm doing works in a simplified environment so for some reason, this particular behavior isn't being resolved, just can't figure out why. On Tue, Jul 21, 2015 at 8:44 PM Mark Wieder mwie...@ahsoftware.net wrote: On 07/21/2015 04:55 PM, Peter Haworth wrote: I just tried a very simple test in another stack and it worked so there must be something in the stack with the problem that is preventing the behavior from being resolved. Well, it *should* work. In most cases anyway. The only thing I can think of that would mess it up is if you have a loadData handler somewhere in a frontscript and it isn't passing the message on when it's done. I think of behavior scripts as private backscripts of the parent object. So it should be the next thing in the message path unless a frontscript grabs the message first and never lets go. I don't think that explains the unhandled status though, so there may be something else going on. -- Mark Wieder ahsoftw...@gmail.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 -- 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: New Indy License Correction
Rick, there´s no reason to apologize. Just wanted to make sure that your request is sent to the right address to get the attention it needs. ;) Matthias Am 22.07.2015 um 20:41 schrieb Rick Harrison harri...@all-auctions.com: Hi Matthias, I made the mistake of using “Reply” to an old message which she apparently had sent out to everyone instead of putting her email into the message directly. Sorry about that. My mistake, please ignore my message list members. Thanks Matthias, I just don’t get enough sleep these days. Rick On Jul 22, 2015, at 1:56 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: such requests should be sent to supp...@runrev.com instead of posting here. Regards Matthias ___ 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
Underscore uncomment bug in OSX
Hello bug chasers, This is regarding bug report 11142: http://quality.runrev.com/show_bug.cgi?id=11142list_id=33024 I first reported this almost 2 years ago, and it had been happening for a while before that. I just received a note from Panos that it is fixed in 6.7.6 and probably before. It is still broken for me so I reopened the bug report. I just tested it in LC 5.5.4 and 6.7.6 with no externals or plugins and it still fails. It has never been observed to fail at RR HQ. I’m running OSX 10.10.4 with a stock Apple wired keyboard. Anybody else? Its quick to check with the recipe there. Thanks, Jerry ___ 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: list field not getting arrowkey msg
Mike Bonner wrote Very weird. I can't get arrow keys to work with any list field if the selection is empty. But hey, all that matters is that it works. Hi Mike, could you try this on a list field with a hilited line and either a second field that can get focus or no other field/control that can get focus and test if the arrowkeys work? put this code into the script of the list field -- on focusIn -- when tabbing into field activateLine end focusIn -- in case of tab but no other field/control gets focus, i.e. field is only focusable object beside card on focusOut send checkWhoIsFocused to me in 10 milliseconds end focusOut on checkWhoIsFocused -- restore selection after tabbing while in only focusable object if the focusedObject = the long id of me then activateLine end if end checkWhoIsFocused on activateLine put the hilitedLine of me into tHilitedLine if tHilitedLine then select line tHIlitedLine of me end activateLine -- Kind regards Bernd -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/list-field-not-getting-arrowkey-msg-tp4694070p4694196.html Sent from the Revolution - User mailing list archive at Nabble.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
What would you like to read about on the blog?
Hi LiveCode Community, Just wanted to say how much I appreciate your feedback on the blog (Thanks, Bill Prothero!). I really want to make this the LiveCode community blog by exploring the ideas and questions you might have. If you have a particular topic you'd like to see covered on the blog, please let me know! You can email me directly at jana.doug...@livecode.com. If you missed yesterday's blog or you want to explore more of the blog, you can do that here: http://livecode.com/how-to-deploy-apps-to-android-devices/ Hope to hear from you soon! Thanks! Jana ___ 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
[OT] FlipPDF for 19$ instead of 99$
Hi, maybe this is of interest for you. FlipPDF (Win or Mac) from flipbuilder.com is for sale for 19$ at https://dealfuel.com/seller/flip-pdf-page-flip-software/ With this tool you can convert PDFs to Win Exe, Mac OS X App or to Flash and/or HTML5. You can even export the flipbooks as a plugin for Wordpress, Drupal or Joomla. I´ve just got a confirmation email from Flipbuilder.com that this offer is legal. And no, i do not earn anything for recommending this offer here. ;) I am using the Mac version for over a year now and i am really satisfied with it. I created e.g. restaurant menu cards which are installed on tablet computers. Regards, Matthias ___ 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: list field not getting arrowkey msg
Yep, it works well, whether its a single field or not. The only instance where it doesn't work correctly is if click to toggle is on (so that there are no hilitedlines) Focus is accepted, but no selection is made. Of course with click to toggle on, using arrow keys to select multiple lines would take custom coding anyway. Your code is similar to mine, the only addition I made was to select char 1 to 0 when no hilitedline is available. On Wed, Jul 22, 2015 at 4:10 AM, BNig bernd.niggem...@uni-wh.de wrote: Mike Bonner wrote Very weird. I can't get arrow keys to work with any list field if the selection is empty. But hey, all that matters is that it works. Hi Mike, could you try this on a list field with a hilited line and either a second field that can get focus or no other field/control that can get focus and test if the arrowkeys work? put this code into the script of the list field -- on focusIn -- when tabbing into field activateLine end focusIn -- in case of tab but no other field/control gets focus, i.e. field is only focusable object beside card on focusOut send checkWhoIsFocused to me in 10 milliseconds end focusOut on checkWhoIsFocused -- restore selection after tabbing while in only focusable object if the focusedObject = the long id of me then activateLine end if end checkWhoIsFocused on activateLine put the hilitedLine of me into tHilitedLine if tHilitedLine then select line tHIlitedLine of me end activateLine -- Kind regards Bernd -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/list-field-not-getting-arrowkey-msg-tp4694070p4694196.html Sent from the Revolution - User mailing list archive at Nabble.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: New Indy License Pricing
Richard, It's not an issue of earnestness or integrity but of what has been delivered vs what we were told was going to be delivered. There is a huge gap between the way things looked when they were presented to us in April 2013 and the way they look today. This has been the point of conversation on this list several times. It isn't a result of being dishonest or the other amusing caricatures you painted to make a point. It is the result of lets pile more things we might be able deliver on so that we can get more funding from excited people. Had the best of intentions, just didn't pan out like they planned. Will things all be delivered? Yeah, probably. But how many more major version numbers will it take? How many of them will turn into additional kickstarters when their revenue stream dries up? Are many of these features going to end up being mac specific when it gets down to finding out how hard they are to make cross platform? That's what I mean when I say trust. Brand fetishism just isn't enough to live on anymore. The actual performance as a company lately, frankly, sucks. Since, I know you are going to want examples of why someone might feel this way: - On-rev (do I really need to say more? Search the list for on-rev) -The documentation is scattered, sparse, and most of the code samples are images. Fun. -The website is going down an awful lot rendering the point above moot as it's not available. -Everything i mentioned above about the disappointments that followed the delivery of the kickstarter campaign. Runrev's track record isn't dishonesty, it's being confident that they can follow through on the things they set out to do and do them well. So this admittance from Kevin that they spent 2x what they raised on the kickstarter to build Livecode 7 continues to point to that. On Tue, Jul 21, 2015 at 4:35 PM Richard Gaskin ambassa...@fourthworld.com wrote: Andrew Kluthe wrote: Price Increase? No big deal. Even less so when we consider that the new price was the price before last year's experiment with lower prices. In fact, it's only $4 more than I used to pay for annual renewals with MetaCard back in '98, after paying an initial licensing fee of $995. Some talk about this like it's tennis shoes or other commodities, Just lower the price to sell more! The total addressable market for software developer tools is a slender fraction of what most consumer apps can aim for. Look at the bell curve and remember that a person needs an IQ of at least 115 just to begin to find programming at all interesting. Race-to-the-bottom pricing just doesn't work for such a highly specialized product that can only appeal to a relatively slender slice of the gene pool. Everyone needs shoes, but few have any interest at all in programming. Commercial vs Open Source Feature Parity? Could also be no big deal if done with some good intentions. So far there's been only feature parity, and the only thing Kevin discussed in his email is a single Widget add-on for exotic camera features, which takes nothing away from any of the other front- or back-facing camera commands we have on mobile now, or any of the webcam and other image input support on the desktop. And while I can appreciate Kevin's desire to come up with supplemental revenue streams, I suspect he'll find that add-on components for a developer tool isn't exactly easy money, so I don't expect this to be a major trend. Only Subscription licensing? No big deal, helps keep costs down for us to stay bleeding edge and helps stabilize the income runrev can count on. And not at all new. The switch to subscriptions went into effect more than two years ago when the Community Edition premiered. But all three of these together? It's kind of obvious why people are complaining/suspicious of the long term intentions here. Given that two of those three aren't new and the third (a proprietary add-on) doesn't even exist yet, it's less clear to me. Or maybe it's no more mystifying than anything else we see in any reasonably sizable Internet community. As a population grows to reflect larger demographics, we can expect a portion of any group to disagree with changes within that group. And given human nature, those who are satisfied with the change will be happily enjoying it rather than writing about it, giving disproportionate voice to a relatively small subset of the group. We see this with nearly every aspect of collective human activity, from politics to products. A casual observer might count dissenting posts, but if we look at dissenting people the number is much smaller. And if we look at the audience size as a whole and compare the number of dissenting people to that, the proportionality becomes even clearer. This isn't to suggest that contrary views shouldn't be discussed. Sometimes great ideas come from vigorous debate. But the repetition is sometimes a bit much, and in any
Re: list field not getting arrowkey msg
Mike, thanks for testing. this thread made me aware of the problem and I think I will incorporate the code into my list field. Kind regards Bernd Mike Bonner wrote Yep, it works well, whether its a single field or not. The only instance where it doesn't work correctly is if click to toggle is on (so that there are no hilitedlines) Focus is accepted, but no selection is made. Of course with click to toggle on, using arrow keys to select multiple lines would take custom coding anyway. Your code is similar to mine, the only addition I made was to select char 1 to 0 when no hilitedline is available. On Wed, Jul 22, 2015 at 4:10 AM, BNig lt; bernd.niggemann@ gt; wrote: Mike Bonner wrote Very weird. I can't get arrow keys to work with any list field if the selection is empty. But hey, all that matters is that it works. Hi Mike, could you try this on a list field with a hilited line and either a second field that can get focus or no other field/control that can get focus and test if the arrowkeys work? put this code into the script of the list field -- on focusIn -- when tabbing into field activateLine end focusIn -- in case of tab but no other field/control gets focus, i.e. field is only focusable object beside card on focusOut send checkWhoIsFocused to me in 10 milliseconds end focusOut on checkWhoIsFocused -- restore selection after tabbing while in only focusable object if the focusedObject = the long id of me then activateLine end if end checkWhoIsFocused on activateLine put the hilitedLine of me into tHilitedLine if tHilitedLine then select line tHIlitedLine of me end activateLine -- Kind regards Bernd -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/list-field-not-getting-arrowkey-msg-tp4694070p4694201.html Sent from the Revolution - User mailing list archive at Nabble.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
Re: Char Set on Custom Properties
Hi Dan, Not exactly. All text is now unicode. If you set a custom property to the text of a field, it is unicode already. When you set the text of a field to a property, it is again unicode. This avoids the need for mapping and other hacks. I haven't tested this much. I can imagine that this is confusing, particularly if you work with stacks on both old and new formats. If you only use the new format, however, it is very convenient and you will quickly get used to it. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Installer Maker for LiveCode: http://qery.us/468 Buy my new book Programming LiveCode for the Real Beginner http://qery.us/3fi LiveCode on Facebook: https://www.facebook.com/groups/runrev/ On 7/22/2015 23:06, Dan Friedman wrote: Hello! Way back in LiveCode 5 and 6, custom properties were not ported to the proper character set when you opened the stack on a different platform (Mac -- Win or Win -- Mac). This was easily solved by a simple macToISO() or ISOtoMac(). However, it appears that LC 7.x is now doing this char mapping for custom properties on it's own. Before I modify a mountain of code, can anyone confirm that LC 7+ automatically maps custom properties to the proper char set for the host platform? Thanks! Dan ___ 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: New Indy License Correction
Rick, It might be better if you just sent an email to Heather directly at supp...@runrev.com (if my memory is correct). There's no guarantee that she'll see a post here, but she's really good about replying to emails and resolving problems like these. Marian Sent from my iPhone On Jul 22, 2015, at 1:43 PM, Rick Harrison harri...@all-auctions.com wrote: Hi Heather, I just took advantage of the 2 years of Indy for $499. My old license wasn’t supposed to expire until March of 2016 according to my account when I logged into it. This new license told me it would expire two years from now July of 2017. I believe according to Kevin’s email to me that these 2 years should be tacked onto the end of my other license. Could you please update my account accordingly, and send me a confirmation of what my new expiration date will be? Thanks, Rick ___ 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: New Indy License Correction
Can confirm Heather's great and is the go to person for anything license related. She resolved exactly the same situation for me. Jim -Original Message- From: Marian Petrides, MD [mailto:mpetri...@earthlink.net] Sent: Wednesday, July 22, 2015 3:23 PM To: How to use LiveCode Subject: Re: New Indy License Correction Rick, It might be better if you just sent an email to Heather directly at supp...@runrev.com (if my memory is correct). There's no guarantee that she'll see a post here, but she's really good about replying to emails and resolving problems like these. Marian Sent from my iPhone On Jul 22, 2015, at 1:43 PM, Rick Harrison harri...@all-auctions.com wrote: Hi Heather, I just took advantage of the 2 years of Indy for $499. My old license wasn’t supposed to expire until March of 2016 according to my account when I logged into it. This new license told me it would expire two years from now July of 2017. I believe according to Kevin’s email to me that these 2 years should be tacked onto the end of my other license. Could you please update my account accordingly, and send me a confirmation of what my new expiration date will be? Thanks, Rick ___ 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: New Indy License Correction
Hi Matthias, I made the mistake of using “Reply” to an old message which she apparently had sent out to everyone instead of putting her email into the message directly. Sorry about that. My mistake, please ignore my message list members. Thanks Matthias, I just don’t get enough sleep these days. Rick On Jul 22, 2015, at 1:56 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: such requests should be sent to supp...@runrev.com instead of posting here. Regards Matthias ___ 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: Underscore uncomment bug in OSX
On 07/22/2015 05:59 PM, Jerry Jensen wrote: Oh thank you Paul! I am not crazy I don't think that's a logical conclusion... it just means that now there are two of you. g -- Mark Wieder ahsoftw...@gmail.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
Re: Behavior question
On 07/22/2015 12:39 PM, Peter Haworth wrote: Well now it's one of the ones that is assigned at startup - it wasn't when I started this thread. I'm pretty sure this all has to do with the engine's resolution of behavior references happening before all stacks are loaded. I have all my behaviors in a separate mainstack which is opened in a preOpenCard handler of the stack whose controls reference the behaviors. It appears even preOpenCard doesn't happen soon enough to allow the engine to resolve the behavior references. Yeah, I'd bet money that's exactly what's happening. Since the behaviors are in a stack that hasn't been loaded yet, the engine is *helpfully* nulling those out to keep you out of trouble. And all that happens before preOpenCard (and possibly preOpenStack) has a chance to come into play. -- Mark Wieder ahsoftw...@gmail.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
Re: Underscore uncomment bug in OSX
I normally work on a 2009 iMac, but I’ve just installed LC 7.1.0(dp1) on my 2015 MacBook Pro and it’s doing exactly the same as the iMac, i.e. it doesn’t work correctly and adding the system shortcut is only a partial workaround. The MBP is also on OS X 10.10.4. I’ll head over to the bug report now. Paul On Jul 22, 2015, at 17:59, Jerry Jensen j...@jhj.com wrote: Oh thank you Paul! I am not crazy (well, not about that anyway!). What model computer are you using? Yes, please add this to the comments in the bug report. I do think it will help. .Jerry ___ 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: Underscore uncomment bug in OSX
Probably more, but at least we’re in good company!!! :) Paul On Jul 22, 2015, at 18:24, Mark Wieder mwie...@ahsoftware.net wrote: On 07/22/2015 05:59 PM, Jerry Jensen wrote: Oh thank you Paul! I am not crazy I don't think that's a logical conclusion... it just means that now there are two of you. g -- Mark Wieder ahsoftw...@gmail.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
Split by null
A heads up: split tText by cr and null works differently in LiveCode 7 than it did in LC 6. The cr parameter is OK, but the null adds another cr when this expression is used in LC 7. You use the split command to build an array from a list in a field. I was befuddled when I got bad results when sorting an array in LC 7 while using the same script that worked well in LC 6. I eliminated the “and null” and all was well. Peter Bogdanoff UCLA ___ 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: LiveCode and SQLite performace
Kay and Mark, the database file size is 250Mb. The performance issue that surprised me was the open time. Adds and Queries are as expected. ID's currently range from 1 to 60400 URL is a typical URL that ranges from 50 to 130 characters, average is 80 char. tag is currently not being used so empty local is a mac file path: of the form /Volumes/EXTERNAL/XXX/x.xxx How would I create and index? When I look at the database with sqlitebrowser, it looks like an auto index was created. Can you give me instructions as to how I should have created the database with an index? Peter, This is using livecode 7.0.6 on a Mac OSX 10.10.4. My DataBase expertise is very limited. I created the database with sqlitebrowser, then added the data with livecode. I don't know anything about PRAMAs or even how to execute them. If you can provide instructions I will give it a try. -= Mike On 7/21/15 11:48 PM, Kay C Lan wrote: An example of half a dozen records please. Maybe a couple of very short, a couple of the longest and a couple of average. How big is the db file size - MB not record count? On Wed, Jul 22, 2015 at 7:55 AM, Michael Doub miked...@gmail.com wrote: I need some database consulting help. I have created an SQLite database that has 4 fields: ID, URL, tag, local. IS is integer, unique, URL is text not null unique and tag and local are just text. I have 600,000+ records. I use the ID to access each record in most cases or I am filtering trying to find records based on the contents of the tag, URL or local fields. It seems to take forever to open the database. This is normal? I am primarily using the database to make sure that I do not have non-unique URLs, adding performance and selects seem reasonable. I am just surprised about the open performance Does opening the database load a lot of information into memory thus the long delay? Could I have created the database in someway that is not optimal, thus causing the delay? This is not a livecode issue as I am seeing the same delay when I open the database with sqlitebrowser. Any advise or incites in how sqlite actually works would be appreciated. Regards, Mike ___ 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: New Indy License Pricing
Wrong thread. Bob S On Jul 21, 2015, at 13:17 , David Bovill david@viral.academy wrote: I want to send gzip encoded data back from the LiveCode server I'm working on. According to the docs: compress function uses the slob compression library. And according to Wikipedia The Content-Encoding/Accept-Encoding and Transfer-Encoding/TE headers in HTTP https://en.m.wikipedia.org/wiki/HTTP/1.1 allow clients to optionally receive compressed HTTP https://en.m.wikipedia.org/wiki/HTTP_compression responses and (less commonly) to send compressed requests. The specification for HTTP/1.1 (RFC 2616 https://tools.ietf.org/html/rfc2616) specifies three compression methods: gzip (RFC 1952 https://tools.ietf.org/html/rfc1952; the content wrapped in a gzip stream), deflate (RFC 1950 https://tools.ietf.org/html/rfc1950; the content wrapped in a zlib-formatted stream), and compress (explained in RFC 2616 https://tools.ietf.org/html/rfc2616 section 3.5 as *The encoding format produced by the common UNIX file compression program compress. This format is an adaptive Lempel-Ziv-Welch coding (LZW).*). Many client libraries, browsers, and server platforms (including Apache https://en.m.wikipedia.org/wiki/Apache_HTTP_Server and Microsoft IIS https://en.m.wikipedia.org/wiki/Microsoft_IIS) support gzip. Many agents also support deflate, although several important players incorrectly implement deflate support using the format specified by RFC 1951 https://tools.ietf.org/html/rfc1951 instead of the correct format specified by RFC 1950 https://tools.ietf.org/html/rfc1950 (which encapsulates RFC 1951 https://tools.ietf.org/html/rfc1951). Notably, Internet Explorer versions 6, 7, and 8 report deflate support but do not actually accept RFC 1950 https://tools.ietf.org/html/rfc1950 format, making actual use of deflate highly unusual. Many clients accept both RFC 1951 https://tools.ietf.org/html/rfc1951 and RFC 1950 https://tools.ietf.org/html/rfc1950-formatted data for the deflate compressed method, but a server has no way to detect whether a client will correctly handle RFC 1950 https://tools.ietf.org/html/rfc1950 format. That bodes well. Anyone know if this works with most browsers? ___ 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: New Indy License Pricing
Try playing a MOLRP game with infantile teenagers. Bob S On Jul 21, 2015, at 15:37 , J. Landman Gay jac...@hyperactivesw.commailto:jac...@hyperactivesw.com wrote: Ask any product manager, or restaurant owner, or retail manager, or anyone else who thoroughly reviews customer feedback. Sentiment almost always skews negative Which has spawned the sage advice regarding web sites to never read the comments. Some of the stuff people write behind their veil of annonymity is just horrible. ___ 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
Char Set on Custom Properties
Hello! Way back in LiveCode 5 and 6, custom properties were not ported to the proper character set when you opened the stack on a different platform (Mac -- Win or Win -- Mac). This was easily solved by a simple macToISO() or ISOtoMac(). However, it appears that LC 7.x is now doing this char mapping for custom properties on it's own. Before I modify a mountain of code, can anyone confirm that LC 7+ automatically maps custom properties to the proper char set for the host platform? Thanks! Dan ___ 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: Underscore uncomment bug in OSX
It works for me too. I used the bug report stack and followed the directions carefully. Command - comments, Command shift - uncomments. I tried in 7.0.5, under Mac OS 10.11. On Jul 22, 2015, at 4:40 PM, Peter Haworth p...@lcsql.com wrote: Hi Jerry, The keyboard shortcut to uncomment works for me. This is on OSX 10.10.4 and LC 6.6.5 On Wed, Jul 22, 2015 at 1:20 PM Jerry Jensen j...@jhj.com wrote: Hello bug chasers, This is regarding bug report 11142: http://quality.runrev.com/show_bug.cgi?id=11142list_id=33024 I first reported this almost 2 years ago, and it had been happening for a while before that. I just received a note from Panos that it is fixed in 6.7.6 and probably before. It is still broken for me so I reopened the bug report. I just tested it in LC 5.5.4 and 6.7.6 with no externals or plugins and it still fails. It has never been observed to fail at RR HQ. I’m running OSX 10.10.4 with a stock Apple wired keyboard. Anybody else? Its quick to check with the recipe there. Thanks, Jerry ___ 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: Underscore uncomment bug in OSX
Jerry- Sorry to report that it works for me. Command-underscore comments Command-shift-underscore removes comments OSX 10.10.4 LC 6.7.7 rc1 Mac Air no third-party components -- Mark Wieder ahsoftw...@gmail.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
Re: Behavior question
Put a reference to the behavior stack in the stackFiles property of my application stack and commented out the startup handler. It works! On Wed, Jul 22, 2015 at 12:39 PM Peter Haworth p...@lcsql.com wrote: Well now it's one of the ones that is assigned at startup - it wasn't when I started this thread. I'm pretty sure this all has to do with the engine's resolution of behavior references happening before all stacks are loaded. I have all my behaviors in a separate mainstack which is opened in a preOpenCard handler of the stack whose controls reference the behaviors. It appears even preOpenCard doesn't happen soon enough to allow the engine to resolve the behavior references. I wonder if putting a reference to the behaviors stack in the application stack's stackFiles property would fix this. I will try and post the result. On Wed, Jul 22, 2015 at 11:22 AM J. Landman Gay jac...@hyperactivesw.com wrote: Is this one of the behaviors that's dynamically assigned at startup or when a stack opens? I wonder if it's assigned too soon, before everything has finished loading. On 7/22/2015 1:03 PM, Peter Haworth wrote: Yep, checked it over and over, plus the spelling of the command. My lcStackbrowser plugin has a feature where you click on an icon for an object's behavior and it automatically opens its script - that opens the correct script so pretty sure all is OK. I tried dispatching to a different handler - same result. I have got this to work however. I deleted the behavior reference and reset it. After that, all works well again. But after quitting LC and starting it again, the behavior is no longer resolved. For some reason, the behavior is not being resolved at runtime by LC and deleting and resetting it forces it to be resolved. On Wed, Jul 22, 2015 at 9:57 AM J. Landman Gay jac...@hyperactivesw.com wrote: You double-checked the path to the behavior, right? If there are any other handlers in the behavior, do those work? On 7/22/2015 12:48 AM, Peter Haworth wrote: Right, the unhandled is what is throwing me, plus the fact that using send results in a runtime error. As I've found, what I'm doing works in a simplified environment so for some reason, this particular behavior isn't being resolved, just can't figure out why. On Tue, Jul 21, 2015 at 8:44 PM Mark Wieder mwie...@ahsoftware.net wrote: On 07/21/2015 04:55 PM, Peter Haworth wrote: I just tried a very simple test in another stack and it worked so there must be something in the stack with the problem that is preventing the behavior from being resolved. Well, it *should* work. In most cases anyway. The only thing I can think of that would mess it up is if you have a loadData handler somewhere in a frontscript and it isn't passing the message on when it's done. I think of behavior scripts as private backscripts of the parent object. So it should be the next thing in the message path unless a frontscript grabs the message first and never lets go. I don't think that explains the unhandled status though, so there may be something else going on. -- Mark Wieder ahsoftw...@gmail.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 -- 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 -- 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
Re: Underscore uncomment bug in OSX
Hi Jerry, using your stack commenting and uncommenting works from the keyboard using MacOSX 10.9.5 and LC 7.1 DP1 LC 6.6.5 have you assigned a system wide shortcut via system preferences - keyboard by any chance? Just a guess. Kind regards Bernd -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Underscore-uncomment-bug-in-OSX-tp4694218p4694222.html Sent from the Revolution - User mailing list archive at Nabble.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
Re: LiveCode and SQLite performace
If its on an external usb drive, part of the wait is most likely the drive wake up time. To test, move the file to a local drive and try it from there, OR, open the drive in finder first and poke around a little to make sure the drive is live, then try to open the database and see if it solves the issue. On Wed, Jul 22, 2015 at 2:46 PM, Michael Doub miked...@gmail.com wrote: Kay and Mark, the database file size is 250Mb. The performance issue that surprised me was the open time. Adds and Queries are as expected. ID's currently range from 1 to 60400 URL is a typical URL that ranges from 50 to 130 characters, average is 80 char. tag is currently not being used so empty local is a mac file path: of the form /Volumes/EXTERNAL/XXX/x.xxx How would I create and index? When I look at the database with sqlitebrowser, it looks like an auto index was created. Can you give me instructions as to how I should have created the database with an index? Peter, This is using livecode 7.0.6 on a Mac OSX 10.10.4. My DataBase expertise is very limited. I created the database with sqlitebrowser, then added the data with livecode. I don't know anything about PRAMAs or even how to execute them. If you can provide instructions I will give it a try. -= Mike On 7/21/15 11:48 PM, Kay C Lan wrote: An example of half a dozen records please. Maybe a couple of very short, a couple of the longest and a couple of average. How big is the db file size - MB not record count? On Wed, Jul 22, 2015 at 7:55 AM, Michael Doub miked...@gmail.com wrote: I need some database consulting help. I have created an SQLite database that has 4 fields: ID, URL, tag, local. IS is integer, unique, URL is text not null unique and tag and local are just text. I have 600,000+ records. I use the ID to access each record in most cases or I am filtering trying to find records based on the contents of the tag, URL or local fields. It seems to take forever to open the database. This is normal? I am primarily using the database to make sure that I do not have non-unique URLs, adding performance and selects seem reasonable. I am just surprised about the open performance Does opening the database load a lot of information into memory thus the long delay? Could I have created the database in someway that is not optimal, thus causing the delay? This is not a livecode issue as I am seeing the same delay when I open the database with sqlitebrowser. Any advise or incites in how sqlite actually works would be appreciated. Regards, Mike ___ 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: LiveCode and SQLite performace
Hi Michael, Out of interest, when you say it takes a long time to open the database, how long do you mean? Also, where is the database located? On your Mac's hard drive, external drive, on a network? I'm a bit confused as to the number of records. Your original email said 600,000+ records, but you mentioned that the ID field (which is defined as unique) has values from 1 to 60400. Maybe a type somewhere? You'll see auto indexes for any columns that are defined as UNIQUE, that's how sqlite enforces that constraint. Don't worry about indexes for now. They on;y help if you are having problems with how long it takes to execute your select commands and this problem is occurring long before then. PRAGMAs are just another type of sqlite statement. After opening your database, do this: put revDataFromQuery(,,gDBID,PRAGMA integrity_check)) into tResult put tResult gDBID is just the variable with your connection ID in it so replace it with your variable name. The message box will open and you'll see the output from the PRAGMA command. It it begins with revdberr,Livecode detected an error with the statement for some reason. If the PRAGMA does not find any error it returns OK. Anything else, there's corruption in your database. Let me know the result of the integrity check and we'll go from there. On Wed, Jul 22, 2015 at 1:50 PM Michael Doub miked...@gmail.com wrote: Kay and Mark, the database file size is 250Mb. The performance issue that surprised me was the open time. Adds and Queries are as expected. ID's currently range from 1 to 60400 URL is a typical URL that ranges from 50 to 130 characters, average is 80 char. tag is currently not being used so empty local is a mac file path: of the form /Volumes/EXTERNAL/XXX/x.xxx How would I create and index? When I look at the database with sqlitebrowser, it looks like an auto index was created. Can you give me instructions as to how I should have created the database with an index? Peter, This is using livecode 7.0.6 on a Mac OSX 10.10.4. My DataBase expertise is very limited. I created the database with sqlitebrowser, then added the data with livecode. I don't know anything about PRAMAs or even how to execute them. If you can provide instructions I will give it a try. -= Mike On 7/21/15 11:48 PM, Kay C Lan wrote: An example of half a dozen records please. Maybe a couple of very short, a couple of the longest and a couple of average. How big is the db file size - MB not record count? On Wed, Jul 22, 2015 at 7:55 AM, Michael Doub miked...@gmail.com wrote: I need some database consulting help. I have created an SQLite database that has 4 fields: ID, URL, tag, local. IS is integer, unique, URL is text not null unique and tag and local are just text. I have 600,000+ records. I use the ID to access each record in most cases or I am filtering trying to find records based on the contents of the tag, URL or local fields. It seems to take forever to open the database. This is normal? I am primarily using the database to make sure that I do not have non-unique URLs, adding performance and selects seem reasonable. I am just surprised about the open performance Does opening the database load a lot of information into memory thus the long delay? Could I have created the database in someway that is not optimal, thus causing the delay? This is not a livecode issue as I am seeing the same delay when I open the database with sqlitebrowser. Any advise or incites in how sqlite actually works would be appreciated. Regards, Mike ___ 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: New Indy License Pricing
Oh, that’s easy! I am the only employee of my company, which is by the by a ficticious one, and I pay myself so little, nothing in fact, that I am pondering having to leave myself. Bob S On Jul 21, 2015, at 09:16 , Chris Sheffield cs_livec...@icloud.com wrote: There are two other limitations to be aware of, if I understand the terms correctly: 1) Your company/organization cannot have more than 5 employees total, and 2) cannot make more than $500,000 per year. On Jul 21, 2015, at 10:06 AM, Earthednet-wp proth...@earthednet.org wrote: Bob, I subscribed to the Indy license with the understanding that it is the same as a commercial license, but for only a single developer. Hope I'm right. Bill William Prothero http://es.earthednet.org On Jul 21, 2015, at 7:29 AM, Bob Sneidar bobsnei...@iotecdigital.com wrote: Pardon my being late to the party, but I went to the web page and read up, but I still do not know what the “Indy” version is. I don’t want to miss the pricing deadline, but I also don’t want to subscribe to something then find out it is less than I wanted. Bob S On Jul 1, 2015, at 15:50 , Mark Wieder mwie...@ahsoftware.net wrote: Peter Haworth pete@... writes: I'm assuming some folks out there got the same email as me regarding the increase in Indy license pricing. From that email, it seems that the Community Edition will no longer have all the same features as the fee-based versions of Livecode. Comments? Been dealt with very nicely by Kevin: http://forums.livecode.com/viewtopic.php?f=5t=24729start=15 -- Mark Wieder ahsoftw...@gmail.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 ___ 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: LiveCode and SQLite performace
I just updated the database and it now has 608436 records. Sorry for the typo. it was 604000. How long to open - 216 seconds. I timed put revDataFromQuery(,,db_id,select * from mydatabase) into tResult it was 26 seconds. 216 to open and 26 to copy all of the data into a variable. This seems odd to me. The database is on the main internal drive (same as OS) in folder with the stack that is accessing the database. The result of the integrity check is ok On 7/22/15 5:11 PM, Peter Haworth wrote: Hi Michael, Out of interest, when you say it takes a long time to open the database, how long do you mean? Also, where is the database located? On your Mac's hard drive, external drive, on a network? I'm a bit confused as to the number of records. Your original email said 600,000+ records, but you mentioned that the ID field (which is defined as unique) has values from 1 to 60400. Maybe a type somewhere? You'll see auto indexes for any columns that are defined as UNIQUE, that's how sqlite enforces that constraint. Don't worry about indexes for now. They on;y help if you are having problems with how long it takes to execute your select commands and this problem is occurring long before then. PRAGMAs are just another type of sqlite statement. After opening your database, do this: put revDataFromQuery(,,gDBID,PRAGMA integrity_check)) into tResult put tResult gDBID is just the variable with your connection ID in it so replace it with your variable name. The message box will open and you'll see the output from the PRAGMA command. It it begins with revdberr,Livecode detected an error with the statement for some reason. If the PRAGMA does not find any error it returns OK. Anything else, there's corruption in your database. Let me know the result of the integrity check and we'll go from there. On Wed, Jul 22, 2015 at 1:50 PM Michael Doub miked...@gmail.com wrote: Kay and Mark, the database file size is 250Mb. The performance issue that surprised me was the open time. Adds and Queries are as expected. ID's currently range from 1 to 60400 URL is a typical URL that ranges from 50 to 130 characters, average is 80 char. tag is currently not being used so empty local is a mac file path: of the form /Volumes/EXTERNAL/XXX/x.xxx How would I create and index? When I look at the database with sqlitebrowser, it looks like an auto index was created. Can you give me instructions as to how I should have created the database with an index? Peter, This is using livecode 7.0.6 on a Mac OSX 10.10.4. My DataBase expertise is very limited. I created the database with sqlitebrowser, then added the data with livecode. I don't know anything about PRAMAs or even how to execute them. If you can provide instructions I will give it a try. -= Mike On 7/21/15 11:48 PM, Kay C Lan wrote: An example of half a dozen records please. Maybe a couple of very short, a couple of the longest and a couple of average. How big is the db file size - MB not record count? On Wed, Jul 22, 2015 at 7:55 AM, Michael Doub miked...@gmail.com wrote: I need some database consulting help. I have created an SQLite database that has 4 fields: ID, URL, tag, local. IS is integer, unique, URL is text not null unique and tag and local are just text. I have 600,000+ records. I use the ID to access each record in most cases or I am filtering trying to find records based on the contents of the tag, URL or local fields. It seems to take forever to open the database. This is normal? I am primarily using the database to make sure that I do not have non-unique URLs, adding performance and selects seem reasonable. I am just surprised about the open performance Does opening the database load a lot of information into memory thus the long delay? Could I have created the database in someway that is not optimal, thus causing the delay? This is not a livecode issue as I am seeing the same delay when I open the database with sqlitebrowser. Any advise or incites in how sqlite actually works would be appreciated. Regards, Mike ___ 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
Re: Underscore uncomment bug in OSX
On 22.07.2015 at 16:56 Uhr -0700 Jerry Jensen apparently wrote: Thanks Mark, Peter, Colin and Bernd. Very mysterious! I'll try it on a few other computers at work when I get back there tomorrow. .Jerry Have you checked whether the behavior is keyboard related by chance? RObert ___ 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: Underscore uncomment bug in OSX
Oh thank you Paul! I am not crazy (well, not about that anyway!). What model computer are you using? Yes, please add this to the comments in the bug report. I do think it will help. .Jerry On Jul 22, 2015, at 5:50 PM, Paul Hibbert p...@livecode.org wrote: This has never worked for me on OS X with any version of LC and I had just got used to ignoring it. I have checked for conflicts and can’t find any. The strange thing is, the shortcut causes the ‘Edit’ menu to flash as though it is being chosen, then I found that if I click the ‘Edit’ menu once so it stays open and then use the shortcut it works! - Strange. But now seeing this works for other people I decided to play around with the keyboard control panel, under the ‘Shortcuts’ tab I added an App Shortcut for all applications as ‘Uncomment’ with the key combination of 'shift ctrl -‘. Well that shortcut doesn’t work, but it does show as the shortcut for ‘Uncomment’ in the ‘Edit’ menu of LC, but oddly, ‘shift cmd -‘ does sort of work with LC 6 7 (not 5). Now if the insertion cursor is on a line of commented text within a handler, using the shortcut will uncomment this line and also attempt to uncomment the line above, however, if the insertion cursor is on a line of commented text outside of a handler, using the shortcut will uncomment just the one line. I can add my comments to the bug report if you think it will help. I’m using LC7.0.6(rc3) on OS X 10.10.4 Baffled. Paul On Jul 22, 2015, at 16:56, Jerry Jensen j...@jhj.com wrote: On Jul 22, 2015, at 2:37 PM, Mark Wieder mwie...@ahsoftware.net wrote: Jerry- Sorry to report that it works for me. Command-underscore comments Command-shift-underscore removes comments OSX 10.10.4 LC 6.7.7 rc1 Mac Air no third-party components Thanks Mark, Peter, Colin and Bernd. Very mysterious! I’ll try it on a few other computers at work when I get back there tomorrow. .Jerry ___ 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 Regards, Paul Hibbert p...@livecode.org ___ 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: Underscore uncomment bug in OSX
On Jul 22, 2015, at 2:37 PM, Mark Wieder mwie...@ahsoftware.net wrote: Jerry- Sorry to report that it works for me. Command-underscore comments Command-shift-underscore removes comments OSX 10.10.4 LC 6.7.7 rc1 Mac Air no third-party components Thanks Mark, Peter, Colin and Bernd. Very mysterious! I’ll try it on a few other computers at work when I get back there tomorrow. .Jerry ___ 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: Underscore uncomment bug in OSX
On Jul 22, 2015, at 5:41 PM, Robert Brenstein r...@robelko.com wrote: On 22.07.2015 at 16:56 Uhr -0700 Jerry Jensen apparently wrote: Thanks Mark, Peter, Colin and Bernd. Very mysterious! I'll try it on a few other computers at work when I get back there tomorrow. .Jerry Have you checked whether the behavior is keyboard related by chance? Thanks for the suggestion, Robert. Yep - two different wired Apple keyboards (with and without numeric keypad) plugged directly into the MacBookPro or into a Thunderblt monitor. Also checked the System Preferences Keyboard pane - no joy. This also happened with some former MacBookPros. When I have a chance, I’ll configure a virgin minimal system to try. .Jerry ___ 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: LiveCode and SQLite performace
On 07/22/2015 02:11 PM, Peter Haworth wrote: You'll see auto indexes for any columns that are defined as UNIQUE, that's how sqlite enforces that constraint. Doh! You're right. I could swear the documentation said you had to compile sqlite with a non-default compiler option to get this to happen, but the reality is that you have to do that to *prevent* it from happening. So do you know if the indices are stored with the database or are they just recreated at each load? That might explain the long wait times on open. -- Mark Wieder ahsoftw...@gmail.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
Re: Underscore uncomment bug in OSX
This has never worked for me on OS X with any version of LC and I had just got used to ignoring it. I have checked for conflicts and can’t find any. The strange thing is, the shortcut causes the ‘Edit’ menu to flash as though it is being chosen, then I found that if I click the ‘Edit’ menu once so it stays open and then use the shortcut it works! - Strange. But now seeing this works for other people I decided to play around with the keyboard control panel, under the ‘Shortcuts’ tab I added an App Shortcut for all applications as ‘Uncomment’ with the key combination of 'shift ctrl -‘. Well that shortcut doesn’t work, but it does show as the shortcut for ‘Uncomment’ in the ‘Edit’ menu of LC, but oddly, ‘shift cmd -‘ does sort of work with LC 6 7 (not 5). Now if the insertion cursor is on a line of commented text within a handler, using the shortcut will uncomment this line and also attempt to uncomment the line above, however, if the insertion cursor is on a line of commented text outside of a handler, using the shortcut will uncomment just the one line. I can add my comments to the bug report if you think it will help. I’m using LC7.0.6(rc3) on OS X 10.10.4 Baffled. Paul On Jul 22, 2015, at 16:56, Jerry Jensen j...@jhj.com wrote: On Jul 22, 2015, at 2:37 PM, Mark Wieder mwie...@ahsoftware.net wrote: Jerry- Sorry to report that it works for me. Command-underscore comments Command-shift-underscore removes comments OSX 10.10.4 LC 6.7.7 rc1 Mac Air no third-party components Thanks Mark, Peter, Colin and Bernd. Very mysterious! I’ll try it on a few other computers at work when I get back there tomorrow. .Jerry ___ 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 Regards, Paul Hibbert p...@livecode.org ___ 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