Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread Kay C Lan
On Mon, May 23, 2016 at 4:46 AM, Paul Dupuis wrote: > this app may use MySQL (or someday, possible other flavors of > SQL database) and I'd like to have a generalized routine that just > relies on LiveCode and "standard" SQL commands. > If you are using MySQL why not have a look at DUMP. This is n

Re: Positive Infinity forever

2016-05-22 Thread Mick Collins
(Try again, apologies for accidentally sending) ... typo When you said " 2^AJ=A(J+1)" I wonder if you meant "2^AJ >= A(J+1)" To many that may seem like nit-picking, but it is a NIT. However, if you MEANT what you wrote, then it is a YUGE NIT. It would mean that someone (Halmos?) found an e

Re: Positive Infinity forever

2016-05-22 Thread Mick Collins
Doc Hawk, I'm envious that you took a course from Halmos, but I question what is probably a typo. "Dr. Hawkins" wrote: Well, which infinity? aleph-naught (A0) is the count of the integers/wholes/natural A1=2^A0, the count of the reals. For that mater 2^AJ=A(J+1) A1-A0=A1 Aj^n=Aj A0 is als

Re: Suspense

2016-05-22 Thread et...@lish.net
Well.  In light of that I just doubled down. Takes a village! E et...@lish.net 240.876.1389 Sent from my pocket computer Please excuse my brevity and typos ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe,

Re: Suspense

2016-05-22 Thread Mark Smith
Heather Laine-2 wrote > Guys, I'm sitting here hitting refresh compulsively on the pledge page. > Are we there yet... We are so close to 40k. Who is going to push us over? Hahaha I know the feeling. But more seriously, you need $1,000 an hour for the next 19 hours to make the final goal. May the

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread et...@lish.net
Check out LiveCloud for LiveCodehttps://livecloud.io Addresses the cloning element but it's seems like a closed database architecture so you have to adopt their model I've played with it but yet to build anything production grade with it.  The team is extremely helpful and stays with you every ste

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread et...@lish.net
Check out LiveCloud for LiveCodehttps://livecloud.io Addresses the cloning element but it's seems like a closed database architecture so you have to adopt their model I've played with it but yet to build anything production grade with it.  The team is extremely helpful and stays with you every ste

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread Paul Dupuis
On 5/22/2016 11:19 AM, Mike Bonner wrote: > If you just need to duplicate the database, would making a copy of the file > be sufficient? > Yes. I should have been clearer. While I could just copy the file for a sqlite db, this app may use MySQL (or someday, possible other flavors of SQL database)

Re: And while I'm at it...

2016-05-22 Thread J. Landman Gay
On 5/22/2016 6:45 AM, Kay C Lan wrote: In your Mainstack, as part of it's stack script, can't you have, within a closeStack handler that already exists or just add one: if then number of lines of openstacks() = 2 then show stack "Mainstack" When I had to deal with a similar issue, I put a cust

Re: Storing and retrieving data from a SQL database

2016-05-22 Thread Peter Haworth
Glad you figured it out Paul. I'll check out the SQLiteAdmin problem. On Sun, May 22, 2016 at 7:48 AM Paul Dupuis wrote: > On 5/20/2016 10:38 PM, Peter Haworth wrote: > > Tabs shouldn't be a problem so I suspect something else. > > > > Have you tried using LC to select the data after updating i

Re: Avoiding a stupid mistake

2016-05-22 Thread RM
Ha, Ha, Ha: I'm sure that everybody is dumb enough to do that at least once. I know that I, being extra skilled, have done it (deleting things accidentally) . . . at least . . . oh, dear, I seem to have run out of fingers and toes. Deleting anything may lead to regrets later: hence I have a

Avoiding a stupid mistake

2016-05-22 Thread Graham Samuel
Just for general interest - I wanted to delete the Preferences folder for an app I’m working on, so I scripted a button as follows: get specialFolderPath("preferences") revdeletefolder it What I’d forgotten was that on the Mac version, my preferences were not in a folder dedicated to my

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread Mike Bonner
If you just need to duplicate the database, would making a copy of the file be sufficient? On Sun, May 22, 2016 at 9:15 AM, Paul Dupuis wrote: > Does any one have a good script they might care to share for cloning a > SQLite database? > > the basic model is to use revDatabaseTableNames(databaseI

Cloning a SQLite (or any SQL) database

2016-05-22 Thread Paul Dupuis
Does any one have a good script they might care to share for cloning a SQLite database? the basic model is to use revDatabaseTableNames(databaseID) to get the list of tables in the source database and then loop through getting each tables schema and data and recreate that in the target database.

Re: Storing and retrieving data from a SQL database

2016-05-22 Thread Paul Dupuis
On 5/20/2016 10:38 PM, Peter Haworth wrote: > Tabs shouldn't be a problem so I suspect something else. > > Have you tried using LC to select the data after updating it? As mentioned > in an earlier post, if you use revDataFromQuery to do the SELECT, be sure > to use something other than tab/return

HTML5 standalone from Livecode 8.0.1

2016-05-22 Thread RM
Just a "little something" for Sunday afternoon: http://forums.livecode.com/viewtopic.php?f=120&t=27345 Richmond. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription

Re: Problems with Xcode

2016-05-22 Thread panagiotis merakos
Hi Martin, Try this in the terminal: 1. Type: sudo xcode-select -switch /Applications/Xcode.app/Contents/Developer 2. Press enter. You will be asked for your password. Type your password and press enter. 3. Type xcode-select -p 4. Press Enter. This should output: /Applications/Xcode.app/Conten

Re: And while I'm at it...

2016-05-22 Thread Kay C Lan
UUrggh, typo: if THE number of lines of openstacks() = 2 then show stack "Mainstack" Why is it that I can only spell AFTER I've pressed the Send button!! ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, un

Re: And while I'm at it...

2016-05-22 Thread Kay C Lan
In your Mainstack, as part of it's stack script, can't you have, within a closeStack handler that already exists or just add one: if then number of lines of openstacks() = 2 then show stack "Mainstack" 2 assumes that you aren't using any other stacks as toolbars or some such and this is in a stan

Problems with Xcode

2016-05-22 Thread martin meili
Hi Marc Yes, I have removed this space. No effect on the result. The correct path should be: /Applications/Xcode.app/Contents/Developer. The „Xcode 2.app“ doesn’t exist anymore on my computer; it was about version 4.2. LiveCode is leading me to the anymore-existent Xcode version; the question is