Using Facebook for something sensible.

I have about 20 kids (10 - 13 years old) doing something with Livecode this summer. Between classes We are using Facebook for help, corrections and so on. This is a good use for Facebook. Richmond. ___ use-livecode mailing list use-livecode@lists.ru

Re: SQL Join question

Thanks Peter. Good discussion. I'll check on the developer list to see if anyone knows if there is an iPad device ID I can grab. Perhaps another widget for Monte to work on :) -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/SQL-Join-question-tp4680574p4680600.htm

Re: SQL Join question

Austin! Time for BBQ. How long are you there? thanks, Glen > On Jun 21, 2014, at 10: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 them into a single table (ie. rows from Table > A followed by rows from T

Re: SQL Join question

Unfortunately, autoincrementing can only be done on primary keys and there can only be one primary key per table. However, it just occurred to me that if you go back to an autoincrementing primary key you could create the concatenated key in your SELECT with: SELECT Device || pKey AS UniqueKey,..

Re: SQL Join question

Perfect, thank you. Peter Haworth wrote > but if there are three tables, the SELECT becomes: > > SELECT tableA.*, tableB.*, tableC.* FROM tableA JOIN tableB ON > tableB. > > =tableA. > > JOIN tableC ON > tableC. > > =tableA. > > But the keycolumn must have the same value for all three table

Re: SQL Join question

Hi Peter, thanks for that. I definitely prefer your option 1. Would it still be possible to have an auto incrementing field that combines with the device id to make the primary key (ie. could recno in your example be auto incrementing)? Also, I wonder if there is a device ID that could be grabbed f

Re: SQL Join question

On Sun, Jun 22, 2014 at 6:55 AM, Mark Smith wrote: > I never did > resolve how to make the primary keys unique across devices > Assuming you are using SQLite, there are a couple of ways to achieve this, one riskier than the other. The less risky approach is to give up on using an autoincrementi

Re: SQL Join question

Hi Mark, Yes, you would end up with one row containing all the columns from all three tables, but if there are three tables, the SELECT becomes: SELECT tableA.*, tableB.*, tableC.* FROM tableA JOIN tableB ON tableB.=tableA. JOIN tableC ON tableC.=tableA. But the keycolumn must have the same value

Re: specialfolderpath

Will report both these. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sat, Jun 21, 2014 at 6:43 PM, Martin Koob wrote: > Yes the docs should have Those listed. You can rep

Re: Windows pathing question

Probably but the problem is that I didn’t install the application so my dialing plugin doesn’t know where the application is. Bill On Jun 21, 2014, at 11:08 AM, Simon Smith wrote: > Would adding the path of the exe to the environmental variables work? > > > On Sat, Jun 21, 2014 at 1:12 AM, B

Re: SQL Join question

Peter Haworth wrote > SELECT tableA.*,tableB.* FROM tableA JOIN tableB ON > tableB.keycolumn=tableA.keycolumn Hi Peter. So, do I understand correctly that if table A has fields first, last and table B has fields age, sex and they both have an id column (key column) then this code would produce a f

Re: SQL Join question

John Craig-4 wrote > 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 table

Re: specialfolderpath

Hi, A more complete list for Mac OS X and Windows is in my book. Note that you can also use absolute paths like /Applications "/Application Support" and relative paths like ~/Applications "~/Application Support" This may make it easier to get to the right folder. -- Best regards, Mark Scho