Re: JSON Safe Text

2015-07-24 Thread David Bovill
Yes - it's taken from the wild (an HTML page on the internet). Then turned
into XML, then a table extracted etc - so looks to me like non-utf8 stuff
has go in there somewhere.

That's why I was wandering if there was a way to filter out arbitrary text
and make it utf8-safe. You know urlencode for utf8 - or plain text? I don't
want to encode all the spaces and normal / safe chars - just whatever weird
stuff got into the data?

On 24 July 2015 at 00:12, Monte Goulding mo...@sweattechnologies.com
wrote:


  On 24 Jul 2015, at 7:22 am, David Bovill david@viral.academy wrote:
 
  I'm placing the text into an array and then using Monte's mergJsonEncode
  function to decode it. Usually works fine - but in this case it looks
 like
  the content needs some tidying before I put it into the array.

 mergJSON will choke on anything that’s not utf8. Is it possible there’s
 some other encoded data there or something you are doing with the data is
 messing with the encoding?

 --
 M E R Goulding http://goulding.ws/
 Software development services
 Bespoke application development for vertical markets

 mergExt http://mergext.com/ - There's an external for that!

 ___
 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: JSON Safe Text

2015-07-24 Thread Monte Goulding
You really need to know the encoding you are working with. Check if the page 
has a charset attribute first and if it does re-encode to utf8 first. The try 
it in mergJSON. If it chokes then the best you can do is replace any char 
greater than charToNum(127) with “?”. Other than that I think there are 
encoding detectors around but it may depend on how critical the data is...

 On 24 Jul 2015, at 4:03 pm, David Bovill david@viral.academy wrote:
 
 Yes - it's taken from the wild (an HTML page on the internet). Then turned
 into XML, then a table extracted etc - so looks to me like non-utf8 stuff
 has go in there somewhere.
 
 That's why I was wandering if there was a way to filter out arbitrary text
 and make it utf8-safe. You know urlencode for utf8 - or plain text? I don't
 want to encode all the spaces and normal / safe chars - just whatever weird
 stuff got into the data?
 
 On 24 July 2015 at 00:12, Monte Goulding mo...@sweattechnologies.com
 wrote:
 
 
 On 24 Jul 2015, at 7:22 am, David Bovill david@viral.academy wrote:
 
 I'm placing the text into an array and then using Monte's mergJsonEncode
 function to decode it. Usually works fine - but in this case it looks
 like
 the content needs some tidying before I put it into the array.
 
 mergJSON will choke on anything that’s not utf8. Is it possible there’s
 some other encoded data there or something you are doing with the data is
 messing with the encoding?
 
 --
 M E R Goulding http://goulding.ws/
 Software development services
 Bespoke application development for vertical markets
 
 mergExt http://mergext.com/ - There's an external for that!
 
 ___
 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

--
M E R Goulding http://goulding.ws/ 
Software development services
Bespoke application development for vertical markets

mergExt http://mergext.com/ - There's an external for that!

___
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

revBrowserSet

2015-07-24 Thread Terence Heaford
This is my first foray into using a browser in LiveCode and I have come across 
a couple of points I was hoping someone could help me with:

I am experimenting using a browser to display charts using highcharts from 
highcharts.com and have got the example charts working in a browser.

I am working with LC 6.7.6 on iMac with Yosemite.

--

I have this script to setup the browser

global gBrowserID

on mouseUp
   lock screen
   set the visible of grc browserOutline to false
   
   --put revBrowserOpenCef(the windowId of this stack, ) into gBrowserID
   put revBrowserOpen(the windowId of this stack, ) into gBrowserID
   
   revBrowserSet gBrowserID, rect, the rect of graphic browserOutline
   revBrowserSet gBrowserID, offline, true
   revBrowserSet gBrowserID, scrollbars, false
   revBrowserSet gBrowserID, showBorder, true
   unlock screen
end mouseUp

I have noticed that with revBrowserCef I cannot disable scrollbars and show 
border does not work for me but with revBrowserOpen they both work?

Perhaps I am doing something wrong or is revBrowserCef a work in progress?

———

At the moment it appears that I will have to create my own charts in LiveCode 
export them as index.htm then reload them into the browser.

Is there a way to create the chart in LiveCode then pass it straight to the 
browser.

I tried this without success using the content of one of the example files in 
highcharts:

put the uScript of me into tScript
revBrowserSet gBrowserID, htmltext, tScript
revBrowserRefresh gBrowserID

———

Is there any better documentation on the use of the revBrowser commands or is 
it all to be trial and error?


Thanks


Terry
___
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: Best practise for a quiz control?

2015-07-24 Thread Mark Waddingham
I am not sure, what my loop will be doing, while I opened modal the 
answer
window? Will the loop wait for the user answer in the modal window in 
both
above cases, or is the modal window completely independent from the 
loop and
the loop runs on? How can I hold my loop waiting for the user action in 
the

modal window?


When you 'modal' a stack, the modal command will block the current 
script until the dialog closes. (e.g. You have an OK / Cancel button 
which do 'close this stack').


Note that messages *are* dispatched whilst this blocking occurs - 
otherwise events wouldn't get processed so you wouldn't have any user 
interaction.


--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps

___
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: revBrowserSet

2015-07-24 Thread Kay C Lan
On Fri, Jul 24, 2015 at 3:22 PM, Terence Heaford t.heaf...@icloud.com
wrote:

 Is there a way to create the chart in LiveCode then pass it straight to
 the browser.

 I tried this without success using the content of one of the example files
 in highcharts:

 put the uScript of me into tScript
 revBrowserSet gBrowserID, htmltext, tScript
 revBrowserRefresh gBrowserID

 If you were to step through your code and take the content of uScript and
paste it straight into a text editor, and then display that file in a
'real' Browser does it display correctly? I've done exactly your steps and
have had no trouble displaying LC created html in an LC Browser instance.
Actually there is one difference, I don't revBrowserRefresh, I just 'wait 1
millisec' and it displays.

As for the CEF browser I seem to remember reading something about it's the
way of the future but it is a work in progress. I may have that wrong
though.

HTH
___
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


Best practise for a quiz control?

2015-07-24 Thread Tiemo Hollmann TB
Hello,

What I want to do:

The user gets a kind of multiple choice question,  answers by clicking his
choice in a list or answering a dialog (two different cases). The answer
dialog has to be a modal window, not the standard answer dialog, because I
have to place the dialog window at a certain screen position. After
answering, the next question is being asked. This is a kind of loop with
dialogs.

