Re: Handling Long ID in Params?

[Scott Rossi]

Recently, Mark Wieder wrote:

>> I'm sure you have good reasons but I'm curious about why you would want to
>> classify a handler as private if you know you will need to access it from
>> outside the script that it's in?
> 
> Thanks. You beat me to it. This has been bothering me all day. Knowing
> Scott, I'm sure there's a good reason, but I can't imagine what it
> could be. Now I'm watching my inbox waiting for the mystery to
> unravel.

A good point.  In the big scheme of things, all the hoop jumping is probably
too much work.  But FWIW, I have a bunch of handlers in a front script that
are private to prevent any unwanted triggering -- the end use is a set of
tools for LiveCode developers in the LC IDE.  There are some occasions,
however, where I need to trigger some of the handlers from different points
in the tools that aren't part of the frontscript, so I'm trying to work
around that.  I was thinking I could use
reallyLongHandlerNamesThatNoOneWouldEverUse, but then I thought it might be
more useful to make one generic command to handle any need.

Like I explained, it might not be the best way to arrange things.

Sorry this been bothering you all day.  :-)

Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Handling Long ID in Params?

[Mark Wieder]

Pete-

Monday, October 17, 2011, 2:01:13 PM, you wrote:

> Hi Scott,
> I'm sure you have good reasons but I'm curious about why you would want to
> classify a handler as private if you know you will need to access it from
> outside the script that it's in?

Thanks. You beat me to it. This has been bothering me all day. Knowing
Scott, I'm sure there's a good reason, but I can't imagine what it
could be. Now I'm watching my inbox waiting for the mystery to
unravel.

-- 
-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 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Handling Long ID in Params?

[Scott Rossi]

Wow, just got bitten by this long id reference again -- twice in 24 hours!

I've been trying to call a function of another object using the old routine:

  get value("specialFunction()",remoteObject)

And once again, this handler was failing for me when passing the long id of
a control within the function.  I kept getting "source is not a container"
errors (which doesn't help, because of course the long id of a control is
valid), so on a whim I tried placing "long id of " before the object
reference and it worked.

 put "long id of" && long id of btn 1 into theObj
 get value("specialFunction(" & theObj & ")", theSource)

Thanks yet again Ken, my forehead is a bit less bloody now, and the wall has
been spared a few more blows.

Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design




Recently, Ken Ray wrote:

> Scott, when you execute the "do", it's getting the text of the button and
> passing that along instead of the long id that's coming into
> "routeTheCommand". To make it not evaluate it, call:
> 
> routeTheCommand "getTheSum","the long id of btn 1"  -- put quotes around the
> second param
> 
> The other way you could do it would be to insert "the long id of " before
> theArgs if you knew it was an object reference that was coming in:



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[Joe Lewis Wilkins]

Alex,

I'm sure you'll eventually take advantage of all that LC comes to offer, and 
they love you for your outside the box thinking and doing; but you're far more 
imaginative than the average "potential" LC user.

Frankly, I'd love to be in your boots. (smile)

Joe Wilkins

On Oct 17, 2011, at 4:25 PM, Alejandro Tejada wrote:

> Hi Joe,
> 
> 
> Joe Lewis Wilkins wrote:
>> 
>> When I first got involved with Revolution I had hoped
>> that it would just be an up-todate HC; but, alas, it
>> began to get too complicated for the average hobbyist,
>> so many of the HC users just never came aboard.
>> I don't blame them. I was very close to being one
>> who didn't myself. Over the years I have done some
>> pretty remarkable things with HC. I really neither needed
>> nor wanted the extensions that eventually became LiveCode.
>> I believe that a totally bug-free Revolution 1.x could have
>> become a major hit with all of the educators, and wouldn't
>> have had to be so costly. Do I hear a few Amens? 
>> 
> 
> Strangely enough, I still believe that it is possible to create
> amazing interactive stacks in this platform, with a clever use
> of the commands show, hide, visual effects and go to card.
> After all, we could use only what we need.
> 
> There are many great features of this platform that I never
> have explored, but it's good to know that they are available,
> if I ever need them. Hopefully, a new text field control and
> a zoom property for groups will appear in a near future.
> 
> Al

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: SqLite to MySQL and back or ?

[Robert Brenstein]

On 17.10.2011 at 12:47 Uhr -0700 John Patten apparently wrote:

Hi All!

I have a little project that is using SQLite to save user data. 
Essentially, each user has their own table created in the database 
and it saves records consisting of text content in mutiple fields in 
each record. The idea was in a school situation, where multiple 
students using the same computer, I could have different users use 
the same app and have access to just their data.  This seems to work 
quite well, and it doesn't require a constant network connection.




this might work better if you have only 2 tables instead of having a 
separate table for each user: one table with a list of users and 
another linked to it 1:N with actual records with user data. No fuss 
with creating and deleting tables.


I was thinking I could query the local database (sqlite) save it, 
then do the same on the mysql database in the cloud (on-rev). 
However it would seem to be pretty complex; query the mysql db for 
the existence of the user table, if not present, create the table 
and import all the data into a duplicate database on mysql or if it 
is present, update those records with matching ids and create new 
records for those records that were not a match.


