Re: strange htmltext problem

2012-09-19 Thread Peter Haworth
I'm having issues with htmltext also.

I'm using the sub tag to do the equivalent of setting the textshift of a
character and the img tag to do the equivalent of setting the
imagesource, eg

sub shift=2img src=1234 char= /sub

I can clearly see this in the variable I use to set the htmltext, yet when
I get the htmltext of the field, the sub clauses are sometimes there,
sometimes not.  Even if they are there, they don't have any effect.

I'd really like to get this working if I can since using htmltext appears
much faster than setting the imagesource and textshift on individual lines
in the field when there are a large number of lines to be processed.

This is with LC 5.5.0, OSX 10.7.

Pete
lcSQL Software http://www.lcsql.com



On Tue, Sep 18, 2012 at 7:37 AM, Klaus on-rev kl...@major.on-rev.comwrote:

 Hi friends,

 I have a strange htmltext problem with LC 5.52 while working on a rating
 thing (5 stars etc..) with a LOCKED field :-)

 I have this script:
 on mouseUp
put 12345 into fld 1
repeat with i = 1 to 5
   set the imagesource of char i of fld 1 to 1005
end repeat
 end mouseUp

 Works fine, 5 white stars appear, and when I check the htmltext of fld 1 I
 get:
 RETURNS added for readability
 p
 img src=1005 char=1
 img src=1005 char=2
 img src=1005 char=3
 img src=1005 char=4
 img src=1005 char=5
 /p

 Fine so far, but when I set the htmltext of that field to the (Livecode
 approved?) string above, only ONE star appears
 and the htmltext reports:
 p
 img src=1005 char=12345
 /p

 WTF?
 What am I missing?

 Any hints very appreciated!


 Best

 Klaus

 --
 Klaus Major
 http://www.major-k.de
 kl...@major.on-rev.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: Cut-Paste across stacks ?

2012-09-19 Thread Richmond

On 09/19/2012 12:29 AM, J. Landman Gay wrote:

On 9/18/12 3:18 PM, Richmond wrote:

If one has a stack with, for example, 2 substacks, one of
which contains an image X.png.

Now I want to move image X.png from substack sONE
to substack sTWO.

sending the command  cut img X.png  seems all very straightforward 
. . .


BUT . . .

while I can issue the command  paste

how can I ensure that the clipboard contents (i.e. img X.png) are
pasted into substack sTWO rather than abck into substack sONE ?


Go there, with the screen locked if you want.

Or you can avoid the clipboard entirely:

  copy img X.png to cd x of stack sTWO
  delete img X.png of this cd



That looks wonderful. Thanks a lot.

Richmond.

___
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: SQL question

2012-09-19 Thread AndyP
Hi Mark,

I think one way to do this would be:

use the 'SHOW Columns' SQL command ie, 

SHOW Columns from Table

Then put the column names into an array using revDatabaseColumnNames

Cycle through the array and use a SELECT command for each element





-
Andy Piddock


My software never has bugs. It just develops random features.
PointandSee is a FREE simple but full featured under cursor colour picker / 
finder.
http://www.pointandsee.co.uk - made with LiveCode (v1.4.1 released 26/08/2011)


--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/SQL-question-tp4655184p4655192.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: SQL question

2012-09-19 Thread Mark Schonewille
Pete,

I get all your messages twice. Could you please stop sending copies to the old 
address of this list?

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour 
spaces. http://www.color-converter.com



On 19 sep 2012, at 07:40, Peter Haworth wrote:

 I'm not sure that will work.  If Column2 started with MyCriteria, I don't
 think it would be selected.  Any queries of the form LIKE '%mycriteria%'
 would work though.
 
 Klaus, have you implemented a solution to this yet?  I don't recall you
 mentioning which flavor of SQL you're using and that makes a difference.
 
 Pete
 lcSQL Software http://www.lcsql.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: SQL question

2012-09-19 Thread Richmond

On 09/19/2012 11:37 AM, Mark Schonewille wrote:

Pete,

I get all your messages twice. Could you please stop sending copies to the old 
address of this list?


A bit like Sesame Street's Vincent Twice, nicht?



--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour 
spaces. http://www.color-converter.com



On 19 sep 2012, at 07:40, Peter Haworth wrote:


I'm not sure that will work.  If Column2 started with MyCriteria, I don't
think it would be selected.  Any queries of the form LIKE '%mycriteria%'
would work though.

Klaus, have you implemented a solution to this yet?  I don't recall you
mentioning which flavor of SQL you're using and that makes a difference.

Pete
lcSQL Software http://www.lcsql.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: SQL question

2012-09-19 Thread Klaus on-rev
Hi Peter,

Am 19.09.2012 um 07:40 schrieb Peter Haworth p...@lcsql.com:

 I'm not sure that will work.  If Column2 started with MyCriteria, I don't
 think it would be selected.  Any queries of the form LIKE '%mycriteria%'
 would work though.

using wildcards is not my problem ;-)

 Klaus, have you implemented a solution to this yet?  I don't recall you
 mentioning which flavor of SQL you're using and that makes a difference.

ah, sorry, I will use a local SQLite database.

 Pete
 lcSQL Software http://www.lcsql.com
 
 
 On Tue, Sep 18, 2012 at 8:13 PM, Mark Stuart mfstu...@cox.net wrote:
 
 Klaus try concatenating the columns like this:
 SELECT Column1, Column2, Column3 FROM Table WHERE (Column1 + Column2 LIKE
 'MyCriteria%')

Hi Mark,

sounds good, will try this.

I want to provide a Search field where the user can use a popup to
select a specific database field or a global search.


Thanks for all the hints, so far, I'm sure I will use one of them :-)


Best

Klaus

--
Klaus Major
http://www.major-k.de
kl...@major.on-rev.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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Peter M. Brigham
On Sep 18, 2012, at 2:01 PM, Mike Bonner wrote:

 Get it? Too ugly for U. No U. Oo. Oogly. HAR HAR HAR HAR HAR *cough* Sorry
 it got away from me there for a sec.

