Re: Printing

2013-10-09 Thread Terence Heaford
Hi Mark, Thanks for confirming it. As I am not a commercial developer with LiveCode I suppose I cannot report the bug. I think you are so could you log it. Thanks Terry On 9 Oct 2013, at 00:09, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: Hi Terence, I did a test in Lion

Apostrophe and UPDATE

2013-10-09 Thread Paul Foraker
While building a LiveCode front end to a MySQL database, I ran into the apostrophe-in-the-data problem. My friend O'Byrne cannot get updated. For INSERTs, the variable substitution method works great -- I can post O'Byrne's name as a new record. But, what should I do about UPDATE ? Here's my

Re: Apostrophe and UPDATE

2013-10-09 Thread stephen barncard
http://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-in-mysql On Tue, Oct 8, 2013 at 11:37 PM, Paul Foraker p...@whitefeather.com wrote: While building a LiveCode front end to a MySQL database, I ran into the apostrophe-in-the-data problem. My friend O'Byrne cannot get updated.

Re: set cursor to busy

2013-10-09 Thread FlexibleLearning.com
Setting the cursor to busy eats cycles and adds a time-overhead. Personal preference is to simply 'set the cursor to watch' for any actity lasting up to a few seconds, or a progress bar updated every nth iteration (such as n mod 100 =0) for longer routines. For indeterminate activity length, I

Re: Apostrophe and UPDATE

2013-10-09 Thread Monte Goulding
On 09/10/2013, at 5:37 PM, Paul Foraker wrote: Any suggestions? Check your UPDATE syntax: http://www.w3schools.com/sql/sql_update.asp Cheers Monte -- M E R Goulding Software development services Bespoke application development for vertical markets mergExt - There's an external for that!

Re: Apostrophe and UPDATE

2013-10-09 Thread Paul Foraker
Stephen, escaping the single quote with another quote causes the same error, with the result showing \'\' instead of \'. I tried it with and without variable substitution. Monte, my UPDATE syntax was incorrect. Thanks! In case anyone else needs something like this, here's the code that worked:

Re: Apostrophe and UPDATE

2013-10-09 Thread stephen barncard
On Wed, Oct 9, 2013 at 12:55 AM, Paul Foraker paul.fora...@gmail.comwrote: Stephen, escaping the single quote with another quote causes the same error, with the result showing \'\' instead of \'. I tried it with and without variable substitution. thanks, Paul. This goes in my Script

Re: SQL (this AND that), OR (that AND theOther)

2013-10-09 Thread Alan Stenhouse
Roger Could you perhaps concatenate the user + car columns to make a new key and then do a select from that? e.g select * from ( select *, concat(user,car) as myKey from yourTable ) and use an appropriate where clause on that? Though it's not entirely clear what your requirement is. HTH

Re: set cursor to busy

2013-10-09 Thread William Humphrey
Can you explain what is different between setting cursor to busy instead of setting cursor to watch? Why does setting cursor to bust eat cycles? This is now a second reason not to use setting cursor to busy. The first being that it tells the user something is seriously wrong (I didn't know this

Re: Regular expressions

2013-10-09 Thread Thierry Douez
Hi Terry, I guess you may like to participate in this thread: http://forums.runrev.com/viewtopic.php?f=66t=17412 Regards, Thierry - 2013/7/2 Terry Vogelaar tvogel...@de-mare.nl stringToChange: bodyspanBlock of text/span/body

Re: set cursor to busy

2013-10-09 Thread Scott Rossi
I probably added to the confusion here, so I'll try to explain again. The *colored* beachball cursor (drawn by OS X) is the one that means an app is not responding. This is different than the black and white busy cursor that you can use in LiveCode, which can be used to indicate an application

Re: Hacking the GUI

2013-10-09 Thread Thomas McGrath III
Jim, Are you saying that you got smooth rotating of large images on iOS? Thanks Tom -- Tom McGrath III http://lazyriver.on-rev.com mcgra...@mac.com On Oct 9, 2013, at 1:45 AM, Jim sims s...@ezpzapps.com wrote: I just spent a few hours on an iOS app where i was using Grab to move a large,

Re: SQL (this AND that), OR (that AND theOther)

2013-10-09 Thread Peter Haworth
Whoops, that should be WHERE not SELECT... Pete lcSQL Software On Oct 9, 2013 12:12 AM, Peter Haworth p...@lcsql.com wrote: Roger, Not 100% sure what you need but maybe the following might help. SELECT user IN ('Joe','John','Jim') AND car IN ('Ford','Chevy',whatever) GROUP BY car || user

Re: Hacking the GUI

2013-10-09 Thread Jim sims
If by rotate you mean like 3D then no way ;-) I mean using grab to move a large photo around on an iPad. What had to be done was to disable/kill the scroller that lived in the same space. There is a scrolling group of about one hundred rows that have groups of: THUMBNAIL_MAGE - FIELD - FIELD