If you consider using mysql as means of transfer, why not use it to 
actually store all data and keep it simple. No fuss with exports, 
imports, syncing, etc.


r

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[Alejandro Tejada]

Hi Joe,


Joe Lewis Wilkins wrote:
> 
> When I first got involved with Revolution I had hoped
> that it would just be an up-todate HC; but, alas, it
> began to get too complicated for the average hobbyist,
> so many of the HC users just never came aboard.
> I don't blame them. I was very close to being one
> who didn't myself. Over the years I have done some
> pretty remarkable things with HC. I really neither needed
> nor wanted the extensions that eventually became LiveCode.
> I believe that a totally bug-free Revolution 1.x could have
> become a major hit with all of the educators, and wouldn't
> have had to be so costly. Do I hear a few Amens? 
> 

Strangely enough, I still believe that it is possible to create
amazing interactive stacks in this platform, with a clever use
of the commands show, hide, visual effects and go to card.
After all, we could use only what we need.

There are many great features of this platform that I never
have explored, but it's good to know that they are available,
if I ever need them. Hopefully, a new text field control and
a zoom property for groups will appear in a near future.

Al




--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/New-rendering-testing-tp3910362p3913738.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[Joe Lewis Wilkins]

Alex:

When I first got involved with Revolution I had hoped that it would just be an 
up-todate HC; but, alas, it began to get too complicated for the average 
hobbyist, so many of the HC users just never came aboard. I don't blame them. I 
was very close to being one who didn't myself. Over the years I have done some 
pretty remarkable things with HC. I really neither needed nor wanted the 
extensions that eventually became LiveCode. I believe that a totally bug-free 
Revolution 1.x could have become a major hit with all of the educators, and 
wouldn't have had to be so costly. Do I hear a few Amens? 

Joe Wilkins

On Oct 17, 2011, at 3:27 PM, Alejandro Tejada wrote:

> Hi Joe and Jim,
> 
> Joe, many thanks for your kind words!
> I always hope that my scripting experiments
> would do more good than harm and at least
> should be useful to show the Do's and Don'ts
> on the specific topics that I worked with.
> 
> 
> James Hurley wrote:
>> 
>> [snip]
>> Kevin and I discussed the possibility of implementing it as part of Run
>> Rev.
>> They were more interesting in education at the time.
>> 
> 
> Yes, I hope to see more Livecode and LOGO teaching
> in the future. In LOGO, the teacher is fundamental to
> produce extraordinary results. 
> The greatest teaching ideas are widely celebrated and
> quickly forgotten... almost like a ritual.
> In my eyes, the longer I look into the Education field 
> this become more and more paradoxical. Almost like a
> Lewis Carroll tale, with the complete cast of characters.
> 
> I am sure that Livecode is a resounding sucess when used
> to teach Introduction to Computer Programming.
> At least for me, this computer language provided the
> confidence to try many ideas that I would not even dare to. 
> Yes, this computer language inspire confidence.
> Does every computer language instill this 
> in their users/developers?
> 
> Why Livecode teaching is not more extended, as expected, 
> in the English speaking world? My best guess is that
> everyone that look at Livecode, believe that it's a
> neat idea... and their next question is:
> Is this endorsed, recommended and approved by the
> powers that be in education???
> This is exactly the moment where you understand
> that more and more people in the education field 
> are not, and do not pretend to be leaders, but followers...
> 
> Sad, but true...
> 
> 
> James Hurley wrote:
>> 
>> I'm not sure where that file you found came from, but it is not very
>> readable.
>> I have a clean version I will send you separately. Do not share it with
>> others
>> at this time. I have retitled (and did some rewriting of)  the Logo
>> Physics book
>> to "Programming for Science Students." I think that is the appropriate
>> market
>> --if one exists at all.
>> 
> 
> Received. Many Thanks! :-)
> 
> 
> James Hurley wrote:
>> 
>> [snip]
>> Unfortunately I am out of touch with this market now and so have
>> nothing for you about current applications, if any. Trouble is perception.
>> It is perceived as a tool for children, a perception quickly dispelled in
>> Turtle Geometry by Abelson and diSessa. The last chapter is titled:
>> Curved Geometry and General Relativity. 
>> 
> 
> Interesting enough, in this page:
> http://mitpress.mit.edu/catalog/item/default.asp?ttype=2&tid=7287
> there is a surprising error:
> Hal Abelson is Class of 1922 Professor of Computer Science and
> Engineering at Massachusetts Institute of Technology
> 
> Class of 1922!!! Extraordinary, to say the least. :-)
> 
> By the way, your stack:
> http://jamesphurley.com/jhurleyFolder/NineBallWithSpin.rev
> is the only game that I play with some frecuency.
> 
> Thanks again, Jim

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Another drag/drop issue

[Pete]

I'm trying to drag and drop a column from a datagrid onto another datagrid
on the same card.  Everything works fine when I'm testing (the stack is
toplevel), but when I use it for real (the stack is modal), none of the
dragxxx handlers are being called.

I'm really hoping the reason is that LC doesn't handle drag/drop operations
in a modal window..


Pete
Molly's Revenge 
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[Alejandro Tejada]

Hi Joe and Jim,