Analyzing humor is like dissecting a frog: nobody is interested, and the frog 
dies.:-)

-- Peter

Peter M. Brigham
pmb...@gmail.com
http://home.comcast.net/~pmbrig


___
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: Cut-Paste across stacks ?

2012-09-19 Thread Peter M. Brigham
Why not just:

copy img X.png of stack sONE to card n of stack sTWO
delete img X.png of stack sONE

-- Peter

Peter M. Brigham
pmb...@gmail.com
http://home.comcast.net/~pmbrig

On Sep 18, 2012, at 4:18 PM, Richmond wrote:

 If one has a stack with, for example, 2 substacks, one of
 which contains an image X.png.
 
 Now I want to move image X.png from substack sONE
 to substack sTWO.
 
 sending the command  cut img X.png  seems all very straightforward . . .
 
 BUT . . .
 
 while I can issue the command  paste
 
 how can I ensure that the clipboard contents (i.e. img X.png) are
 pasted into substack sTWO rather than abck into substack sONE ?
 
 Richmond.
 
 ___
 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: strange htmltext problem

2012-09-19 Thread Klaus on-rev
Hi friends,

Am 18.09.2012 um 16:37 schrieb Klaus on-rev kl...@major.on-rev.com:

 Hi friends,
 
 I have a strange htmltext problem with LC 5.52 while working on a rating 
 thing (5 stars etc..) with a LOCKED field :-)
 ...
 Fine so far, but when I set the htmltext of that field to the (Livecode 
 approved?) string above, only ONE star appears
 and the htmltext reports:
 p
 img src=1005 char=12345
 /p

FYI: I filed a bug report for this:
http://quality.runrev.com/show_bug.cgi?id=10399


Best

Klaus

--
Klaus Major
http://www.major-k.de
kl...@major.on-rev.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: Setting a local certificate for HTTPS

2012-09-19 Thread Mark Wieder
Keith-

Monday, September 17, 2012, 12:25:15 PM, you wrote:

 So, how does one go about setting a local certificate in LiveCode
 for HTTPS connections? The User Guide is rather vague on this.

AFAIK you don't.
What's worked for me is disabling the check for a valid certificate:

libUrlSetSSLVerification false

-- 
-Mark Wieder
 mwie...@ahsoftware.net


___
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: detect keyboard height on mobile

2012-09-19 Thread Ralph DiMola
I am running into the same issue on iOS also as I use generic resizing SW.
The rect of the real-estate remaining would be nice to know.

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