My question:

Should I build this  question-answer cycle in a repeat forever loop or in
a myHandler, which has a send myHandler to me in 1 at the end. Or is
there a better design approach for this?

I am not sure, what my loop will be doing, while I opened modal the answer
window? Will the loop wait for the user answer in the modal window in both
above cases, or is the modal window completely independent from the loop and
the loop runs on? How can I hold my loop waiting for the user action in the
modal window?

Thanks for your recommendations

Tiemo

 

 

___
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: revBrowserSet

2015-07-24 Thread Terence Heaford
Yes it works correctly if I use this script from LC with the content in a file

global gBrowserID
global gFile

on mouseUp
   answer file Select a chart to load:
   if the result is not cancel then
  put it into gFile
  revBrowserNavigate gBrowserId, file://  gFile 
   end if
end mouseUp


What I really want to do is just load the content of the file gFile directly 
from LC.

I thought put revBrowserSet gBrowserID,”htmlText”,theContentsOfgFile might 
work, but it doesn’t.

Perhaps I am using this in the wrong context but there does not appear to be 
any docs for using revBrowser type commands unless I can’t find them?


All the best

Terry



 On 24 Jul 2015, at 09:51, Kay C Lan lan.kc.macm...@gmail.com wrote:
 
 paste it straight into a text editor, and then display that file in a
 'real' Browser does it display correctly? I've done exactly your steps and
 have had no trouble displaying LC created html in an LC Browser instance.
 Actually there is one difference, I don't revBrowserRefresh, I just 'wait 1
 millisec' and it displays.

___
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

AW: Best practise for a quiz control?

2015-07-24 Thread Tiemo Hollmann TB
Hi Mark,
thanks for clarifying this part of my question!
Tiemo

-Ursprüngliche Nachricht-
Von: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] Im Auftrag
von Mark Waddingham
Gesendet: Freitag, 24. Juli 2015 11:53
An: How to use LiveCode use-livecode@lists.runrev.com
Betreff: Re: Best practise for a quiz control?

 I am not sure, what my loop will be doing, while I opened modal the 
 answer window? Will the loop wait for the user answer in the modal 
 window in both above cases, or is the modal window completely 
 independent from the loop and the loop runs on? How can I hold my loop 
 waiting for the user action in the modal window?

When you 'modal' a stack, the modal command will block the current script
until the dialog closes. (e.g. You have an OK / Cancel button which do
'close this stack').

Note that messages *are* dispatched whilst this blocking occurs - otherwise
events wouldn't get processed so you wouldn't have any user interaction.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps

___
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

2015-07-24 Thread Robert Brenstein

A rule of thumb for Mac is 10% of drive being free...

I find iStat Menus a useful tool for continuous monitoring of vital 
parameters (just a happy user).


RObert


On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:

If I remember correctly Bob Sneidar said that a
you need at least 1/2 of your hard drive as free
space to run efficiently.  So if you have a drive
with 500 GB you need 250 GB or more free
space on the drive.  Anything below that and
it normal operations like opening files will be
slower.  I have used more space than 1/2 and
the more I use the slower it gets.  Sometimes
you can speed things up a little by relaunching
the Finder.  That can be done using the Force
Quit option.  If it speeds things up it will only be
a temporary fix.

John Balgenorth


___
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

2015-07-24 Thread EED-wp Email
I've found DiskWarrior to be an indispensable tool on my Mac. It fixes disc 
corruption that diskutil can't and optimizes the directory. It might be worth a 
try. 
Bill

William Prothero
http://ed.earthednet.org

 On Jul 24, 2015, at 4:50 AM, JB sund...@pacifier.com wrote:
 
 10% might work for you but it definitely does not
 work for me.  I have a 1tb drive and 348 gb free
 space.  Most operations run slower than normal.
 I deleted about 150gb of music to bring it up to
 350gb because it ran too slow to use.  Now it
 runs fast enough to use but I still have a lot of
 wasted time.  I had a 350gb drive and had the
 same problems way before 35gb free space.
 
 John Balgenorth
 
 
 On Jul 24, 2015, at 4:15 AM, Robert Brenstein r...@robelko.com wrote:
 
 A rule of thumb for Mac is 10% of drive being free...
 
 I find iStat Menus a useful tool for continuous monitoring of vital 
 parameters (just a happy user).
 
 RObert
 
 
 On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:
 If I remember correctly Bob Sneidar said that a
 you need at least 1/2 of your hard drive as free
 space to run efficiently.  So if you have a drive
 with 500 GB you need 250 GB or more free
 space on the drive.  Anything below that and
 it normal operations like opening files will be
 slower.  I have used more space than 1/2 and
 the more I use the slower it gets.  Sometimes
 you can speed things up a little by relaunching
 the Finder.  That can be done using the Force
 Quit option.  If it speeds things up it will only be
 a temporary fix.
 
 John Balgenorth
 
 ___
 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: Anomalous Script behavior

2015-07-24 Thread dunbarx
Peter.


There is no limit to the size of a script; LC is not HC.


But that was easy. To your real question, I am positive, and this does indeed 
go back to HC, that certain handlers will work one day and not the next. That 
some will work if I step through them, but not run normally.


And that this comes and goes, but generally somehow works itself out, so that 
after a bit of angst, the gremlin goes away, and rarely leaves me with the 
issue. 


Not to say that on occasion I simply rewrite a handler, if it is not too long, 
and then it works. Hidden spurious chars? Hidden spurious chars that evaporate? 
I suspect others believe the same, and similar tales will, in aggregate, be 
like one of those TV shows about haunted houses. 


There are mysteries...


Craig Newman



-Original Message-
From: Peter Bogdanoff bogdan...@me.com
To: How to use LiveCode use-livecode@lists.runrev.com
Sent: Fri, Jul 24, 2015 1:16 am
Subject: Anomalous Script behavior


Using LC 7.1 dp1

Part of a script sometimes doesn’t function—sometimes it
works just fine. Sometimes it refuses to continue to execute the rest of a
handler. This refusal will happen over and over until some point in my testing
it starts working again beautifully.

It’s a group script with 35,655
characters. Is there a limit to the number of characters?

I put in
breakpoints that are sometimes reached, sometimes not.

It’s a handler that is
being called by callbacks in a player as the media plays, so it’s difficult to
debug while the media is playing. So I put some code in to put data into a field
when those lines of the script are reached. Then I can see the progression
through the script in real time. When it’s not working properly, while the
handler IS receiving the callback calls, that field stays empty.