Joe, many thanks for your kind words!
I always hope that my scripting experiments
would do more good than harm and at least
should be useful to show the Do's and Don'ts
on the specific topics that I worked with.


James Hurley wrote:
> 
> [snip]
> Kevin and I discussed the possibility of implementing it as part of Run
> Rev.
> They were more interesting in education at the time.
> 

Yes, I hope to see more Livecode and LOGO teaching
in the future. In LOGO, the teacher is fundamental to
produce extraordinary results. 
The greatest teaching ideas are widely celebrated and
quickly forgotten... almost like a ritual.
In my eyes, the longer I look into the Education field 
this become more and more paradoxical. Almost like a
Lewis Carroll tale, with the complete cast of characters.

I am sure that Livecode is a resounding sucess when used
to teach Introduction to Computer Programming.
At least for me, this computer language provided the
confidence to try many ideas that I would not even dare to. 
Yes, this computer language inspire confidence.
Does every computer language instill this 
in their users/developers?

Why Livecode teaching is not more extended, as expected, 
in the English speaking world? My best guess is that
everyone that look at Livecode, believe that it's a
neat idea... and their next question is:
Is this endorsed, recommended and approved by the
powers that be in education???
This is exactly the moment where you understand
that more and more people in the education field 
are not, and do not pretend to be leaders, but followers...

Sad, but true...


James Hurley wrote:
> 
> I'm not sure where that file you found came from, but it is not very
> readable.
> I have a clean version I will send you separately. Do not share it with
> others
> at this time. I have retitled (and did some rewriting of)  the Logo
> Physics book
> to "Programming for Science Students." I think that is the appropriate
> market
> --if one exists at all.
> 

Received. Many Thanks! :-)


James Hurley wrote:
> 
> [snip]
> Unfortunately I am out of touch with this market now and so have
> nothing for you about current applications, if any. Trouble is perception.
> It is perceived as a tool for children, a perception quickly dispelled in
> Turtle Geometry by Abelson and diSessa. The last chapter is titled:
> Curved Geometry and General Relativity. 
> 

Interesting enough, in this page:
http://mitpress.mit.edu/catalog/item/default.asp?ttype=2&tid=7287
there is a surprising error:
Hal Abelson is Class of 1922 Professor of Computer Science and
Engineering at Massachusetts Institute of Technology

Class of 1922!!! Extraordinary, to say the least. :-)

By the way, your stack:
http://jamesphurley.com/jhurleyFolder/NineBallWithSpin.rev
is the only game that I play with some frecuency.

Thanks again, Jim

--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/New-rendering-testing-tp3910362p3913611.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Handling Long ID in Params?

[Pete]

Hi Scott,
I'm sure you have good reasons but I'm curious about why you would want to
classify a handler as private if you know you will need to access it from
outside the script that it's in?
Pete
Molly's Revenge 




On Mon, Oct 17, 2011 at 10:30 AM, Scott Rossi wrote:

> Thanks Ken, you got me on the right path.  I lost so many hours on this
> dumb
> thing, but I think it's a valid concept worth using.
>
> Again, the idea is to be able to execute any private command of a script
> using a single "router" command, with any number of parameters.  The
> caveat,
> as Ken pointed out, is that long object ids need to include "long id of"
> when used as parameters.  The code is simplified below:
>
> command runPrivateCommand pCommand
>   put item 2 to -1 of (word 2 to -1 of the params) into commandParams
>   repeat for each item theString in commandParams
> -- strip outer quotes of params
> put char 2 to -2 of theString & comma after theArgs
>   end repeat
>   delete last char of theArgs -- strip trailing comma
>   do pCommand && theArgs
> end runPrivateCommand
>
> So, as a simple example, if a script has a private command:
>
> private command getObjectID pObj
>   answer the id of pObj
> end getObjectID
>
> ...this command can be triggered by any external object via the above
> router
> command (in the same script) with something like this:
>
> runPrivateCommand "getObjectID","long id of" && long id of btn 1
>
>
>
> Thanks again Ken.
>
> Regards,
>
> Scott Rossi
> Creative Director
> Tactile Media, UX Design
>
>
>
>
> Recently, Ken Ray wrote:
>
> > On Oct 17, 2011, at 4:11 AM, Scott Rossi wrote:
> >>
> >> Maybe this isn't the best method to accomplish what I need, but can
> anyone
> >> see why this is failing?
> >
> > Scott, when you execute the "do", it's getting the text of the button and
> > passing that along instead of the long id that's coming into
> > "routeTheCommand". To make it not evaluate it, call:
> >
> > routeTheCommand "getTheSum","the long id of btn 1"  -- put quotes around
> the
> > second param
> >
> > The other way you could do it would be to insert "the long id of " before
> > theArgs if you knew it was an object reference that was coming in:
> >
> > command routeTheCommand
> >   put word 2 to -1 of the params into commandData
> >   put stripOuterQuotes(item 1 of commandData) into theCommand
> >   put stripOuterQuotes(item 2 to -1 of commandData) into theArgs
> >   put "the long id of " before theArgs
> >   do theCommand && theArgs
> > end routeTheCommand
> >
> > Funky, but it worksŠ
> >
> > :D
> >
> > Ken Ray
> > Sons of Thunder Software, Inc.
> > Email: k...@sonsothunder.com
> > Web Site: http://www.sonsothunder.com/
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription
> > preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: SqLite to MySQL and back or ?