Re: set cursor to busy

2013-10-09 Thread william humphrey
Thanks Scott. that helps. On a Window's platform does set cursor to busy look like a spinning watch or is it still a MacOS 8 beach ball? On Wed, Oct 9, 2013 at 7:25 AM, Scott Rossi sc...@tactilemedia.com wrote: I probably added to the confusion here, so I'll try to explain again. The

Re: Passive Shell Commands

2013-10-09 Thread Dr. Hawkins
On Tue, Oct 8, 2013 at 7:57 PM, Monte Goulding mo...@sweattechnologies.comwrote: Ah, I assumed you didn't need to read from the process. If you don't need to read or know when it's done then: open process appPath srcPath trgPath for neither Can a livecode standalone be the slave process?

Re: Apostrophe and UPDATE

2013-10-09 Thread Dr. Hawkins
On Tue, Oct 8, 2013 at 11:37 PM, Paul Foraker p...@whitefeather.com wrote: '(last_name,notes) VALUES (O\'Byrne, betting this won\'t work!) WHERE id=599' at line 1 You're using the wrong escape. Inside a string, you need a double single quote, not a backslash. It's worth keeping a preSql()

Re: Apostrophe and UPDATE

2013-10-09 Thread Peter Haworth
Don't need to escape anything when using the :1,:2,etc notation, but if you did, it would be ''' not \'. The update syntax is UPDATE tablename SET colname=:1 etc Pete lcSQL Software On Oct 9, 2013 3:55 AM, Paul Foraker paul.fora...@gmail.com wrote: Stephen, escaping the single quote with

Re: [OT] web training video delivery - how do YOU do it?

2013-10-09 Thread Vaughn Clement
Hi Phil Your decision should be to build the training materials for IE, but make your client understand there will be reduced performance using IE and you have no way to adjust this performance. Actually there is a app named Hand Brake that will allow large video files to be optimized and reduced

Re: Hacking the GUI

2013-10-09 Thread Thomas McGrath III
Jim, No, I was referring to rotate around a 2d point on a flat plane not 3D. Rotating an image around a point on a 2D plane still causes anomalies on iOS in the rotated image and I was hoping it was fixed and you had done it smoothly. Tom -- Tom McGrath III http://lazyriver.on-rev.com

Re: Hacking the GUI

2013-10-09 Thread Earthednet-wp
Sheesh! I didn't know there was a grab command. I'll try it. I'm new to LC, so ... Thanks! Bill William Prothero http://es.earthednet.org On Oct 8, 2013, at 10:42 PM, Brahmanathaswami, Sannyasin bra...@hindu.org wrote: Why doesn't Grab me Work for u? On Oct 8, 2013, at 7:36 PM,

Re: [OT] web training video delivery - how do YOU do it?

2013-10-09 Thread Mark Wilcox
Hi Phil, I don't deliver web training but I do have some experience with getting videos to work across a lot of browsers. The only way of delivering videos to old browsers and maintaining your sanity is Flash. Even then, Adobe dropped support for IE6 last year, so the user has to have an old

6.1.2 rc 3

2013-10-09 Thread Richmond
Just spotted the thing: http://downloads.livecode.com/livecode/6_1_2/ Richmond. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

RELEASE: LiveCode 6.1.2 RC3

2013-10-09 Thread Benjamin Beaumont
Dear List Members, We are pleased to announce the test release of LiveCode 6.1.2 RC3. *Warning:* this is not a stable release. Please ensure you back up your stacks before testing them. If you do not wish to be notified of test releases, uncheck the appropriate boxes in the Updates section of