Any
ideas?

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

 
___
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

2015-07-24 Thread Peter M. Brigham
Here's the workaround that I have been using, in case others find it useful. I 
put it into a controlkeydown handler in my LC frontscript. All my script 
shortcuts use control-shift-key. The command doUndoSpace types a space and 
then deletes it, to make sure LC knows that editing has been done and the 
script needs re-checking. This may not be necessary in later LC versions (I 
operate still in 5.5 -- I know, I'm a dinosaur). So control-shift-underscore 
comments out a line or lines, control-shift-= uncomments a line or lines.

on controlkeydown which
   put the long name of the target into tarName
   put the shiftkey is down into shK
   switch which
  case -
  case _ -- comment out the line -- until Rev fixes the commandkey 
shortcut
 if not shK then pass controlkeydown
 if field is not in tarName then pass controlkeydown
 if revNewScriptEditor is not in tarName then pass controlkeydown
 put the selectedLine into tLineCh
 put -  - into cmntChars
 if  to  is in tLineCh then
put word 2 of tLineCh into stLineNbr
put word 4 of tLineCh into endLineNbr
repeat with n = stLineNbr to endLineNbr
   put put cmntChars  space before word 1 of line  n  of 
 tarName \
 into theDo
   do theDo
end repeat
-- put scriptLinesText into line stLineNbr to endLineNbr of the 
target
put endLineNbr into selectHere
 else
put word 2 of tLineCh into lineNbr
put the long name of the target into tLongName
put sr(line lineNbr of the target) into tLineText
do put cmntChars  space before word 1 of  tLineCh
put lineNbr into selectHere
 end if
 doUndoSpace
 send tabkey to tarname -- to fix indenting
 select after line selectHere of the target
 break
  case =
  case + -- uncomment the line -- until Rev fixes the commandkey shortcut
 if not shK then pass controlkeydown
 if field is not in tarName then pass controlkeydown
 if revNewScriptEditor is not in tarName then pass controlkeydown
 put the selectedLine into tLineCh
 if  to  is in tLineCh then
put word 2 of tLineCh into stLineNbr
put word 4 of tLineCh into endLineNbr
put line stLineNbr to endLineNbr of target into scriptLinesText
repeat with n = 1 to the number of lines of scriptLinesText
   put sr(line n of scriptLinesText) into tLineText
   if char 1 to 2 of tLineText = -  -
   then delete char 1 to 2 of tLineText
   put tLineText into line n of scriptLinesText
end repeat
put scriptLinesText into line stLineNbr to endLineNbr of the target
 else
put sr(value(tLineCh)) into tLineText
if char 1 to 2 of tLineText = -- then
   delete char 1 to 2 of tLineText
   do put tLineText into  tLineCh
end if
 end if
 doUndoSpace
 send tabkey to tarname
 break
  default
 pass controlkeydown
   end switch
end controlkeydown

private command doUndoSpace
   -- this solves the problem that after the above scripted operations
   -- the script editor remains unaware that the script has changed,
   -- so an enterkey will close but not save the changed script
   -- thus we have to *type* at least one character
   lock screen
   put the selectedText into selTxt
   type numToChar(32) -- the important step
   put word 4 of the selectedChunk into charNbr
   put selTxt into char charNbr of the target
   unlock screen
end doUndoSpace

function sr pText
   return word 1 to -1 of pText
end sr

On Jul 23, 2015, at 6:30 AM, Alan Stenhouse wrote:

 The uncomment keyboard shortcut has never worked for me either, would love if 
 it did.
 
 Interestingly, after someone posted about holding open the menu and then 
 trying it, it does work. Haven’t investigated further though.
 
 Wonder if it’s possibly related to having multiple keyboard languages 
 available. 
 
 Was surprised to hear from many that it works fine for them…!! Thought that 
 it was again, one of those things…
 
 cheers
 
 Alan
 
 On 23 Jul 2015, at 12:00 pm, use-livecode-requ...@lists.runrev.com wrote:
 
 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
 
 
 

Re: LiveCode and SQLite performace

2015-07-24 Thread Mike Doub


I'm z



On Jul 24, 2015, 10:23 AM, at 10:23 AM, EED-wp Email proth...@earthednet.org 
wrote:
I've found DiskWarrior to be an indispensable tool on my Mac. It fixes
disc corruption that diskutil can't and optimizes the directory. It
might be worth a try. 
Bill

William Prothero
http://ed.earthednet.org

 On Jul 24, 2015, at 4:50 AM, JB sund...@pacifier.com wrote:
 
 10% might work for you but it definitely does not
 work for me.  I have a 1tb drive and 348 gb free
 space.  Most operations run slower than normal.
 I deleted about 150gb of music to bring it up to
 350gb because it ran too slow to use.  Now it
 runs fast enough to use but I still have a lot of
 wasted time.  I had a 350gb drive and had the
 same problems way before 35gb free space.
 
 John Balgenorth
 
 
 On Jul 24, 2015, at 4:15 AM, Robert Brenstein r...@robelko.com
wrote:
 
 A rule of thumb for Mac is 10% of drive being free...
 
 I find iStat Menus a useful tool for continuous monitoring of vital
parameters (just a happy user).
 
 RObert
 
 
 On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:
 If I remember correctly Bob Sneidar said that a
 you need at least 1/2 of your hard drive as free
 space to run efficiently.  So if you have a drive
 with 500 GB you need 250 GB or more free
 space on the drive.  Anything below that and
 it normal operations like opening files will be
 slower.  I have used more space than 1/2 and
 the more I use the slower it gets.  Sometimes
 you can speed things up a little by relaunching
 the Finder.  That can be done using the Force
 Quit option.  If it speeds things up it will only be
 a temporary fix.
 
 John Balgenorth
 
 ___
 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: Anomalous Script behavior

2015-07-24 Thread Peter Bogdanoff
Craig and Peter,

Thanks for your replies.

Yes, I’ve seen this happen other times, but then it does just go away.

Here I’m seeing it reoccur over and over...

I tried the same script in LC 6.1.3 and it seems better there, but will do more 
testing.

It could be that there is an unexpected value being passed, and maybe LC 7 is 
more susceptible to it.

Peter

On Jul 24, 2015, at 8:33 AM, Peter Haworth p...@lcsql.com wrote:

 I've run into situations like this and it usually seems to be caused by an
 unexpected value in a variable passed to an lc function or command which
 causes it to silently quit and stop the rest of the calling script from
 executing.  Hard to define what unexpected means and I'm trying to think
 of an example but it's been a while since it happened to me.
 
 I would add some code to your tracking mechanism to track the value of any
 critical variables, especially those that are passed as parameters to other
 handlers.
 
 On Thu, Jul 23, 2015 at 10:16 PM Peter Bogdanoff bogdan...@me.com wrote:
 
 Using LC 7.1 dp1
 
 Part of a script sometimes doesn’t function—sometimes it works just fine.
 Sometimes it refuses to continue to execute the rest of a handler. This
 refusal will happen over and over until some point in my testing it starts
 working again beautifully.
 
 It’s a group script with 35,655 characters. Is there a limit to the number
 of characters?
 
 I put in breakpoints that are sometimes reached, sometimes not.
 
 It’s a handler that is being called by callbacks in a player as the media
 plays, so it’s difficult to debug while the media is playing. So I put some
 code in to put data into a field when those lines of the script are
 reached. Then I can see the progression through the script in real time.
 When it’s not working properly, while the handler IS receiving the callback
 calls, that field stays empty.
 
 Any ideas?
 
 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
 
 ___
 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: Force window on second display

2015-07-24 Thread Magicgate Software - Skip Kimpel
Works like a charm Thank you!

On Fri, Jul 24, 2015 at 9:49 AM, Mark Schonewille 
m.schonewi...@economy-x-talk.com wrote:

 Skip,

 This time I have tested it:

 put line 2 of the screenRects into myRect
 put (item 1 of myRect + item 3 of myRect) / 2 into X
 put (item 2 of myRect + item 4 of myRect) / 2 into Y
 set the loc of stack myStack to X,Y

 --
 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/24/2015 15:28, Magicgate Software - Skip Kimpel wrote:

 put line 2 of the screenRects into myRect

 put (item 1 of myRect + item 2 of myRect) / 2 into X
 put (item 3 of myRect + item 4 of myRect) / 2 into Y
 set the loc of stack myStack to X,Y


 ___
 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

2015-07-24 Thread Mike Doub
@



On Jul 24, 2015, 10:23 AM, at 10:23 AM, EED-wp Email proth...@earthednet.org 
wrote:
I've found DiskWarrior to be an indispensable tool on my Mac. It fixes
disc corruption that diskutil can't and optimizes the directory. It
might be worth a try. 
Bill

William Prothero
http://ed.earthednet.org

 On Jul 24, 2015, at 4:50 AM, JB sund...@pacifier.com wrote:
 
 10% might work for you but it definitely does not
 work for me.  I have a 1tb drive and 348 gb free
 space.  Most operations run slower than normal.
 I deleted about 150gb of music to bring it up to
 350gb because it ran too slow to use.  Now it
 runs fast enough to use but I still have a lot of
 wasted time.  I had a 350gb drive and had the
 same problems way before 35gb free space.
 
 John Balgenorth
 
 
 On Jul 24, 2015, at 4:15 AM, Robert Brenstein r...@robelko.com
wrote:
 
 A rule of thumb for Mac is 10% of drive being free...
 
 I find iStat Menus a useful tool for continuous monitoring of vital
parameters (just a happy user).
 
 RObert
 
 
 On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:
 If I remember correctly Bob Sneidar said that a
 you need at least 1/2 of your hard drive as free
 space to run efficiently.  So if you have a drive
 with 500 GB you need 250 GB or more free
 space on the drive.  Anything below that and
 it normal operations like opening files will be
 slower.  I have used more space than 1/2 and
 the more I use the slower it gets.  Sometimes
 you can speed things up a little by relaunching
 the Finder.  That can be done using the Force
 Quit option.  If it speeds things up it will only be
 a temporary fix.
 
 John Balgenorth
 
 ___
 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

2015-07-24 Thread Richard Gaskin
The guidelines I'd read were about 15% IIRC;  I believe there used to be 
a tech note on this, but I can no longer find it at apple.com.  Most 
third-party sites discussing this cite 15%.


If OS X required us to never use half of our disk space that would be 
quite a public controversy, since that's far beyond what any other file 
system requires and would represent a tremendous waste of storage resources.


If you have poor performance on a Mac that has more than 15% free, 
chances are free space isn't the cause.


There may be other issues with the drive (+1 for Disk Warrior), or 
either the primary or a secondary drive has a power-scaling feature that 
lets the platter rest when not in use, or corrupted b-tree elements, or 
any number of other factors.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


John Balgenorth wrote:


10% might work for you but it definitely does not
work for me.  I have a 1tb drive and 348 gb free
space.  Most operations run slower than normal.
I deleted about 150gb of music to bring it up to
350gb because it ran too slow to use.  Now it
runs fast enough to use but I still have a lot of
wasted time.  I had a 350gb drive and had the
same problems way before 35gb free space.

John Balgenorth


On Jul 24, 2015, at 4:15 AM, Robert Brenstein rjb at robelko.com wrote:


A rule of thumb for Mac is 10% of drive being free...

I find iStat Menus a useful tool for continuous monitoring of vital parameters 
(just a happy user).

RObert


On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:

If I remember correctly Bob Sneidar said that a
you need at least 1/2 of your hard drive as free
space to run efficiently.  So if you have a drive
with 500 GB you need 250 GB or more free
space on the drive.  Anything below that and
it normal operations like opening files will be
slower.  I have used more space than 1/2 and
the more I use the slower it gets.  Sometimes
you can speed things up a little by relaunching
the Finder.  That can be done using the Force
Quit option.  If it speeds things up it will only be
a temporary fix.

John Balgenorth



___
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: Anomalous Script behavior

2015-07-24 Thread Peter Haworth
I've run into situations like this and it usually seems to be caused by an
unexpected value in a variable passed to an lc function or command which
causes it to silently quit and stop the rest of the calling script from
executing.  Hard to define what unexpected means and I'm trying to think
of an example but it's been a while since it happened to me.

I would add some code to your tracking mechanism to track the value of any
critical variables, especially those that are passed as parameters to other
handlers.

On Thu, Jul 23, 2015 at 10:16 PM Peter Bogdanoff bogdan...@me.com wrote:

 Using LC 7.1 dp1

 Part of a script sometimes doesn’t function—sometimes it works just fine.
 Sometimes it refuses to continue to execute the rest of a handler. This
 refusal will happen over and over until some point in my testing it starts
 working again beautifully.

 It’s a group script with 35,655 characters. Is there a limit to the number
 of characters?

 I put in breakpoints that are sometimes reached, sometimes not.

 It’s a handler that is being called by callbacks in a player as the media
 plays, so it’s difficult to debug while the media is playing. So I put some
 code in to put data into a field when those lines of the script are
 reached. Then I can see the progression through the script in real time.
 When it’s not working properly, while the handler IS receiving the callback
 calls, that field stays empty.

 Any ideas?

 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

___
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: Force window on second display

2015-07-24 Thread Mark Wieder
Magicgate Software - Skip Kimpel skip@... writes:

  put line 2 of the screenRects into myRect

...although to make sure you stay out of trouble you might want

put line -1 of the screenRects into myRect

instead. That way if the second monitor gets unhooked you'll
still be able to see the stack.

-- 
 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: LiveCode and SQLite performace

2015-07-24 Thread JB
Thanks to everyone for the info.  It looks like
I need to run some test on it.

John Balgenorth



On Jul 24, 2015, at 8:19 AM, Richard Gaskin ambassa...@fourthworld.com wrote:

 The guidelines I'd read were about 15% IIRC;  I believe there used to be a 
 tech note on this, but I can no longer find it at apple.com.  Most 
 third-party sites discussing this cite 15%.
 
 If OS X required us to never use half of our disk space that would be quite a 
 public controversy, since that's far beyond what any other file system 
 requires and would represent a tremendous waste of storage resources.
 
 If you have poor performance on a Mac that has more than 15% free, chances 
 are free space isn't the cause.
 
 There may be other issues with the drive (+1 for Disk Warrior), or either the 
 primary or a secondary drive has a power-scaling feature that lets the 
 platter rest when not in use, or corrupted b-tree elements, or any number of 
 other factors.
 
 -- 
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com
 
 
 John Balgenorth wrote:
 
 10% might work for you but it definitely does not
 work for me.  I have a 1tb drive and 348 gb free
 space.  Most operations run slower than normal.
 I deleted about 150gb of music to bring it up to
 350gb because it ran too slow to use.  Now it
 runs fast enough to use but I still have a lot of
 wasted time.  I had a 350gb drive and had the
 same problems way before 35gb free space.
 
 John Balgenorth
 
 
 On Jul 24, 2015, at 4:15 AM, Robert Brenstein rjb at robelko.com wrote:
 
 A rule of thumb for Mac is 10% of drive being free...
 
 I find iStat Menus a useful tool for continuous monitoring of vital 
 parameters (just a happy user).
 
 RObert
 
 
 On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:
 If I remember correctly Bob Sneidar said that a
 you need at least 1/2 of your hard drive as free
 space to run efficiently.  So if you have a drive
 with 500 GB you need 250 GB or more free
 space on the drive.  Anything below that and
 it normal operations like opening files will be
 slower.  I have used more space than 1/2 and
 the more I use the slower it gets.  Sometimes
 you can speed things up a little by relaunching
 the Finder.  That can be done using the Force
 Quit option.  If it speeds things up it will only be
 a temporary fix.
 
 John Balgenorth
 
 
 ___
 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

2015-07-24 Thread Mike Kerner
As long as we're on this topic, I can't get over how much faster my POC
MacBook Air is than my not-so POC Mac Mini.  The former has an ssd, the
latter, a regular HD.  The former has a 1.4 ghz i5 with 4GB RAM, and the
latter a 2.3 ghz i5 with 16 GB RAM.  That SSD makes the air scream.

On Fri, Jul 24, 2015 at 1:03 PM, Richard Gaskin ambassa...@fourthworld.com
wrote:

 Mark Waddingham wrote:

  I'd get your hdd checked out asap.

 This is a good opportunity for all of us to remember that portable
 large-capacity hard drives are dirt cheap compared to the cost of lost
 data.  A USB 3.0 1TB drive can be picked up at the corner market for about
 US$60, and a 2TB drive for under US$85.

 I know everyone here already has multiple redundant daily backups anyway,
 but there was a time many years ago when I didn't, and I paid for it dearly.

 Now I have one copy of everything in the cloud, three in my office, and
 three at home which are rotated through the office so at least one of those
 offsite backups is never older than 24 hrs.

 With an rsync script backing up is super-fast and as easy as typing a
 single word in Terminal.  Yes, I also use Time Machine, but relying on any
 single backup isn't enough; drives fail, software fails, archives corrupt,
 merde happens.  rsync takes only a few minutes to learn and can move large
 amounts of data with ease anywhere, a perfect compliment to other backup
 systems for multiple redundancy.

 Far more than needed?  Exactly.  Disks are cheap, but time is the rarest
 commodity in the universe.

 Last year my MacBook Pro started acting wonky so before I ran any
 diagnostics the first thing I did was make a full backup.  Good thing: the
 mobo died half an hour later. I just copied the files I needed to another
 machine and was back to work in minutes.

 --
  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




-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, This is good.
___
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 performance

2015-07-24 Thread Ralph DiMola
+10

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Richard Gaskin
Sent: Friday, July 24, 2015 1:04 PM
To: use-livecode@lists.runrev.com
Subject: Re: LiveCode and SQLite performace

Mark Waddingham wrote:

  I'd get your hdd checked out asap.

This is a good opportunity for all of us to remember that portable
large-capacity hard drives are dirt cheap compared to the cost of lost data.
A USB 3.0 1TB drive can be picked up at the corner market for about US$60,
and a 2TB drive for under US$85.

I know everyone here already has multiple redundant daily backups anyway,
but there was a time many years ago when I didn't, and I paid for it dearly.

Now I have one copy of everything in the cloud, three in my office, and
three at home which are rotated through the office so at least one of those
offsite backups is never older than 24 hrs.

With an rsync script backing up is super-fast and as easy as typing a single
word in Terminal.  Yes, I also use Time Machine, but relying on any single
backup isn't enough; drives fail, software fails, archives corrupt, merde
happens.  rsync takes only a few minutes to learn and can move large amounts
of data with ease anywhere, a perfect compliment to other backup systems for
multiple redundancy.

Far more than needed?  Exactly.  Disks are cheap, but time is the rarest
commodity in the universe.

Last year my MacBook Pro started acting wonky so before I ran any
diagnostics the first thing I did was make a full backup.  Good thing: 
the mobo died half an hour later. I just copied the files I needed to
another machine and was back to work in minutes.

--
  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


Re: Anomalous Script behavior

2015-07-24 Thread Peter Haworth
Hi Mark,
Unfortunately, I don't recall the exact circumstances where this happened
because it's been a while.  I seem to remember it was a call to one of the
datagrid library handlers with a bad parameter that caused the handler
containing the handler to stop executing with no error message shown.  I
should have submitted a QCC report and will be sure to do so if and when it
happens again.

I can say with confidence that it was with an LC version prior to 6.7 and
that it was not related to a player callback.

On Fri, Jul 24, 2015 at 9:42 AM Mark Waddingham m...@livecode.com wrote:

 Hi Peter,

 Do you see a similar thing in 6.7?

 The reason I ask is that if the problem is only occurring in an a handler
 being invoked by the engine as part of callbacks set by the callback
 property on a player it could be something to do with that specific case.

 The player implementation on Mac changed completely from 6.7 onwards...

 Mark.

 Sent from my iPhone

  On 24 Jul 2015, at 06:15, Peter Bogdanoff bogdan...@me.com wrote:
 
  Using LC 7.1 dp1
 
  Part of a script sometimes doesn’t function—sometimes it works just
 fine. Sometimes it refuses to continue to execute the rest of a handler.
 This refusal will happen over and over until some point in my testing it
 starts working again beautifully.
 
  It’s a group script with 35,655 characters. Is there a limit to the
 number of characters?
 
  I put in breakpoints that are sometimes reached, sometimes not.
 
  It’s a handler that is being called by callbacks in a player as the
 media plays, so it’s difficult to debug while the media is playing. So I
 put some code in to put data into a field when those lines of the script
 are reached. Then I can see the progression through the script in real
 time. When it’s not working properly, while the handler IS receiving the
 callback calls, that field stays empty.
 
  Any ideas?
 
  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

 ___
 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: Anomalous Script behavior

2015-07-24 Thread Mark Waddingham
Hi Peter,

Do you see a similar thing in 6.7?

The reason I ask is that if the problem is only occurring in an a handler being 
invoked by the engine as part of callbacks set by the callback property on a 
player it could be something to do with that specific case.

The player implementation on Mac changed completely from 6.7 onwards...

Mark.

Sent from my iPhone

 On 24 Jul 2015, at 06:15, Peter Bogdanoff bogdan...@me.com wrote:
 
 Using LC 7.1 dp1
 
 Part of a script sometimes doesn’t function—sometimes it works just fine. 
 Sometimes it refuses to continue to execute the rest of a handler. This 
 refusal will happen over and over until some point in my testing it starts 
 working again beautifully.
 
 It’s a group script with 35,655 characters. Is there a limit to the number of 
 characters?
 
 I put in breakpoints that are sometimes reached, sometimes not.
 
 It’s a handler that is being called by callbacks in a player as the media 
 plays, so it’s difficult to debug while the media is playing. So I put some 
 code in to put data into a field when those lines of the script are reached. 
 Then I can see the progression through the script in real time. When it’s not 
 working properly, while the handler IS receiving the callback calls, that 
 field stays empty.
 
 Any ideas?
 
 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

___
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

2015-07-24 Thread Richard Gaskin

Mark Waddingham wrote:

 I'd get your hdd checked out asap.

This is a good opportunity for all of us to remember that portable 
large-capacity hard drives are dirt cheap compared to the cost of lost 
data.  A USB 3.0 1TB drive can be picked up at the corner market for 
about US$60, and a 2TB drive for under US$85.


I know everyone here already has multiple redundant daily backups 
anyway, but there was a time many years ago when I didn't, and I paid 
for it dearly.


Now I have one copy of everything in the cloud, three in my office, and 
three at home which are rotated through the office so at least one of 
those offsite backups is never older than 24 hrs.


With an rsync script backing up is super-fast and as easy as typing a 
single word in Terminal.  Yes, I also use Time Machine, but relying on 
any single backup isn't enough; drives fail, software fails, archives 
corrupt, merde happens.  rsync takes only a few minutes to learn and can 
move large amounts of data with ease anywhere, a perfect compliment to 
other backup systems for multiple redundancy.


Far more than needed?  Exactly.  Disks are cheap, but time is the rarest 
commodity in the universe.


Last year my MacBook Pro started acting wonky so before I ran any 
diagnostics the first thing I did was make a full backup.  Good thing: 
the mobo died half an hour later. I just copied the files I needed to 
another machine and was back to work in minutes.


--
 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: LiveCode and SQLite performace

2015-07-24 Thread Mark Waddingham
Hi Mike,

The only reference to slow opening of SQLite dbs on the Internet was to do with 
file permission issues on windows so if you are seeing this on Mac it very much 
sounds like a hard disk issue.

One of my colleagues had an issue recently with the hard drive in a 2011 iMac 
which didn't show up as a problem in any of the macs internal diagnostics. We 
replaced the drive and all was well again.

It would periodically get exceptionally slow when opening various files.

I'd get your hdd checked out asap.

Mark.

Sent from my iPhone

 On 23 Jul 2015, at 22:08, Michael Doub miked...@gmail.com wrote:
 
 Hey guys,
 
 I think that I have a system issue of some type.   We had a nasty 
 thunderstorm last night and we lost power.  Obviously my Mac was re-booted.  
 When I ran my timing tests this morning.   Open was 3 seconds and loading all 
 the data in to a variable was 1.   Much better.
 
 I just got back from a nice bike ride and tried it again.. some 5 hr later 
 with the mac running the whole time.   Open was 93 seconds and loading the 
 data was 23.
 
 This tells me that it has nothing to do with livecode or the database, but 
 something is going on with my system that is causing a dramatic slowdowns.
 
 -= Mike
 
 
 
 
 On 7/23/15 1:46 PM, Peter Haworth wrote:
 Hi Michael,
 Those are ridiculously long times!  I can't think of anything obvious that
 would cause them.  Mark's question about whether the automatic indexes are
 being recreated is a possibility but I'm pretty sure that doesn't happen.
 
 I couldn't tell from your original post if your table has a primary
 keydefined, looks like the ID column might be it?  Reason I ask is if would
 be worth trying SELECT primarykeycolumn FROM mytable since selecting
 all primary key columns is the absolute fastest select statement on a table
 so I'd be interested to see how long it takes.  If you don't have a primary
 key defined, use rowid instead.
 
 That doesn't help with the open time but it might shed some light and
 what's going on.
 
 If you would be willing to share the database with me offline, I'd be happy
 to see if I can spot anything.  I'd also be happy to post the problem on
 the sqlite developers list but in order to do that, I would need the exact
 CREATE statement used to create the table plus any other tables in the
 database.  Your sqlitebrowser tool should provide that somewhere.
 
 Pete
 
 
 
 On Wed, Jul 22, 2015 at 4:33 PM Michael Doubmiked...@gmail.com  wrote:
 
 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 Doubmiked...@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 

Re: Best practise for a quiz control?

2015-07-24 Thread tbodine
Hi.
I would definitely write my own handler to manage and display the questions
and call that handler with a Send command instead of the forever loop. 
-- Tom Bodine




--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/Best-practise-for-a-quiz-control-tp4694294p4694305.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 performance

2015-07-24 Thread Michael Doub
First off, I want to thank all of you that have given me suggestions.  
It really is appreciated.   Here is the update.


I backed up all of my data to an external drive and did a complete 
re-installation of the OS, then resorted the data.   The first few tests 
of the database were fine, but after waiting a few hrs and trying again 
I saw the long open time again.  At this point I exported all of the 
data to csv file and to sql file.I recreated the database file with 
a table where I definitely specified the ID as primary key.   I imported 
the csv data.  I tried importing the sql but I aborted the process after 
an hour, as the progress was really poor.  The csv import was done in 
under a minute.   Now open times are a consistent 7 seconds with the 
load of the entire database into a variable is 4 seconds.   I did all of 
this last night and I am seeing the same behavior this afternoon.


So my take on this is that I did have a systems issue that was slowing 
things down, but I also think that the database was not configured 
correctly initially.


Anyway, I am operational again.   And thanks again for your kind help.

-= Mike



On 7/24/15 1:36 PM, Ralph DiMola wrote:

+10

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Richard Gaskin
Sent: Friday, July 24, 2015 1:04 PM
To: use-livecode@lists.runrev.com
Subject: Re: LiveCode and SQLite performace

Mark Waddingham wrote:

   I'd get your hdd checked out asap.

This is a good opportunity for all of us to remember that portable
large-capacity hard drives are dirt cheap compared to the cost of lost data.
A USB 3.0 1TB drive can be picked up at the corner market for about US$60,
and a 2TB drive for under US$85.

I know everyone here already has multiple redundant daily backups anyway,
but there was a time many years ago when I didn't, and I paid for it dearly.

Now I have one copy of everything in the cloud, three in my office, and
three at home which are rotated through the office so at least one of those
offsite backups is never older than 24 hrs.

With an rsync script backing up is super-fast and as easy as typing a single
word in Terminal.  Yes, I also use Time Machine, but relying on any single
backup isn't enough; drives fail, software fails, archives corrupt, merde
happens.  rsync takes only a few minutes to learn and can move large amounts
of data with ease anywhere, a perfect compliment to other backup systems for
multiple redundancy.

Far more than needed?  Exactly.  Disks are cheap, but time is the rarest
commodity in the universe.

Last year my MacBook Pro started acting wonky so before I ran any
diagnostics the first thing I did was make a full backup.  Good thing:
the mobo died half an hour later. I just copied the files I needed to
another machine and was back to work in minutes.

--
   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




___
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


AW: Best practise for a quiz control?

2015-07-24 Thread Tiemo Hollmann TB
Hi Tim,
thanks for your recommendation
Tiemo


-Ursprüngliche Nachricht-
Von: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] Im Auftrag
von tbodine
Gesendet: Freitag, 24. Juli 2015 15:54
An: use-revolut...@lists.runrev.com
Betreff: Re: Best practise for a quiz control?