-Original Message-
From: use-livecode-boun...@lists.runrev.com
[mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Andre Garzia
Sent: Tuesday, September 18, 2012 9:30 PM
To: How to use LiveCode
Subject: detect keyboard height on mobile

Hey Folks,

Is there a way to detect the keyboard height on mobile? I know that for iOS
we have some pretty standard sizes but for Android there are replacement
keyboards and different UIs for each vendor. Anyone has a solution for that?
I need to calculate the usable rect of the screen when the keyboard is
showing.

cheers
andre

--
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.
___
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: detect keyboard height on mobile

2012-09-19 Thread Colin Holgate
The situation is more complicated than you may be thinking. On iOS you can 
split the keyboard into two halves that slide up to half way, or you can undock 
and the keyboard remains intact, but sits halfway up the screen. You may want 
to always make sure that important text into fields are in the top third of the 
screen.


On Sep 19, 2012, at 11:20 AM, Ralph DiMola rdim...@evergreeninfo.net wrote:

 I am running into the same issue on iOS also as I use generic resizing SW.
 The rect of the real-estate remaining would be nice to know.

___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Bob Sneidar
There's my new Available message!

On Sep 19, 2012, at 4:21 AM, Peter M. Brigham wrote:

 Analyzing humor is like dissecting a frog: nobody is interested, and the frog 
 dies.


___
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: detect keyboard height on mobile

2012-09-19 Thread Ralph DiMola
Colin,

Thanks, the upper 3rd is my current solution. Getting message whenever the
working rect changes with a list rect(s) of open real-estate would allow me
to deal with this, or I can just keep all input fields in the upper 3rd.

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


-Original Message-
From: use-livecode-boun...@lists.runrev.com
[mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Colin Holgate
Sent: Wednesday, September 19, 2012 11:26 AM
To: How to use LiveCode
Subject: Re: detect keyboard height on mobile

The situation is more complicated than you may be thinking. On iOS you can
split the keyboard into two halves that slide up to half way, or you can
undock and the keyboard remains intact, but sits halfway up the screen. You
may want to always make sure that important text into fields are in the top
third of the screen.


On Sep 19, 2012, at 11:20 AM, Ralph DiMola rdim...@evergreeninfo.net
wrote:

 I am running into the same issue on iOS also as I use generic resizing SW.
 The rect of the real-estate remaining would be nice to know.

___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Richard Gaskin

Mark Wieder wrote:

Since I haven't yet gotten my authorization to post on the board, let
me say here that I'm already using the uRIP[project] in glx2 for
version control.


That may be the best place for it - good idea.

Please do post that in the forum thread:
http://livecodejournal.com/forum/viewtopic.php?f=30t=71

I'm not sure how PHPBB sends notifications for such things, but I 
approved your account yesterday.




Is the old revInterOp yahoo group now defunct?


More or less.  When they were still eGroups they were kinda useful, but 
since the Yahoo acquisition there have been complaints about 
difficulties logging in, and no way to get assistance from anyone in 
Support at Yahoo.  In fact, there was an outage with their 
authentication server yesterday that prevented me from posting there, 
which is why I decided it's probably a good time to roll out the new 
forum Ken and I have been setting up for RIP, which now also includes an 
area for the MC IDE.


I haven't yet moved all of the relevant RPI and MC assets to their new 
home at LiveCodeJournal.com, but I intend to finish that soon.


Having a site where we control how it's set up, with no limits on file 
sizes, etc., offers us much more flexibility for building an effective 
working group going forward.


Among other benefits is allowing us to share the file repository without 
having to require membership.  Down the road we can even make those 
files directly accessible via RevNet as well, something we couldn't do 
at Yahoo Groups.


If you see any opportunities you'd like to help with, drop me a note and 
I can set you up with permissions, FTP, or whatever else is needed to 
make that happen.


When Alan Golub first established the original RevJournal.com site, he 
did so in the spirit of making it a community effort.  After he 
transferred the management of the site to me, which has since migrated 
to LiveCodeJournal.com, I've tried to maintain his vision by inviting 
all interested members of the community to consider it their home, open 
to any useful resources you'd like to see there.


--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 Follow me on Twitter:  http://twitter.com/FourthWorldSys

___
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: SQL question

2012-09-19 Thread Peter Haworth
Don't know why that would be Mark.  I simply reply to messages I get from
the list.  I guess if the original message was sent to the old and new
address then my reply would be too.  When sending new messages, I send to
use-livecode@lists.runrev.com.

Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 1:37 AM, Mark Schonewille 
m.schonewi...@economy-x-talk.com wrote:

 Pete,

 I get all your messages twice. Could you please stop sending copies to the
 old address of this list?

 --
 Best regards,

 Mark Schonewille

 Economy-x-Talk Consulting and Software Engineering
 Homepage: http://economy-x-talk.com
 Twitter: http://twitter.com/xtalkprogrammer
 KvK: 50277553

 Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour
 spaces. http://www.color-converter.com



 On 19 sep 2012, at 07:40, Peter Haworth wrote:

  I'm not sure that will work.  If Column2 started with MyCriteria, I
 don't
  think it would be selected.  Any queries of the form LIKE '%mycriteria%'
  would work though.
 
  Klaus, have you implemented a solution to this yet?  I don't recall you
  mentioning which flavor of SQL you're using and that makes a difference.
 
  Pete
  lcSQL Software http://www.lcsql.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: SQL question

2012-09-19 Thread Peter Haworth
On Wed, Sep 19, 2012 at 3:07 AM, Klaus on-rev kl...@major.on-rev.comwrote:

 Hi Peter,

 Am 19.09.2012 um 07:40 schrieb Peter Haworth p...@lcsql.com:

  I'm not sure that will work.  If Column2 started with MyCriteria, I
 don't
  think it would be selected.  Any queries of the form LIKE '%mycriteria%'
  would work though.

 using wildcards is not my problem ;-)


I understand, but if you end up using any of the solutions that
concatenates columns together, you'll have to use LIKE '%xyz%' instead of
='xyz'.


  Klaus, have you implemented a solution to this yet?  I don't recall you
  mentioning which flavor of SQL you're using and that makes a difference.

 ah, sorry, I will use a local SQLite database.


OK, good to know.  I don't remember all the solutions you've been given,
but here's a couple of notes.  Apologies if you already know this.

If you concatenate columns together, the operator to do that in sqlite is
|| not +.

I think there was one solution that used PATINDEX - sqlite doesn't have
that function.

I implemented exactly the same functionality in a name/address search db
once and ended up biting the bullet and using a WHERE clauses that tested
every column in the table for the string I was looking for.  A pain to code
because I probably had 20 or 30 columns to search but sometimes the
simplest solution is the best :-)


  Pete
  lcSQL Software http://www.lcsql.com
 
 
  On Tue, Sep 18, 2012 at 8:13 PM, Mark Stuart mfstu...@cox.net wrote:
 
  Klaus try concatenating the columns like this:
  SELECT Column1, Column2, Column3 FROM Table WHERE (Column1 + Column2
 LIKE
  'MyCriteria%')

 Hi Mark,

 sounds good, will try this.

 I want to provide a Search field where the user can use a popup to
 select a specific database field or a global search.


 Thanks for all the hints, so far, I'm sure I will use one of them :-)


 Best

 Klaus

 --
 Klaus Major
 http://www.major-k.de
 kl...@major.on-rev.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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Peter Haworth
Richard,
Great that this repository is available.  I just tried registering and am
stuck on the captcha codes.  I got it wrong on the first attempt and got an
error to that effect.  On every subsequent attempt, I was presented with a
new code but no error message.

I have to say I am not a big fan of captcha codes.  I understand their
purpose but the majority of the ones I come across are pretty much
indecipherable.

Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 8:48 AM, Richard Gaskin
ambassa...@fourthworld.comwrote:

 Mark Wieder wrote:

 Since I haven't yet gotten my authorization to post on the board, let
 me say here that I'm already using the uRIP[project] in glx2 for
 version control.


 That may be the best place for it - good idea.

 Please do post that in the forum thread:
 http://livecodejournal.com/**forum/viewtopic.php?f=30t=71http://livecodejournal.com/forum/viewtopic.php?f=30t=71
 

 I'm not sure how PHPBB sends notifications for such things, but I approved
 your account yesterday.


  Is the old revInterOp yahoo group now defunct?


 More or less.  When they were still eGroups they were kinda useful, but
 since the Yahoo acquisition there have been complaints about difficulties
 logging in, and no way to get assistance from anyone in Support at Yahoo.
  In fact, there was an outage with their authentication server yesterday
 that prevented me from posting there, which is why I decided it's probably
 a good time to roll out the new forum Ken and I have been setting up for
 RIP, which now also includes an area for the MC IDE.

 I haven't yet moved all of the relevant RPI and MC assets to their new
 home at LiveCodeJournal.com, but I intend to finish that soon.

 Having a site where we control how it's set up, with no limits on file
 sizes, etc., offers us much more flexibility for building an effective
 working group going forward.

 Among other benefits is allowing us to share the file repository without
 having to require membership.  Down the road we can even make those files
 directly accessible via RevNet as well, something we couldn't do at Yahoo
 Groups.

 If you see any opportunities you'd like to help with, drop me a note and I
 can set you up with permissions, FTP, or whatever else is needed to make
 that happen.

 When Alan Golub first established the original RevJournal.com site, he did
 so in the spirit of making it a community effort.  After he transferred the
 management of the site to me, which has since migrated to
 LiveCodeJournal.com, I've tried to maintain his vision by inviting all
 interested members of the community to consider it their home, open to any
 useful resources you'd like to see there.

 --
  Richard Gaskin
  Fourth World
  LiveCode training and consulting: http://www.fourthworld.com
  Webzine for LiveCode developers: http://www.LiveCodeJournal.com
  Follow me on Twitter:  
 http://twitter.com/**FourthWorldSyshttp://twitter.com/FourthWorldSys


 __**_
 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-livecodehttp://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: SQL question