Re: set cursor to busy

2013-10-09 Thread J. Landman Gay
On 10/9/13 8:45 AM, william humphrey wrote: Thanks Scott. that helps. On a Window's platform does set cursor to busy look like a spinning watch or is it still a MacOS 8 beach ball? It's the Windows hourglass. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive

Re: Motion Comics tutorial for LiveCode

2013-10-09 Thread Fatih Batal
Completed: * page28-8 * page28-7 * page28-6 * page28-5 * page28-4 * page28-3 * page28-2 * page28-1 Download link: http://tinyurl.com/m2e9qvg Unfortunately, my deadlines are getting closer; so I don't know when -or sadly if- I can start to other pages :/

Tab Panel in OS X

2013-10-09 Thread Terence Heaford
Hi, I wonder if someone could help please. In OS X when you have a standard tab panel the tab text is black on light grey background when not selected. LiveCode follows this arrangement. In OS X when a tab is selected the background becomes a dark grey and the text becomes white. In

Google Map Loads Slow

2013-10-09 Thread Dan Friedman
Maybe someone can help... I am running this script in an iOS app: mobileControlCreate browser,theMapView put https://maps.google.com/?q=; urlEncode(tMapAddress) into tUrl put output=embed after tUrl mobileControlSet theMapView,rect,myRect mobileControlSet theMapView,url,tUrl It loads just fine

Re: set cursor to busy

2013-10-09 Thread FlexibleLearning.com
The 'busy' cursor is a BLACK AND WHITE spinning beachball and part of LiveCode so it is cross platform. It is hungry and eats cycles because it has to re-draw every time it changes. The COLORED spinning beachball on a Mac means the app is hanging (i.e. not a good thing). Do not use this cursor on

Re: set cursor to busy

2013-10-09 Thread william humphrey
Thanks Hugh I always wished that there was some LiveCode example stacks which showed proper design and procedure for different platforms. Like you said, a documentation so that people like me wouldn't be doing it wrong for years and years. And I use Parallels and run Windows lots of time so I

Re: [OT] web training video delivery - how do YOU do it?

2013-10-09 Thread Richard Gaskin
Phil Davis wrote: Problem is, they often use IE6/7/8 and are not open to change. Any sanctioned use of IE6 in any organization is a good argument for workplace drug testing, 'cause they're high as a kite if they think that's a good idea. As a government agency they're not only wasting our

Re: set cursor to busy

2013-10-09 Thread Richard Gaskin
william humphrey wrote: I always wished that there was some LiveCode example stacks which showed proper design and procedure for different platforms. FWIW, the Human Interface Guidelines for most popular platforms are linked to in the right-hand column on this page:

Re: [OT] web training video delivery - how do YOU do it?

2013-10-09 Thread Phil Davis
Thanks Vaughn. I've used HB in the past for personal needs and it's a great product. Currently we use FFMPEG for converting MOVs etc to web formats and it works well, plus we can run it invisibly from shell() in LC, so it gives the appearance that our app is doing the conversion. Thanks -

Re: [OT] web training video delivery - how do YOU do it?

2013-10-09 Thread Phil Davis
Yes, agreed. And in my zeal for finding a solution I overstated my case. IE8 is the earliest one my client claims to support. (Thankfully!) Phil On 10/9/13 12:47 PM, Richard Gaskin wrote: Phil Davis wrote: Problem is, they often use IE6/7/8 and are not open to change. Any sanctioned use

Re: RELEASE: LiveCode 6.1.2 RC3

2013-10-09 Thread Chris Sheffield
Is anybody else having issues with this build? It keeps self destructing for me. That's the only thing I can think of to describe it. I got it installed and opened a stack that I've been using recently. The first thing I noticed was that linked text does not work. I click a link and nothing

Re: Apostrophe and UPDATE

2013-10-09 Thread Paul Foraker
On Wed, Oct 9, 2013 at 1:32 AM, stephen barncard stephenrevoluti...@barncard.com wrote: Stephen, escaping the single quote with another quote causes the same error, with the result showing \'\' instead of \'. I tried it with and without variable substitution. thanks, Paul. This goes

Re: Passive Shell Commands