Hi.
I would definitely write my own handler to manage and display the questions
and call that handler with a Send command instead of the forever loop. 
-- Tom Bodine




--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Best-practise-for-a-quiz-cont
rol-tp4694294p4694305.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: Force window on second display

2015-07-24 Thread Mark Schonewille

put line 2 of the screenRects into myRect
put (item 1 of myRect + item 2 of myRect) / 2 into X
put (item 3 of myRect + item 4 of myRect) / 2 into Y
set the loc of stack myStack to X,Y

You might use working screenRects instead of screenRects.

--
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/24/2015 15:19, Magicgate Software - Skip Kimpel wrote:

A bright good morning and a happy Friday to all you LC'ers,

Is there a way to force a standalone on a second connected display?  This
is for a retail environment where I am sending data and info to a customer
standing on the other side of a counter viewing a secondary monitor.  I
want this to be automated so that if the computer is rebooted and the
application is launched, the employee does not have to drag the LC
application window to the other screen.

Thank you, as always, for your input!

SKIP
___
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: Force window on second display

2015-07-24 Thread Magicgate Software - Skip Kimpel
Thank you for the quick response Mark!

On Fri, Jul 24, 2015 at 9:24 AM, Mark Schonewille 
m.schonewi...@economy-x-talk.com wrote:

 put line 2 of the screenRects into myRect
 put (item 1 of myRect + item 2 of myRect) / 2 into X
 put (item 3 of myRect + item 4 of myRect) / 2 into Y
 set the loc of stack myStack to X,Y

 You might use working screenRects instead of screenRects.

 --
 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/24/2015 15:19, Magicgate Software - Skip Kimpel wrote:

 A bright good morning and a happy Friday to all you LC'ers,

 Is there a way to force a standalone on a second connected display?  This
 is for a retail environment where I am sending data and info to a customer
 standing on the other side of a counter viewing a secondary monitor.  I
 want this to be automated so that if the computer is rebooted and the
 application is launched, the employee does not have to drag the LC
 application window to the other screen.

 Thank you, as always, for your input!

 SKIP
 ___
 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: Force window on second display