2012-09-19 Thread Bob Sneidar
I wrote a function that did that. You pass it a comma del list of column names, 
and it builds an sql statement for you.  I will try to dig that up somewhere. 

Bob


On Sep 19, 2012, at 9:21 AM, Peter Haworth wrote:

 I implemented exactly the same functionality in a name/address search db
 once and ended up biting the bullet and using a WHERE clauses that tested
 every column in the table for the string I was looking for.  A pain to code
 because I probably had 20 or 30 columns to search but sometimes the
 simplest solution is the best :-)


___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Bob Sneidar
Try flushing the browser cache and trying again. 

On Sep 19, 2012, at 9:30 AM, Peter Haworth wrote:

 Richard,
 Great that this repository is available.  I just tried registering and am
 stuck on the captcha codes.  I got it wrong on the first attempt and got an
 error to that effect.  On every subsequent attempt, I was presented with a
 new code but no error message.
 
 I have to say I am not a big fan of captcha codes.  I understand their
 purpose but the majority of the ones I come across are pretty much
 indecipherable.
 
 Pete


___
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: lock/unlock screen

2012-09-19 Thread dunbarx
Peter.


Pretty sure this follows the HC way, in that lock screen commands are queued, 
and must be unlocked the same number of times they are locked.



You can always throw in:

repeat until the lockScreen is false


unlock screen
end repeat




Craig Newman




-Original Message-
From: Peter Haworth p...@lcsql.com
To: How to use LiveCode use-livecode@lists.runrev.com
Sent: Wed, Sep 19, 2012 1:00 pm
Subject: lock/unlock screen


Let's say I have a couple of function F1 and F2 that include lock and
unlock screen commands.  These handlers are called one after another from
another function F3 which does not have lock/unlock screen messages.  I'm
assuming that the screen would be unlocked at the end of F1 and F2, meaning
the screen would be updated twice.

Now lets say I have another function F4 which includes its own lock/unlock
screen and also calls F1 and F2.  When F1 unlocks the screen, does that
cancel out the lock screen issued by F4 or does the lock in F4 stay in
place until it is unlocked by F4?

I'm trying to figure out the best strategy for locking/unlocking the
screen.  It feels like the lock/unlock should be in the highest level
function that calls any other functions which update the screen.

Pete
lcSQL Software http://www.lcsql.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: lock/unlock screen

2012-09-19 Thread Bob Sneidar
In a prior post I seem to recall that the screen will unlock at the first idle 
message, no matter how many lock screens have been issued. Also, I think it's a 
one dimensional command, that is, the screen will unlock as soon as you issue 
an unlock screen. 

Bob


On Sep 19, 2012, at 10:08 AM, dunb...@aol.com wrote:

 Peter.
 
 
 Pretty sure this follows the HC way, in that lock screen commands are 
 queued, and must be unlocked the same number of times they are locked.
 
 
 
 You can always throw in:
 
 repeat until the lockScreen is false
 
 
 unlock screen
 end repeat
 
 
 
 
 Craig Newman
 
 
 
 
 -Original Message-
 From: Peter Haworth p...@lcsql.com
 To: How to use LiveCode use-livecode@lists.runrev.com
 Sent: Wed, Sep 19, 2012 1:00 pm
 Subject: lock/unlock screen
 
 
 Let's say I have a couple of function F1 and F2 that include lock and
 unlock screen commands.  These handlers are called one after another from
 another function F3 which does not have lock/unlock screen messages.  I'm
 assuming that the screen would be unlocked at the end of F1 and F2, meaning
 the screen would be updated twice.
 
 Now lets say I have another function F4 which includes its own lock/unlock
 screen and also calls F1 and F2.  When F1 unlocks the screen, does that
 cancel out the lock screen issued by F4 or does the lock in F4 stay in
 place until it is unlocked by F4?
 
 I'm trying to figure out the best strategy for locking/unlocking the
 screen.  It feels like the lock/unlock should be in the highest level
 function that calls any other functions which update the screen.
 
 Pete
 lcSQL Software http://www.lcsql.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: lock/unlock screen

2012-09-19 Thread Peter Haworth
Thanks Craig.
Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 10:08 AM, dunb...@aol.com wrote:

 Peter.


 Pretty sure this follows the HC way, in that lock screen commands are
 queued, and must be unlocked the same number of times they are locked.



 You can always throw in:

 repeat until the lockScreen is false


 unlock screen
 end repeat




 Craig Newman




 -Original Message-
 From: Peter Haworth p...@lcsql.com
 To: How to use LiveCode use-livecode@lists.runrev.com
 Sent: Wed, Sep 19, 2012 1:00 pm
 Subject: lock/unlock screen


 Let's say I have a couple of function F1 and F2 that include lock and
 unlock screen commands.  These handlers are called one after another from
 another function F3 which does not have lock/unlock screen messages.  I'm
 assuming that the screen would be unlocked at the end of F1 and F2, meaning
 the screen would be updated twice.

 Now lets say I have another function F4 which includes its own lock/unlock
 screen and also calls F1 and F2.  When F1 unlocks the screen, does that
 cancel out the lock screen issued by F4 or does the lock in F4 stay in
 place until it is unlocked by F4?

 I'm trying to figure out the best strategy for locking/unlocking the
 screen.  It feels like the lock/unlock should be in the highest level
 function that calls any other functions which update the screen.

 Pete
 lcSQL Software http://www.lcsql.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: lock/unlock screen