[Pete]

Sounds like what you want to is sync the databases accounting for any
inserts, deletes, updates on either database.  That gets pretty complicated!
 I think I'd probably take the route of accessing the remote mySQL db all
the time if it's at all feasible and i not, then using ftp to
upload/download the database would be my next choice, but only if you are
150% sure that each student only ever accesses their own table.

If that's not feasible, then one method I've seen (but not implemented) is
to use triggers to store a log table of all activity to a table.  The log
table would contain the same columns as the original plus a timestamp and an
indication of the activity (insert, delete, update).  The sync process
consists of getting the log table rows sorted by timestamp then taking the
appropriate action on the "other database".  If delete, then delete the row
from the other db table, if insert, insert it, if update, update it.  There
is a REPLACE command that I think inserts a row if it doesn't already exist,
or deletes the old row and inserts the new one if it does already exist, but
I haven't tried using it.

You'd have to be sure that the primary key of the table entries in both dbs
were the same for this or any other syncing scheme to work.



Pete
Molly's Revenge 




On Mon, Oct 17, 2011 at 12:47 PM, John Patten  wrote:

> Hi All!
>
> I have a little project that is using SQLite to save user data.
> Essentially, each user has their own table created in the database and it
> saves records consisting of text content in mutiple fields in each record.
> The idea was in a school situation, where multiple students using the same
> computer, I could have different users use the same app and have access to
> just their data.  This seems to work quite well, and it doesn’t require a
> constant network connection.
>
> Now I want to allow the student to download the app when they get home and
> be able to access and update their (data) table and records on a copy of the
> app at home.
>
> I was thinking I could query the local database (sqlite) save it, then do
> the same on the mysql database in the cloud (on-rev). However it would seem
> to be pretty complex; query the mysql db for the existence of the user
> table, if not present, create the table and import all the data into a
> duplicate database on mysql or if it is present, update those records with
> matching ids and create new records for those records that were not a match.
> The student would then have to do that same process when they got back to
> school for any new info they saved. Seems like a lot a work ;-)
>
> Am I on the right track, or is their an easier way? I.e. What about...  FTP
> process that uploads the sqllite data base from user’s local machine to a
> server available on net, and then from home ftp download process that saves
> SQLite database to student’s home machine. This almost sound easier to me
> than writing a bunch of sql  and irev files to do all the sql query stuff.
>
> What do you think?  Interested in what others have done.
>
> It would be nice if there were a sql query that just essentially did a:
> on mouseUp
>  put sqlite table1 of database "MainData" into tTable1
> copy tTable1 to (new or update)  table on remote mysql database "Maindata""
> ;-)
> end mouseUp
>
>
> Thank you!
>
> John Patten
> SUSD
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: SqLite to MySQL and back or ?

[Kee Nethery]

It's my belief that SqLite databases tend to be small enough that you can just 
copy the entire file back to a main server and not bother doing a sync of the 
data it contains. Probably be heck-a faster than a whole bunch of selects and 
updates and inserts from sqLite on a desktop to MySQL on a server.

Just a thought, could be totally wrong.

Kee Nethery
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: SqLite to MySQL and back or ?

[Bob Sneidar]

Typically what most do is issue a dump of the sql database. If it is not too 
large then this is workable. It produces a text file that can then be imported 
into other databases. 

But why not have your app access the mySQL database online to begin with? You 
would need to modify the table structures so that a student could only see the 
records for his own login, or else create separate tables with the students 
user name (limited to 8 characters or something) appended to the tables names. 
Something like grades_bobs. 

I get how you want to have the students work offline then sync later, but this 
would involve queries to delete everything for that student from the tables 
before importing the text file. And if for some reason the import fails you 
will be pulling your hair out. 

I have an interface that opens a primary and secondary database and "syncs" 
between the two, but it is unpolished. I DO have merging working, but I have 
not tested it thoroughly as of yet. It has a Database Setup card where you 
input the hostname (or filename for sqLite) a user and password, and the save 
it. You then click the connect button for each database. Once connected there 
is an interface for linking tables, and then columns. These are all saved in 
card properties. The Merge feature reads this data and only merges data that is 
not different between each record. 

It's all moot though if the students are in a location without access to the 
mySQL database right? How are you going to get the dump OR the outside 
connection to do what you have to do?

Bob


On Oct 17, 2011, at 12:47 PM, John Patten wrote:

> Hi All!
> 
> I have a little project that is using SQLite to save user data. Essentially, 
> each user has their own table created in the database and it saves records 
> consisting of text content in mutiple fields in each record. The idea was in 
> a school situation, where multiple students using the same computer, I could 
> have different users use the same app and have access to just their data.  
> This seems to work quite well, and it doesn’t require a constant network 
> connection.
> 
> Now I want to allow the student to download the app when they get home and be 
> able to access and update their (data) table and records on a copy of the app 
> at home. 
> 
> I was thinking I could query the local database (sqlite) save it, then do the 
> same on the mysql database in the cloud (on-rev). However it would seem to be 
> pretty complex; query the mysql db for the existence of the user table, if 
> not present, create the table and import all the data into a duplicate 
> database on mysql or if it is present, update those records with matching ids 
> and create new records for those records that were not a match. The student 
> would then have to do that same process when they got back to school for any 
> new info they saved. Seems like a lot a work ;-)
> 
> Am I on the right track, or is their an easier way? I.e. What about...  FTP 
> process that uploads the sqllite data base from user’s local machine to a 
> server available on net, and then from home ftp download process that saves 
> SQLite database to student’s home machine. This almost sound easier to me 
> than writing a bunch of sql  and irev files to do all the sql query stuff.
> 
> What do you think?  Interested in what others have done. 
> 
> It would be nice if there were a sql query that just essentially did a:  
> on mouseUp
> put sqlite table1 of database "MainData" into tTable1  
> copy tTable1 to (new or update)  table on remote mysql database "Maindata"" 
> ;-)
> end mouseUp
> 
> 
> Thank you!
> 
> John Patten
> SUSD
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

SqLite to MySQL and back or ?

[John Patten]

Hi All!

I have a little project that is using SQLite to save user data. Essentially, 
each user has their own table created in the database and it saves records 
consisting of text content in mutiple fields in each record. The idea was in a 
school situation, where multiple students using the same computer, I could have 
different users use the same app and have access to just their data.  This 
seems to work quite well, and it doesn’t require a constant network connection.

Now I want to allow the student to download the app when they get home and be 
able to access and update their (data) table and records on a copy of the app 
at home. 

I was thinking I could query the local database (sqlite) save it, then do the 
same on the mysql database in the cloud (on-rev). However it would seem to be 
pretty complex; query the mysql db for the existence of the user table, if not 
present, create the table and import all the data into a duplicate database on 
mysql or if it is present, update those records with matching ids and create 
new records for those records that were not a match. The student would then 
have to do that same process when they got back to school for any new info they 
saved. Seems like a lot a work ;-)

Am I on the right track, or is their an easier way? I.e. What about...  FTP 
process that uploads the sqllite data base from user’s local machine to a 
server available on net, and then from home ftp download process that saves 
SQLite database to student’s home machine. This almost sound easier to me than 
writing a bunch of sql  and irev files to do all the sql query stuff.

What do you think?  Interested in what others have done. 

It would be nice if there were a sql query that just essentially did a:  
on mouseUp
 put sqlite table1 of database "MainData" into tTable1  
copy tTable1 to (new or update)  table on remote mysql database "Maindata"" ;-)
end mouseUp


Thank you!

John Patten
SUSD
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Handling Long ID in Params?

[Ken Ray]

On Oct 17, 2011, at 12:30 PM, Scott Rossi wrote:
> ...this command can be triggered by any external object via the above router
> command (in the same script) with something like this:
> 
> runPrivateCommand "getObjectID","long id of" && long id of btw 1

I think you can even use:

   runPrivateCommand "getObjectID,"long id of btn 1"

> Thanks again Ken.

No prob!

:D


Ken Ray
Sons of Thunder Software, Inc.
Email: k...@sonsothunder.com
Web Site: http://www.sonsothunder.com/  

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Galactic Gaunlet

[tbodine]

Suggestion for RunRev: Put a Demo Mode in this game so those of us who don't
really want to master the game -- just see what LC can do -- can observe the
game in action without having to play it.

-- Tom Bodine


--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/Galactic-Gaunlet-tp3907504p3913142.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [OT] Plea for help

[Bob Sneidar]

I think Disk Warrior will create a new copy of the partition map, but he 
doesn't have one apparently. Not sure if Disk Warrior will deal with that. 

Bob


On Oct 15, 2011, at 5:26 PM, Tim Selander wrote:

> I used Disk Warrior with great success many times in the OS9 days; not sure 
> if they still are around under OSX.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[James Hurley]

Al,

This all started while was teaching at the university and working with a local 
grade school teacher. At that time Logo was all the rage and I thought it would 
be an ideal language in which young children might solve interesting physics 
problems, essentially implement numerical methods to solve differential 
equations. In Turtle Graphics for example a trajectory script looks like this:

 repeat until ycor() < 0
incXY vx,vy -- Increment the x and y coordinates by vx and vy every second
subtract gravity from vy
 end repeat

I wrote a book titled "Logo Physics" which is now out of print but available, 
used, on Amazon. (I was proud to see just now that one vender has for sale at 
$129.)

The very attractive element of Logo was what became knows as Turtle Graphics. 
(LOGO itself was modeled on LISP.) It was developed at MIT by Symour Papert et. 
al. I was talking to them at the time.

Later, I wrote a translator for TG in HyperTalk. There are several version of 
it at:  http://jamesphurley.com/runrev.html

There are a large number of applications there.

Kevin and I discussed the possibility of implementing it as part of Run Rev. 
They were more interesting in education at the time.

I'm not sure where that file you found came from, but it is not very readable. 
I have a clean version I will send you separately. Do not share it with others 
at this time. I have retitled (and did some rewriting of)  the Logo Physics 
book to "Programming for Science Students." I think that is the appropriate 
market--if one exists at all.