2015-07-24 Thread Mark Schonewille

Yeah, but obviously I messed it up. I'll post a correct script in a sec.

--
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/24/2015 15:28, Magicgate Software - Skip Kimpel wrote:

Thank you for the quick response Mark!

On Fri, Jul 24, 2015 at 9:24 AM, Mark Schonewille 
m.schonewi...@economy-x-talk.com wrote:


put line 2 of the screenRects into myRect
put (item 1 of myRect + item 2 of myRect) / 2 into X
put (item 3 of myRect + item 4 of myRect) / 2 into Y
set the loc of stack myStack to X,Y

You might use working screenRects instead of screenRects.

--
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/24/2015 15:19, Magicgate Software - Skip Kimpel wrote:


A bright good morning and a happy Friday to all you LC'ers,

Is there a way to force a standalone on a second connected display?  This
is for a retail environment where I am sending data and info to a customer
standing on the other side of a counter viewing a secondary monitor.  I
want this to be automated so that if the computer is rebooted and the
application is launched, the employee does not have to drag the LC
application window to the other screen.

Thank you, as always, for your input!

SKIP
___
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


Force window on second display

2015-07-24 Thread Magicgate Software - Skip Kimpel
A bright good morning and a happy Friday to all you LC'ers,

Is there a way to force a standalone on a second connected display?  This
is for a retail environment where I am sending data and info to a customer
standing on the other side of a counter viewing a secondary monitor.  I
want this to be automated so that if the computer is rebooted and the
application is launched, the employee does not have to drag the LC
application window to the other screen.