2012-09-19 Thread Peter Haworth
OK, seems like there's conflicting opinions then.  I guess I can use
Craig's idea of checking the lock screen to see how it unfolds.
Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 10:22 AM, Bob Sneidar b...@twft.com wrote:

 In a prior post I seem to recall that the screen will unlock at the first
 idle message, no matter how many lock screens have been issued. Also, I
 think it's a one dimensional command, that is, the screen will unlock as
 soon as you issue an unlock screen.

 Bob


 On Sep 19, 2012, at 10:08 AM, dunb...@aol.com wrote:

  Peter.
 
 
  Pretty sure this follows the HC way, in that lock screen commands are
 queued, and must be unlocked the same number of times they are locked.
 
 
 
  You can always throw in:
 
  repeat until the lockScreen is false
 
 
  unlock screen
  end repeat
 
 
 
 
  Craig Newman
 
 
 
 
  -Original Message-
  From: Peter Haworth p...@lcsql.com
  To: How to use LiveCode use-livecode@lists.runrev.com
  Sent: Wed, Sep 19, 2012 1:00 pm
  Subject: lock/unlock screen
 
 
  Let's say I have a couple of function F1 and F2 that include lock and
  unlock screen commands.  These handlers are called one after another from
  another function F3 which does not have lock/unlock screen messages.  I'm
  assuming that the screen would be unlocked at the end of F1 and F2,
 meaning
  the screen would be updated twice.
 
  Now lets say I have another function F4 which includes its own
 lock/unlock
  screen and also calls F1 and F2.  When F1 unlocks the screen, does that
  cancel out the lock screen issued by F4 or does the lock in F4 stay in
  place until it is unlocked by F4?
 
  I'm trying to figure out the best strategy for locking/unlocking the
  screen.  It feels like the lock/unlock should be in the highest level
  function that calls any other functions which update the screen.
 
  Pete
  lcSQL Software http://www.lcsql.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: lock/unlock screen

2012-09-19 Thread Richmond

Richmond had a genius moment :)

I made a wee stack called LOCKER with
two buttons; Triple-Play and Single Undo and
a fld fff containing the text UNLOCKED!

the script of btn Triple-Play goes like this:

on mouseUp
   set the vis of fld fff to false
set the lockscreen to true
set the lockscreen to true
set the lockscreen to true
end mouseUp

the script of btn Single Undo goes like this:

on mouseUp
   set the lockscreen to false
   if the lockscreen is false then
 set the vis of fld fff to true
   end if
end mouseUp

HOT, SCREAMING STUFF!

so; click on btn Triple-Play which locks the screen THRICE,

then; click on btn Single Undo which unlocks the screen ONCE,

and,

Bingo, Kazoom, Jumping Space Potatoes;

fld fff becomes visible.

Richmond.

___
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: lock/unlock screen

2012-09-19 Thread Peter Haworth
After putting some displays in my code, it seems that the locks are queued,
that is unlocking only unlocks the last lock, not all of them.

However, it also seems that the unlock doesn't take effect until the
handler it is in exits.  For example, F1, calls F2 and F2 locks and
unlocks.  A check of the lockscreen immediately after the unlock shows it
to be true.  A check of the lockscreen in F1 right after the call to F2
shows if to be false.

I also notice that if you are in debug mode, the lock screen has no effect,
that is the screen is updated each time a change to it is made even when
it's locked.

Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 10:22 AM, Bob Sneidar b...@twft.com wrote:

 In a prior post I seem to recall that the screen will unlock at the first
 idle message, no matter how many lock screens have been issued. Also, I
 think it's a one dimensional command, that is, the screen will unlock as
 soon as you issue an unlock screen.

 Bob


 On Sep 19, 2012, at 10:08 AM, dunb...@aol.com wrote:

  Peter.
 
 
  Pretty sure this follows the HC way, in that lock screen commands are
 queued, and must be unlocked the same number of times they are locked.
 
 
 
  You can always throw in:
 
  repeat until the lockScreen is false
 
 
  unlock screen
  end repeat
 
 
 
 
  Craig Newman
 
 
 
 
  -Original Message-
  From: Peter Haworth p...@lcsql.com
  To: How to use LiveCode use-livecode@lists.runrev.com
  Sent: Wed, Sep 19, 2012 1:00 pm
  Subject: lock/unlock screen
 
 
  Let's say I have a couple of function F1 and F2 that include lock and
  unlock screen commands.  These handlers are called one after another from
  another function F3 which does not have lock/unlock screen messages.  I'm
  assuming that the screen would be unlocked at the end of F1 and F2,
 meaning
  the screen would be updated twice.
 
  Now lets say I have another function F4 which includes its own
 lock/unlock
  screen and also calls F1 and F2.  When F1 unlocks the screen, does that
  cancel out the lock screen issued by F4 or does the lock in F4 stay in
  place until it is unlocked by F4?
 
  I'm trying to figure out the best strategy for locking/unlocking the
  screen.  It feels like the lock/unlock should be in the highest level
  function that calls any other functions which update the screen.
 
  Pete
  lcSQL Software http://www.lcsql.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: lock/unlock screen

2012-09-19 Thread J. Landman Gay

On 9/19/12 12:52 PM, Richmond wrote:

Richmond had a genius moment :)

I made a wee stack called LOCKER with
two buttons; Triple-Play and Single Undo and
a fld fff containing the text UNLOCKED!

the script of btn Triple-Play goes like this:

on mouseUp
set the vis of fld fff to false
 set the lockscreen to true
 set the lockscreen to true
 set the lockscreen to true
end mouseUp

the script of btn Single Undo goes like this:

on mouseUp
set the lockscreen to false
if the lockscreen is false then
  set the vis of fld fff to true
end if
end mouseUp

HOT, SCREAMING STUFF!

so; click on btn Triple-Play which locks the screen THRICE,

then; click on btn Single Undo which unlocks the screen ONCE,

and,

Bingo, Kazoom, Jumping Space Potatoes;