2013-10-09 Thread Ray Horsley
This has really worked out well for me. Thanks again Monte! Dr. Hawkins, I don't think there's any way to address a Livecode standalone with a command line prompt if that's what you were asking but I hope you find an answer to the lag issue you have. Cheers, Ray On 10/8/2013 6:00 PM,

Compatability Livecode projects on OSX and Windows

2013-10-09 Thread Beat Cornaz
Are there any issues with starting a Livecode project on OSX, then copy it to a Windows laptop , continue working on it and then going back to the OSX again. The Windows is only during the time that I am travelling and want to continue programming my project. At home I'll switch to my Mac again.

Re: Compatability Livecode projects on OSX and Windows

2013-10-09 Thread Scott Rossi
Fonts can sometimes be an issue, but Dropbox is your best friend for this kind of development -- one file, stored in one place, available to all machines. Regards, Scott Rossi Creative Director Tactile Media, UX/UI Design On 10/9/13 1:24 PM, Beat Cornaz b.cor...@gmx.net wrote: Are there any

Re: Google Map Loads Slow

2013-10-09 Thread Monte Goulding
On 10/10/2013, at 5:37 AM, Dan Friedman d...@clearvisiontech.com wrote: Anyone have any thoughts? Use mergMK? :-) Just being cheeky sorry. Cheers -- Monte Goulding M E R Goulding - software development services mergExt - There's an external for that!

Re: Passive Shell Commands

2013-10-09 Thread Monte Goulding
Can a livecode standalone be the slave process? Could it around to periodically check for stdin and answer to stdout? This could be perfect for handling my lag issues . . . Yes it can... read from STDIO... write to STDOUT Or just parse the command line args... $1... $n where n is $#

Re: Compatability Livecode projects on OSX and Windows

2013-10-09 Thread Richmond
On 10/09/2013 11:24 PM, Beat Cornaz wrote: Are there any issues with starting a Livecode project on OSX, then copy it to a Windows laptop , continue working on it and then going back to the OSX again. The Windows is only during the time that I am travelling and want to continue programming my

Re: Apostrophe and UPDATE

2013-10-09 Thread Paul Foraker
On Wed, Oct 9, 2013 at 7:02 AM, Dr. Hawkins doch...@gmail.com wrote: You're using the wrong escape. Inside a string, you need a double single quote, not a backslash. It's worth keeping a preSql() function around, like: function preSQL pSQL replace ' with '' in pSQL if pSQL is

Re: [OT] web training video delivery - how do YOU do it?

2013-10-09 Thread Vaughn Clement
Hi Richard My daughter is in the Air Force and she tells me that due to security concerns the military mandates many restrictions on military provided computers. That being said its stupid to mandate a Microsoft browser that has a long history of being Swiss cheese on security. But again if you

Re: Motion Comics tutorial for LiveCode

2013-10-09 Thread Alejandro Tejada
Hi Ender, Many Thanks for editing the complete page! I will upload all files to Google Drive's folder after converting them to 8 bit png files. Have a nice day! Al -- View this message in context:

MacPaint online

2013-10-09 Thread Mark Wieder
Have fun. http://boingboing.net/2013/10/09/macpaint-1984-online.html http://www.computerhistory.org/atchm/macpaint-and-quickdraw-source-code/ -- Mark Wieder mwie...@ahsoftware.net ___ use-livecode mailing list use-livecode@lists.runrev.com Please

Progress Bar

2013-10-09 Thread Mark Wieder
http://boingboing.net/2013/10/08/progressbar-a-short-film.html -- 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

Re: Passive Shell Commands

2013-10-09 Thread Dr. Hawkins
On Wed, Oct 9, 2013 at 1:51 PM, Monte Goulding mo...@sweattechnologies.comwrote: Yes it can... read from STDIO... write to STDOUT Or just parse the command line args... $1... $n where n is $# Thanks; I need to play with this. Command line arguments won't work; this would be passing SQL

LiveCode's Documentation Translation

2013-10-09 Thread Alejandro Tejada
Hi All, I am building a spanish translation dictionary for Livecode documents. For this purpose, these books are really useful: https://docs.google.com/file/d/0B9ja3Yvw8cHLRDFZTjZyZ2xVNmc/edit?usp=sharing The first and last book HyperCard e HyperTalk and SuperCard, Mas alla del HyperCard were