Thank you, as always, for your input!

SKIP
___
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: Force window on second display

2015-07-24 Thread Mark Schonewille

Skip,

This time I have tested it:

put line 2 of the screenRects into myRect
put (item 1 of myRect + item 3 of myRect) / 2 into X
put (item 2 of myRect + item 4 of myRect) / 2 into Y
set the loc of stack myStack to X,Y

--
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/24/2015 15:28, Magicgate Software - Skip Kimpel wrote:

put line 2 of the screenRects into myRect

put (item 1 of myRect + item 2 of myRect) / 2 into X
put (item 3 of myRect + item 4 of myRect) / 2 into Y
set the loc of stack myStack to X,Y


___
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


Referencing a control name

2015-07-24 Thread Peter Bogdanoff
Hi all,

I have this data in a field MyField:

button Home,37,26,2,699

I want to reference that data like this:

set the width of item 1 of line 1 of field “MyField” to item 2 of 
line 1 of field “MyField”

How do I script the stuff inside the  ? Sometimes that item will be a field, 
graphic, etc.

Having a brain freeze.

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: Referencing a control name

2015-07-24 Thread Mark Schonewille
First put the reference into a variable and then

Set the width of myVar to x 

--
Kind regards,

Mark Schonewille
Economy-x-Talk
Http://economy-x-talk.com

Share the clipboard of your computer over a local network with Clipboard Link 
http://clipboardlink.economy-x-talk.com


Op 25 jul. 2015 om 02:05 heeft Peter Bogdanoff bogdan...@me.com het volgende 
geschreven:

 Hi all,
 
 I have this data in a field MyField:
 
button Home,37,26,2,699
 
 I want to reference that data like this:
 
set the width of item 1 of line 1 of field “MyField” to item 2 of line 1 
 of field “MyField”
 
 How do I script the stuff inside the  ? Sometimes that item will be a 
 field, graphic, etc.
 
 Having a brain freeze.
 
 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

___
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

[ANN] mergExt support for iOS 8.4

2015-07-24 Thread Monte Goulding
Hi LiveCoders

I’ve just uploaded new builds for all my externals that support iOS 8.4 so you 
can build your apps against Xcode 6.4 using the latest versions of LiveCode. 
While you’re at the site downloading the new releases be sure to check to see 
how much time you have left on your access so you can take advantage of the 20% 
off offer if you still have some time left. It’s on the right side of the 
screen below your name. 

The other thing worth noting is I currently have a poll going on the LiveCode 
User Group on facebook to decide what to implement next. At the moment adding 
Directions support to mergMK looks like the most feasible out of the popular 
options. I will have some good news on CoreBluetooth (BLE) shortly anyway.