fld fff becomes visible.


That's not really a valid test because the engine will be idling between 
the handler executions. All lockscreens are cancelled at idle.


Locks are nested. If one handler calls another, they remain nested. As 
soon as the engine gets a chance to do its housekeeping, lockscreens are 
reset.


For example:

on mouseUp
 set the lockscreen to true
 commandOne
 put the lockscreen -- should be true
end mouseUp

on commandOne
 set the lockscreen to true
 get 1+1
 set the lockscreen to false
end commandOne

When these handlers are done, lockscreen will be false because the 
engine will reset it.


--
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: lock/unlock screen

2012-09-19 Thread Bob Sneidar
Right, because you are actually executing each command as a single script when 
in debug mode, hence idle gets sent right after. Idle unlocks the screen. Also, 
it seems you and Richmond are getting different results. Not sure what is going 
on there. 

Bob

On Sep 19, 2012, at 10:58 AM, Peter Haworth wrote:

 I also notice that if you are in debug mode, the lock screen has no effect,
 that is the screen is updated each time a change to it is made even when
 it's locked.
 
 Pete


___
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: lock/unlock screen

2012-09-19 Thread Bob Sneidar
That won't work Richmond, unless the first button sends a mouseup to the second 
button. Remember, an idle message will unlock the screen in any event, so as 
soon as the first button's script finishes, the screen will unlock. 

Bob


On Sep 19, 2012, at 10:52 AM, Richmond wrote:

 Richmond had a genius moment :)
 
 I made a wee stack called LOCKER with
 two buttons; Triple-Play and Single Undo and
 a fld fff containing the text UNLOCKED!
 
 the script of btn Triple-Play goes like this:
 
 on mouseUp
   set the vis of fld fff to false
set the lockscreen to true
set the lockscreen to true
set the lockscreen to true
 end mouseUp
 
 the script of btn Single Undo goes like this:
 
 on mouseUp
   set the lockscreen to false
   if the lockscreen is false then
 set the vis of fld fff to true
   end if
 end mouseUp
 
 HOT, SCREAMING STUFF!
 
 so; click on btn Triple-Play which locks the screen THRICE,
 
 then; click on btn Single Undo which unlocks the screen ONCE,
 
 and,
 
 Bingo, Kazoom, Jumping Space Potatoes;
 
 fld fff becomes visible.
 
 Richmond.
 
 ___
 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: lock/unlock screen

2012-09-19 Thread Bob Sneidar
Okay I modified Richmond's experiment to include a send mouseup to button 
Single Undo at the end of the first buttons script, and the field does indeed 
remain hidden, so yes a series of screen locks do stack. Pardon me for the 
false info.

Bob


On Sep 19, 2012, at 10:52 AM, Richmond wrote:

 Richmond had a genius moment :)
 
 I made a wee stack called LOCKER with
 two buttons; Triple-Play and Single Undo and
 a fld fff containing the text UNLOCKED!
 
 the script of btn Triple-Play goes like this:
 
 on mouseUp
   set the vis of fld fff to false
set the lockscreen to true
set the lockscreen to true
set the lockscreen to true
 end mouseUp
 
 the script of btn Single Undo goes like this:
 
 on mouseUp
   set the lockscreen to false
   if the lockscreen is false then
 set the vis of fld fff to true
   end if
 end mouseUp
 
 HOT, SCREAMING STUFF!
 
 so; click on btn Triple-Play which locks the screen THRICE,
 
 then; click on btn Single Undo which unlocks the screen ONCE,
 
 and,
 
 Bingo, Kazoom, Jumping Space Potatoes;
 
 fld fff becomes visible.
 
 Richmond.
 
 ___
 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: lock/unlock screen

2012-09-19 Thread Peter Haworth
Interesting Richmond, and different than what I'm seeing.  Maybe the
difference is that your locks are all in the same handler and mine
are scattered across different ones?
Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 10:52 AM, Richmond richmondmathew...@gmail.comwrote:

 Richmond had a genius moment :)

 I made a wee stack called LOCKER with
 two buttons; Triple-Play and Single Undo and
 a fld fff containing the text UNLOCKED!

 the script of btn Triple-Play goes like this:

 on mouseUp
set the vis of fld fff to false
 set the lockscreen to true
 set the lockscreen to true
 set the lockscreen to true
 end mouseUp

 the script of btn Single Undo goes like this:

 on mouseUp
set the lockscreen to false
if the lockscreen is false then
  set the vis of fld fff to true
end if
 end mouseUp

 HOT, SCREAMING STUFF!

 so; click on btn Triple-Play which locks the screen THRICE,

 then; click on btn Single Undo which unlocks the screen ONCE,

 and,

 Bingo, Kazoom, Jumping Space Potatoes;

 fld fff becomes visible.

 Richmond.


 __**_
 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-livecodehttp://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: lock/unlock screen

2012-09-19 Thread Peter Haworth
OK, I think this all hangs together now.  I guess the only thing to watch
out for might be an unlock screen with no associated lock screen since it
sounds like that would have the potential to unlock the screen too early.
 Not likely to happen though.

