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

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

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

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

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

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

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

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

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

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:

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

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

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

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

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:

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

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

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

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

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

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:

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,

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:

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

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

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

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

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

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

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:

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:

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

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

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

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

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

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:

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

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

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

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,

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

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

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