https://www.facebook.com/groups/livecodeusers/permalink/893125430726308/?qa_ref=qd
 
https://www.facebook.com/groups/livecodeusers/permalink/893125430726308/?qa_ref=qd

Cheers

Monte

--
M E R Goulding http://goulding.ws/ 
Software development services
Bespoke application development for vertical markets

mergExt http://mergext.com/ - There's an external for that!

___
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: Referencing a control name

2015-07-24 Thread Ralph DiMola
Also control is a synonym for field, button, image.

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net


-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Peter Bogdanoff
Sent: Friday, July 24, 2015 8:06 PM
To: How to use LiveCode
Subject: Referencing a control name

Hi all,

I have this data in a field MyField:

button Home,37,26,2,699

I want to reference that data like this:

set the width of item 1 of line 1 of field MyField to item 2 of
line 1 of field MyField

How do I script the stuff inside the  ? Sometimes that item will be a
field, graphic, etc.

Having a brain freeze.

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


___
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: Referencing a control name

2015-07-24 Thread Dick Kriesel

 On Jul 24, 2015, at 5:05 PM, Peter Bogdanoff bogdan...@me.com wrote:
 
 I want to reference that data like this:
 
   set the width of item 1 of line 1 of field “MyField” to item 2 of 
 line 1 of field “MyField”
 
 How do I script the stuff inside the  ? Sometimes that item will be a 
 field, graphic, etc.
 


Hi, Peter.  You could just replace your delimiters:

set the width of (item 1 of line 1 of field “MyField”) to item 2 of line 1 of 
field “MyField”

— Dick
___
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

2015-07-24 Thread JB
10% might work for you but it definitely does not
work for me.  I have a 1tb drive and 348 gb free
space.  Most operations run slower than normal.
I deleted about 150gb of music to bring it up to
350gb because it ran too slow to use.  Now it
runs fast enough to use but I still have a lot of
wasted time.  I had a 350gb drive and had the
same problems way before 35gb free space.

John Balgenorth


On Jul 24, 2015, at 4:15 AM, Robert Brenstein r...@robelko.com wrote:

 A rule of thumb for Mac is 10% of drive being free...
 
 I find iStat Menus a useful tool for continuous monitoring of vital 
 parameters (just a happy user).
 
 RObert
 
 
 On 23.07.2015 at 15:37 Uhr -0700 JB apparently wrote:
 If I remember correctly Bob Sneidar said that a
 you need at least 1/2 of your hard drive as free
 space to run efficiently.  So if you have a drive
 with 500 GB you need 250 GB or more free
 space on the drive.  Anything below that and
 it normal operations like opening files will be
 slower.  I have used more space than 1/2 and
 the more I use the slower it gets.  Sometimes
 you can speed things up a little by relaunching
 the Finder.  That can be done using the Force
 Quit option.  If it speeds things up it will only be
 a temporary fix.
 
 John Balgenorth
 
 ___
 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