I was hoping this discussion might solve a problem I'm having where
updating a scrolling list field seems to be taking a lot longer than I
thought it would when I'm putting a lot of lines into the field (in the
region of a couple of thousand), but looks like the problem must lie
elsewhere in my code.

Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 11:07 AM, J. Landman Gay
jac...@hyperactivesw.comwrote:

 On 9/19/12 12:52 PM, Richmond wrote:

 Richmond had a genius moment :)

 I made a wee stack called LOCKER with
 two buttons; Triple-Play and Single Undo and
 a fld fff containing the text UNLOCKED!

 the script of btn Triple-Play goes like this:

 on mouseUp
 set the vis of fld fff to false
  set the lockscreen to true
  set the lockscreen to true
  set the lockscreen to true
 end mouseUp

 the script of btn Single Undo goes like this:

 on mouseUp
 set the lockscreen to false
 if the lockscreen is false then
   set the vis of fld fff to true
 end if
 end mouseUp

 HOT, SCREAMING STUFF!

 so; click on btn Triple-Play which locks the screen THRICE,

 then; click on btn Single Undo which unlocks the screen ONCE,

 and,

 Bingo, Kazoom, Jumping Space Potatoes;

 fld fff becomes visible.


 That's not really a valid test because the engine will be idling between
 the handler executions. All lockscreens are cancelled at idle.

 Locks are nested. If one handler calls another, they remain nested. As
 soon as the engine gets a chance to do its housekeeping, lockscreens are
 reset.

 For example:

 on mouseUp
  set the lockscreen to true
  commandOne
  put the lockscreen -- should be true
 end mouseUp

 on commandOne

  set the lockscreen to true
  get 1+1

  set the lockscreen to false
 end commandOne

 When these handlers are done, lockscreen will be false because the engine
 will reset it.

 --
 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-livecodehttp://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: lock/unlock screen

2012-09-19 Thread Alex Tweedly

No chance you can 'batch' the updates ?


put fld someField into temp
repeat with i = 1 to (many thousands)
   put someUpdate(i) after temp
end repeat
put temp into fld someField


will be *so* much faster ...

-- Alex.

On 19/09/2012 19:57, Peter Haworth wrote:

OK, I think this all hangs together now.  I guess the only thing to watch
out for might be an unlock screen with no associated lock screen since it
sounds like that would have the potential to unlock the screen too early.
  Not likely to happen though.

I was hoping this discussion might solve a problem I'm having where
updating a scrolling list field seems to be taking a lot longer than I
thought it would when I'm putting a lot of lines into the field (in the
region of a couple of thousand), but looks like the problem must lie
elsewhere in my code.

Pete
lcSQL Softwarehttp://www.lcsql.com



On Wed, Sep 19, 2012 at 11:07 AM, J. Landman Gay
jac...@hyperactivesw.comwrote:


On 9/19/12 12:52 PM, Richmond wrote:


Richmond had a genius moment :)

I made a wee stack called LOCKER with
two buttons; Triple-Play and Single Undo and
a fld fff containing the text UNLOCKED!

the script of btn Triple-Play goes like this:

on mouseUp
 set the vis of fld fff to false
  set the lockscreen to true
  set the lockscreen to true
  set the lockscreen to true
end mouseUp

the script of btn Single Undo goes like this:

on mouseUp
 set the lockscreen to false
 if the lockscreen is false then
   set the vis of fld fff to true
 end if
end mouseUp

HOT, SCREAMING STUFF!

so; click on btn Triple-Play which locks the screen THRICE,

then; click on btn Single Undo which unlocks the screen ONCE,

and,

Bingo, Kazoom, Jumping Space Potatoes;

fld fff becomes visible.


That's not really a valid test because the engine will be idling between
the handler executions. All lockscreens are cancelled at idle.

Locks are nested. If one handler calls another, they remain nested. As
soon as the engine gets a chance to do its housekeeping, lockscreens are
reset.

For example:

on mouseUp
  set the lockscreen to true
  commandOne
  put the lockscreen -- should be true
end mouseUp

on commandOne

  set the lockscreen to true
  get 1+1

  set the lockscreen to false
end commandOne

When these handlers are done, lockscreen will be false because the engine
will reset it.

--
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-livecodehttp://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: lock/unlock screen

2012-09-19 Thread Richmond

On 09/19/2012 09:16 PM, Bob Sneidar wrote:

Okay I modified Richmond's experiment to include a send mouseup to button Single 
Undo at the end of the first buttons script, and the field does indeed remain 
hidden, so yes a series of screen locks do stack. Pardon me for the false info.


Right, I stand corrected.



Bob


On Sep 19, 2012, at 10:52 AM, Richmond wrote:


Richmond had a genius moment :)

I made a wee stack called LOCKER with
two buttons; Triple-Play and Single Undo and
a fld fff containing the text UNLOCKED!

the script of btn Triple-Play goes like this:

on mouseUp
   set the vis of fld fff to false
set the lockscreen to true
set the lockscreen to true
set the lockscreen to true
end mouseUp

the script of btn Single Undo goes like this:

on mouseUp
   set the lockscreen to false
   if the lockscreen is false then
 set the vis of fld fff to true
   end if
end mouseUp

HOT, SCREAMING STUFF!

so; click on btn Triple-Play which locks the screen THRICE,

then; click on btn Single Undo which unlocks the screen ONCE,

and,

Bingo, Kazoom, Jumping Space Potatoes;

fld fff becomes visible.

Richmond.

___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Mark Wieder
Richard Gaskin ambassador@... writes:

 I'm not sure how PHPBB sends notifications for such things, but I 
 approved your account yesterday.

I realize you've got other things to deal with, but...

The specified username is currently inactive. If you have problems activating
your account, please contact a board administrator.

-- 
 Mark Wieder
 mwie...@ahsoftware.net


___
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: lock/unlock screen

2012-09-19 Thread Peter Haworth
Hi Alex,
I wish I could!  The problem is that I'm setting the textshift and
imagesource of a specific character in each line.  I tried putting
everything into a variable first but the textshift and imagesource
properties aren't available in variables.

I'm currently experimenting with putting html into a variable for all the
lines then setting the htmltext of the field to the variable.

Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 12:09 PM, Alex Tweedly a...@tweedly.net wrote:

 No chance you can 'batch' the updates ?

  put fld someField into temp
 repeat with i = 1 to (many thousands)
put someUpdate(i) after temp
 end repeat
 put temp into fld someField


 will be *so* much faster ...

 -- Alex.

 On 19/09/2012 19:57, Peter Haworth wrote:

 OK, I think this all hangs together now.  I guess the only thing to watch
 out for might be an unlock screen with no associated lock screen since it
 sounds like that would have the potential to unlock the screen too early.
   Not likely to happen though.

 I was hoping this discussion might solve a problem I'm having where
 updating a scrolling list field seems to be taking a lot longer than I
 thought it would when I'm putting a lot of lines into the field (in the
 region of a couple of thousand), but looks like the problem must lie
 elsewhere in my code.

 Pete
 lcSQL Softwarehttp://www.lcsql.com



 On Wed, Sep 19, 2012 at 11:07 AM, J. Landman Gay
 jac...@hyperactivesw.com**wrote:

  On 9/19/12 12:52 PM, Richmond wrote:

  Richmond had a genius moment :)

 I made a wee stack called LOCKER with
 two buttons; Triple-Play and Single Undo and
 a fld fff containing the text UNLOCKED!

 the script of btn Triple-Play goes like this:

 on mouseUp
  set the vis of fld fff to false
   set the lockscreen to true
   set the lockscreen to true
   set the lockscreen to true
 end mouseUp

 the script of btn Single Undo goes like this:

 on mouseUp
  set the lockscreen to false
  if the lockscreen is false then
set the vis of fld fff to true
  end if
 end mouseUp

 HOT, SCREAMING STUFF!

 so; click on btn Triple-Play which locks the screen THRICE,

 then; click on btn Single Undo which unlocks the screen ONCE,

 and,

 Bingo, Kazoom, Jumping Space Potatoes;

 fld fff becomes visible.

  That's not really a valid test because the engine will be idling
 between
 the handler executions. All lockscreens are cancelled at idle.

 Locks are nested. If one handler calls another, they remain nested. As
 soon as the engine gets a chance to do its housekeeping, lockscreens are
 reset.

 For example:

 on mouseUp
   set the lockscreen to true
   commandOne
   put the lockscreen -- should be true
 end mouseUp

 on commandOne

   set the lockscreen to true
   get 1+1

   set the lockscreen to false
 end commandOne

 When these handlers are done, lockscreen will be false because the engine
 will reset it.

 --
 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-livecodehttp://lists.runrev.com/**mailman/listinfo/use-livecode
 **http://lists.runrev.com/**mailman/listinfo/use-livecodehttp://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-livecodehttp://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-livecodehttp://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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Richard Gaskin

Thanks for the note.

Peter, Jacque, and Mark Wieder were in queue as Inactive - just fixed 
that.


--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 Follow me on Twitter:  http://twitter.com/FourthWorldSys

___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Peter Haworth
Thanks Richard, just saw the activation email.
Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 2:50 PM, Richard Gaskin
ambassa...@fourthworld.comwrote:

 Thanks for the note.

 Peter, Jacque, and Mark Wieder were in queue as Inactive - just fixed
 that.

 --
  Richard Gaskin
  Fourth World
  LiveCode training and consulting: http://www.fourthworld.com
  Webzine for LiveCode developers: http://www.LiveCodeJournal.com
  Follow me on Twitter:  
 http://twitter.com/**FourthWorldSyshttp://twitter.com/FourthWorldSys


 __**_
 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-livecodehttp://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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Mark Wieder
Pete-

Wednesday, September 19, 2012, 4:27:07 PM, you wrote:

 Thanks Richard, just saw the activation email.

Yep. Mine came through as well.

-- 
-Mark Wieder
 mwie...@ahsoftware.net


___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Mark Wieder
...and I suppose you realize that there's no link to the forum
anywhere on livecodejournal.com - you have to type it in. And worse,
you have to know it exists in order to find it and do that.

-- 
-Mark Wieder
 mwie...@ahsoftware.net


___
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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Peter Haworth
I noticed that, but I just bookmarked it.
Pete
lcSQL Software http://www.lcsql.com



On Wed, Sep 19, 2012 at 6:28 PM, Mark Wieder mwie...@ahsoftware.net wrote:

 ...and I suppose you realize that there's no link to the forum
 anywhere on livecodejournal.com - you have to type it in. And worse,
 you have to know it exists in order to find it and do that.

 --
 -Mark Wieder
  mwie...@ahsoftware.net


 ___
 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: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Richard Gaskin

Mark Wieder wrote:

 ...and I suppose you realize that there's no link to the forum
 anywhere on livecodejournal.com - you have to type it in. And
 worse, you have to know it exists in order to find it and do that.

That's a security feature. ;)

I just updated the Rev Interop page at lcj to reflect the URL to the new 
forum:

http://livecodejournal.com/revinterop/index.html

Thanks for the reminder.

--
 Richard Gaskin
 Fourth World Systems
 
 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: SQL question

2012-09-19 Thread Kay C Lan
During development a useful couple of lines of code are, assuming you've
been through your repeat for each col_name loop to create your query with
it's many OR conditions:

put tQuery into tTemp
replace comma with cr in tTemp
replace  OR  with cr   OR  in tTemp
--replace  AND  with cr   AND  in tTemp -- if appropriate
put tTemp into fld tempDisplay -- or MSG

What this does is takes your single very long line query:

SELECT 1Col,2Col,3Col,4Col,...,xCol FROM table WHERE (1Col LIKE '%or%' OR
2Col LIKE 'or%' OR 3Col LIKE '%or%' OR 4Col LIKE '%or%' OR ... LIKE '%or%'
OR xCol LIKE '%or%')

and makes it easier to debug the important bits:

SELECT 1Col
2Col
3Col
4Col
...
xCol FROM table WHERE (1Col LIKE '%or%'
 OR 2Col LIKE 'or%'
 OR 3Col LIKE '%or%'
 OR 4Col LIKE '%or%'
 OR ... LIKE '%or%'
 OR xCol LIKE '%or%')

All the column names should be all lined up so it makes tracking down
spelling or formatting errors so much easier.

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


Re: Need suggestions: very start of a stack revision system.

2012-09-19 Thread Mark Wieder
Richard-

Wednesday, September 19, 2012, 7:26:14 PM, you wrote:

 I just updated the Rev Interop page at lcj to reflect the URL to the new
 forum:
 http://livecodejournal.com/revinterop/index.html

please joing the RIP Yahoo Group ?

-- 
-Mark Wieder
 mwie...@ahsoftware.net


___
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