I still think it could be a useful component of LiveCode. In one iteration of 
the code, it can be used to move any RR control around the screen with FORWARD 
10, LEFT 45, etc. See "Control Turtles" on the above web site.

Unfortunately I am out of touch with this market now and so have nothing for 
you about current applications, if any. Trouble is perception. It is perceived 
as a tool for children, a perception quickly dispelled in Turtle Geometry by 
Abelson and diSessa. The last chapter is titled: Curved Geometry and General 
Relativity. 

Jim Hurley

> 
> Message: 18
> Date: Mon, 17 Oct 2011 07:02:16 -0700 (PDT)
> From: Alejandro Tejada 
> To: use-revolut...@lists.runrev.com
> Subject: Re: New rendering testing
> Message-ID: <1318860136941-3912148.p...@n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
> 
> Great work, Jim! :-D
> 
> After running these demos, finally I understand how
> useful could be for young minds, to use and learn
> Turtle Graphics.
> 
> I downloaded your book from:
> www.jamesphurley.com/jhurleyFolder/TurtlePhysics%20Text.doc
> and noticed that when I open the file
> in Open Office or WordPad, some characters are
> replaced by the question mark:
> 
> 3. Functions: direction(?,?) and distance(?,?).
> 
> By any chance, Did you write this document in
> a Macintosh and character conversion is changing
> the original text?
> 
> If possible, I would like that you point me to some
> studies that details the learning experience (for teachers
> and students) of using Turtle Graphics in the classroom.
> 
> Thanks again for sharing your groundbreaking work!
> 
> Al
> 


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: A Nit Nuisance

[Scott Rossi]

Hi Roger:

What you're seeing is the horizontal and vertical dimensions of the player
being swapped for some reason (seems like a bug in 4.6.4).  If you set the
width/height of the player to its formatted dimensions, you should be OK.
 set the width of player 1 to the formattedWidth of player 1
 set the height of player 1 to the formattedHeight of player 1

Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design



Recently, Roger Guay wrote:

> This is not a big deal but if anyone has a ready solution, I would appreciate
> it. 
> 
> Running 4.6.4 in Mac OS 10.7.2. As I am dragging a new Quicktime Player from
> the Toolbar to a stack, it appears to be square. But when it is dropped onto a
> stack it narrows down to 244 pixels in width and maintains 322 in height. The
> object size for a player in my LC Preferences is 236 wide and 118 height.
> Moreover when video clips are opened in the Application Browser, they are
> narrowed down as well, giving them that squeezed look. This problem does not
> occur in my 4.6.3 version of LC.
> 
> I've tried to reset all preferences to defaults , and I've tried reloading LC
> 4.6.4, both to no avail.
> 
> TIA and cheers,
> Roger
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

A Nit Nuisance

[Roger Guay]

This is not a big deal but if anyone has a ready solution, I would appreciate 
it. 

Running 4.6.4 in Mac OS 10.7.2. As I am dragging a new Quicktime Player from 
the Toolbar to a stack, it appears to be square. But when it is dropped onto a 
stack it narrows down to 244 pixels in width and maintains 322 in height. The 
object size for a player in my LC Preferences is 236 wide and 118 height. 
Moreover when video clips are opened in the Application Browser, they are 
narrowed down as well, giving them that squeezed look. This problem does not 
occur in my 4.6.3 version of LC.

I've tried to reset all preferences to defaults , and I've tried reloading LC 
4.6.4, both to no avail. 

TIA and cheers,
Roger

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Handling Long ID in Params?

[Scott Rossi]

Thanks Ken, you got me on the right path.  I lost so many hours on this dumb
thing, but I think it's a valid concept worth using.

Again, the idea is to be able to execute any private command of a script
using a single "router" command, with any number of parameters.  The caveat,
as Ken pointed out, is that long object ids need to include "long id of"
when used as parameters.  The code is simplified below:

command runPrivateCommand pCommand
   put item 2 to -1 of (word 2 to -1 of the params) into commandParams
   repeat for each item theString in commandParams
 -- strip outer quotes of params
 put char 2 to -2 of theString & comma after theArgs
   end repeat
   delete last char of theArgs -- strip trailing comma
   do pCommand && theArgs
end runPrivateCommand

So, as a simple example, if a script has a private command:

private command getObjectID pObj
   answer the id of pObj
end getObjectID

...this command can be triggered by any external object via the above router
command (in the same script) with something like this:

runPrivateCommand "getObjectID","long id of" && long id of btn 1



Thanks again Ken.

Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design




Recently, Ken Ray wrote:

> On Oct 17, 2011, at 4:11 AM, Scott Rossi wrote:
>> 
>> Maybe this isn't the best method to accomplish what I need, but can anyone
>> see why this is failing?
> 
> Scott, when you execute the "do", it's getting the text of the button and
> passing that along instead of the long id that's coming into
> "routeTheCommand". To make it not evaluate it, call:
> 
> routeTheCommand "getTheSum","the long id of btn 1"  -- put quotes around the
> second param
> 
> The other way you could do it would be to insert "the long id of " before
> theArgs if you knew it was an object reference that was coming in:
> 
> command routeTheCommand
>   put word 2 to -1 of the params into commandData
>   put stripOuterQuotes(item 1 of commandData) into theCommand
>   put stripOuterQuotes(item 2 to -1 of commandData) into theArgs
>   put "the long id of " before theArgs
>   do theCommand && theArgs
> end routeTheCommand
> 
> Funky, but it worksŠ
> 
> :D
> 
> Ken Ray
> Sons of Thunder Software, Inc.
> Email: k...@sonsothunder.com
> Web Site: http://www.sonsothunder.com/ 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[Joe Lewis Wilkins]

Alejandro:

Thanks for bringing this to our attention. I vaguely recall having read/studied 
something re "Turtle-Graphics" many years ago, so maybe it is time for  
refresher - even for us old students. (Smile)

Though I've not commented on any of your many contributions to the list, rest 
assured that I am as beholden to you as those who have. My needs are just more 
modest.

Enjoy your fine weather this time of the year.

Joe Wilkins
Architect

On Oct 17, 2011, at 7:02 AM, Alejandro Tejada wrote:

> Great work, Jim! :-D
> 
> After running these demos, finally I understand how
> useful could be for young minds, to use and learn
> Turtle Graphics.
> 
> I downloaded your book from:
> www.jamesphurley.com/jhurleyFolder/TurtlePhysics%20Text.doc
> and noticed that when I open the file
> in Open Office or WordPad, some characters are
> replaced by the question mark:
> 
> 3. Functions: direction(?,?) and distance(?,?).
> 
> By any chance, Did you write this document in
> a Macintosh and character conversion is changing
> the original text?
> 
> If possible, I would like that you point me to some
> studies that details the learning experience (for teachers
> and students) of using Turtle Graphics in the classroom.
> 
> Thanks again for sharing your groundbreaking work!
> 
> Al

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[Alejandro Tejada]

Great work, Jim! :-D

After running these demos, finally I understand how
useful could be for young minds, to use and learn
Turtle Graphics.

I downloaded your book from:
www.jamesphurley.com/jhurleyFolder/TurtlePhysics%20Text.doc
and noticed that when I open the file
in Open Office or WordPad, some characters are
replaced by the question mark:

3. Functions: direction(?,?) and distance(?,?).

By any chance, Did you write this document in
a Macintosh and character conversion is changing
the original text?

If possible, I would like that you point me to some
studies that details the learning experience (for teachers
and students) of using Turtle Graphics in the classroom.

Thanks again for sharing your groundbreaking work!

Al


--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/New-rendering-testing-tp3910362p3912148.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Galactic Gaunlet

[James Hurley]

Thanks Geoff. I'm up to 4 milliseconds now.

A good part of my problem was that I didn't get the iconic messages for up and 
down control. Dah.

I was looking for references to some of the new graphic features introduced in 
5.0.

I did find the layermode set to "dynamic" , but nothing about the compositor.

I've been playing with  a stack to compare some of these effect. See "Simple 
Motion: in User Samples.

Jim

> 
> --
> 
> Message: 11
> Date: Sat, 15 Oct 2011 16:13:24 -0500
> From: Geoff Canyon Rev 
> To: How to use LiveCode 
> Subject: Re: Galactic Gaunlet
> Message-ID:
>   
> Content-Type: text/plain; charset=ISO-8859-1
> 
> Be sure to check the code in the different cards in the stack.
> 
> As far as playing goes, I found the game much more playable/enjoyable
> if I changed a line in the function rocketMoveY:
> 
> from:
> 
>   add sClickData[sClickData["mousestate"]] to sMomentum
> 
> to:
> 
>   add sClickData[sClickData["mousestate"]] /2 to sMomentum
> 
> This makes the rocket sink/rise more slowly.
> 
> gc
> 
> 


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [OT] Onanistic Ocelot?

[Peter Alcibiades]

The thing that strikes me looking at Unity is how similar it is to
Windowmaker!  Back to the future with those big icons down the side of the
desktop.  

Well, the one person I put in Windowmaker for is fine with it.  So maybe
they have a point?  Dunno.

--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/OT-Onanistic-Ocelot-tp3904410p3912012.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Handling Long ID in Params?

[Ken Ray]

On Oct 17, 2011, at 4:11 AM, Scott Rossi wrote:
> 
> Maybe this isn't the best method to accomplish what I need, but can anyone
> see why this is failing?

Scott, when you execute the "do", it's getting the text of the button and 
passing that along instead of the long id that's coming into "routeTheCommand". 
To make it not evaluate it, call:

routeTheCommand "getTheSum","the long id of btn 1"  -- put quotes around the 
second param

The other way you could do it would be to insert "the long id of " before 
theArgs if you knew it was an object reference that was coming in:

command routeTheCommand
  put word 2 to -1 of the params into commandData
  put stripOuterQuotes(item 1 of commandData) into theCommand
  put stripOuterQuotes(item 2 to -1 of commandData) into theArgs
  put "the long id of " before theArgs
  do theCommand && theArgs
end routeTheCommand

Funky, but it works…

:D

Ken Ray
Sons of Thunder Software, Inc.
Email: k...@sonsothunder.com
Web Site: http://www.sonsothunder.com/  

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

