Re: specialfolderpath

Yes the docs should have Those listed. You can report it as a documentation bug in the QA centre Martin -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/specialfolderpath-tp4680584p4680588.html Sent from the Revolution - User mailing list archive at Nabble.com.

Re: specialfolderpath

That looks like a bug. I found that almost anything you type that is not one of the proper terms will return /Users//Library/Application Support Try specialfolderpath("Aardvark") or specialfolderpath("elvis is alive") You will get: /Users//Library/Application Support You want to report this

Re: specialfolderpath

Thanks,added it to my useful bookmarks. Seems like the dictionary should include all that info instead of the very short list that's in there right now. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: specialfolderpath

You can use 4 digit codes http://www.sonsothunder.com/devres/livecode/tips/file010.htm The application folder is apps specialfolderpath("apps") Martin -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/specialfolderpath-tp4680584p4680585.html Sent from the R

specialfolderpath

How do I get the location of the application folder using specialfolderpath? With LC 6.6.2 on a Mac, specialfolderpath("Applications") returns "/Users//Library/Application Support", not the path to the applications folder. Pete lcSQL Software Home of lcStackBrowser

Re: Image control in a Background

Hi Simon I found the following in the dictionary: iOS Note: iOS imposes strict controls over what you can and cannot access. Each application in iOS is stored in its own 'sandbox' folder (referred to as the home folder). An application is free to *read* and *write* files within this folder and it

Re: Nested Repeat loops

On 21/06/2014 15:22, Richard Gaskin wrote: At the RevLive conference in Vegas a few yeas back, Robert Cailliau's opening keynote covered some of the most adventurous feature requests I've ever heard anyone suggest for xTalks. Among them was the notion of named control structures, in part for

Re: Windows pathing question

Would adding the path of the exe to the environmental variables work? On Sat, Jun 21, 2014 at 1:12 AM, Bill Vlahos wrote: > I want to sent a command line command to a Windows executable to pass > information and a command to it so that the application dials the phone > number I send it (it is a

Re: SQL Join question

Just looking at this again, I don't think the primary key column is an issue if the goal is to put all tableB rows into tableA. You'll have to enumerate all the tableA and tableB columns omitting the primary key column for each one: INSERT INTO tableA (colA1,colA2,colA3.,colAn) SELECT colB1,C

Re: Nested Repeat loops

Thanks for all the suggestions. I like the idea of putting the whole nest of repeats in a separate handler as far as the current capabilities of the language, but I really like the idea in Richard's email to have the ability tp name each loop then exit out of a named loop. Is there a QCC report o

Re: SQL Join question

Forget my earlier post, thought you were wanting to select not insert. John's INSERT.. SELECT is the way to do it. Pete lcSQL Software On Jun 21, 2014 7:57 AM, "Mark Smith" wrote: > I have two tables A and B, both with the same structure (about 50 columns > each). I would like to combine the

Re: SQL Join question

SELECT * FROM TableA UNION SELECT * FROM TableB Both tables must have the same number of columns. You'll end up with separate Records from each table so if you need to differentiate between them and there isn't a column that does that, you could do something like SELECT 'A',* FROM tableA UNION SE

Re: SQL Join question

I really should have started with '0, field2' in the example below - assuming field 1 is the primary key.. If you have an auto incrementing primary key 'id' as the first field in both tables... INSERT INTO tableA SELECT 0, field1, field2, field3, etc... FROM tableB _

Re: SQL Join question

What database are you using? The following should work with MySL (and maybe others) If tableA was empty or both tables didn't have any overlapping primary key values, then this would work, but I'm assuming there's a primary key in there that would mess things up. INSERT INTO tableA SELECT *

SQL Join question

I have two tables A and B, both with the same structure (about 50 columns each). I would like to combine them into a single table (ie. rows from Table A followed by rows from Table B). Does anyone know of an SQL statement that will do that? Thanks -- View this message in context: http://runti

Re: Nested Repeat loops

Peter M. Brigham wrote: On Jun 21, 2014, at 2:33 AM, Richmond wrote: put 1 into XX repeat until XX>7 do something put 1 into ZZ repeat until ZZ>7 do something else put 1 into YY repeat until YY>7 ask "What colour are you socks?"

Re: Nested Repeat loops

On Jun 21, 2014, at 2:33 AM, Richmond wrote: > put 1 into XX > repeat until XX>7 > do something >put 1 into ZZ >repeat until ZZ>7 > do something else > put 1 into YY >repeat until YY>7 >ask "What colour are you socks?" >

Re: Nested Repeat loops

You could wrap the repeats in a try structure - stick the following script in a button... on mouseUp try repeat with i = 1 to 10 repeat with j = 1 to 10 repeat with k = 1 to 10 put i && j && k wait for 2 millisecs with messages