... and of course, in the app store

[Heather Nagey]

Sorry, I forgot to add that you can now download and play Galactic  
Gauntlet from the App store:


http://itunes.apple.com/gb/app/galactic-gauntlet/id470771906?mt=8

cheers

Heather

Heather Nagey
Customer Services Manager
http://www.runrev.com/
LiveCode - Unleash Your Killer App


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Galactic Gauntlet

[Heather Nagey]

Dear List Folks,

If you haven't already come across it, you might want to take a look  
at our "proof of concept" game, Galactic Gauntlet. It helps show off  
the new possibilities of LiveCode 5, and you can download the source  
code and take a look here:


http://www.runrev.com/downloads/galactic-gauntlet.zip

Read more about it in the newsletter:

http://www.runrev.com/newsletter/october/issue120/newsletter2.php

Regards,

Heather

Heather Nagey
Customer Services Manager
http://www.runrev.com/
LiveCode - Unleash Your Killer App


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Handling Long ID in Params?

[Scott Rossi]

Anybody know if there's a problem using long IDs or filenames within the
params sent to a command?

I'm trying work out a method of triggering private commands in a frontscript
using an open "routing" command -- a command that takes incoming commands
with parameters and forwards them to the private ones.  Here's a simple
example that works for me (using a function to remove the outer quotes from
param values):

command routeTheCommand
  put word 2 to -1 of the params into commandData
  put stripOuterQuotes(item 1 of commandData) into theCommand
  put stripOuterQuotes(item 2 to -1 of commandData) into theArgs
  do theCommand && theArgs
end routeTheCommand

function stripOuterQuotes pStrings
   repeat for each item theString in pStrings
  put char 2 to -2 of theString & comma after temp
   end repeat
   delete last char of temp
   return temp
end stripOuterQuotes

private command getTheSum p1,p2,p3
  answer (p1+p2+p3)
end getTheSum

---

If I execute: routeTheCommand "getTheSum",1,2,3
I get "6" as expected.

Here's where I run into the problem. If I change getTheSum to a simple
answer routine:

private command getTheSum p1,p2,p3
  answer p1
end getTheSum

...and include the long id of a control in the command sent to the routing
handler:
  put long id of btn 1 into aLongID
  routeTheCommand "getTheSum",aLongID

Then "getTheSum" answers empty, instead of the button's long id.  If I test
the "theArgs" param within the routeTheCommand handler, it contains the
button's long id, but apparently "getTheSum" is not getting this value.

---

Maybe this isn't the best method to accomplish what I need, but can anyone
see why this is failing?

Thanks & Regards,

Scott Rossi
Creative Director
Tactile Media, UX Design



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Reading multiple identical nodes in an XML file

[Dave Cragg]

On 17 Oct 2011, at 05:45, Sivakatirswami wrote:

> I am an XML newbie:
> 
> if you want to extract data from a series of  identical nodes in a XML file, 
> how do you set up the repeat function?
> 

Here's one way. I'm sure there are others. (It returns a list of names and ages)

Dave

function namesAndAges xml
   
   put revCreateXMLTree(xml,true,true,false) into xmlID
   
   if xmlID is not a number then
  returm  xmlID -- error string
   end if
   
   put revXMLChildNames(xmlID,"/orphanage",comma,"small-child",true) into 
tChildren
   put empty into tRes  
   repeat for each item tChild in tChildren
  put "/orphanage/" & tChild  & "/name" into tNameNode
  put "/orphanage/" & tChild  & "/age" into tAgeNode
  
  put revXMLNodeContents(xmlID, tNameNode) into tName
  put revXMLNodeContents(xmlID, tAgeNode) into tAge
  
  put tName & ", " & tAge & cr after tRes
   end repeat

   return tRes
end namesAndAges
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Reading multiple identical nodes in an XML file

[Jim Ault]

correction on the timing loop stats

On Oct 17, 2011, at 2:30 AM, Jim Ault wrote:


This approach takes about
11 ticks to do 20,000 lines of XML
and creates a single tab-delim table


should read
11 ticks to do
100,000 of XML input
and 20,000 lines of tabular output


Jim Ault
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: New rendering testing

[René Micout]

Thank you James !!
René

Le 16 oct. 2011 à 22:08, James Hurley a écrit :

> i have been experimenting with the new rendering tools in 5.0
> 
> Here is a stack that allows you to experiment for yourselves. Run this in the 
> message box.
> 
>   go url "http://jamesphurley.com/jhurleyFolder/SimpleMotion.livecode";
> 
> It doen't appear that 5.0 is that different from 4.6 when the graphic demands 
> are simple. But for multiple moving objects, there is clearly an advantage to 
> 5.0
> 
> I have also post a stack illustrating a number of graphic functions on the 
> User Samples section of the LiveCode application. These all work reasonably 
> well in 4.6 and 5.0 They may also be downloaded by typing this in the Message 
> Box:
> 
> go url 
> "http://jamesphurley.com/jhurleyFolder/ProgrammableGraphics.livecode";
> 
> Render unto 5.0 that which is complex and 
> render unto 4.6 that which is simpler.
> 
> Jim Hurley
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode