Re: changes to runrev store

[Richmond]

On 08/19/2012 06:31 AM, Nigel Soden wrote:

Hi All

If what I read is correct then I am extremely disappointed as this pricing 
structure is too expensive for me. Living in South Africa and our exchange rate 
being as it is would makes this product expensive to develop with. Two of the 
reasons that made me go for LiveCode was I liked the concept and its price 
structure.  Also at the moment I'm still in the learning curve and busy with 
developing an application which hopefully will be finished by the end of this 
year.  This could very will but a stop to that as I may have to look for an 
alternative.


Or, you could be like me and develop software with whatever version of 
Livecode you already own and not  feel that you have to be permanently 
on the "upgrade escalator".


While I own LC 4.5, I do most of my development with LC 2.2.1 as that 
version already contained all the capabilities I need for the EFL 
content software that is my 'bread and cheese'.


When (if ?) my major software stuff (developed with LC 4.5) makes a spot 
of money I shall think about

upgrading; until it does, there is absolutely no way I can even dream of it.

As far as I can see the only reasons to upgrade (anything) are:

1. A new version has more capabilities that are 100% essential to my work.

2. The OS I'm running will not cope with the earlier version I am running.

[Just back from visiting my Mum and Dad, where I always do a spot of 
work on an old tray-loading
G3 iMac running Mac OS 10.3.9; can cope with LC 4.0, and Fontforge (my 
other weapon of choice)]


3. A new version allows me to author software to run on a wider variety 
of platforms [certainly
true of LC 5.5 compared with LC 4.5] that I 100% need for my software 
[not at all in my case].


Many, many people have the feeling they have to upgrade endlessly. All 
this feeling results in
(at least for people living in Bulgaria and South Africa) is a financial 
crisis  . . .   LOL.


---

This message was written on a second-hand DELL Optiplex 745 (cost 50 
Euros) hooked up

to a 17 inch monitor I fished out of a dustbin, running Ubuntu 12.04.

I do most of my programming on this machine or a 7 year old MacMini PPC 
attached to a similar monitor that was given to me by a bookshop owner 
went they decided to "go flat".


---





















___
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

iOS - sideways swiping within a vertically scrolling object?

[Terry Judd]

I have a vertically scrolling group (weekly timetable) and I like to be able to 
navigate backwards and forwards a week by swiping left or right within it. I 
can do this with a pair of touchstart/end scripts but unless the swipe is very 
horizontal the object scrolls and no touchstart or end messages are sent.

I've tried trapping the scrollerBeginDrag and scrollerEndDrag messages but 
there doesn't seem to be a reliable way to capture the 'mouse' coordinates 
within these messages so I can determine whether to count it is a horizontal 
swipe. The mouseH sometimes gives sensible values within a scrollerBeginDrag 
message and other times not - it never seems to return a sensible value in the 
scrollerEndDrag message.

Any ideas on a better way of tackling this?

Terry...

Dr Terry Judd
Senior Lecturer in Medical Education
Medical Eduction Unit
Faculty of Medicine, Dentistry & Health Sciences
The University of Melbourne



___
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: changes to runrev store

[Richard Gaskin]

Nigel Soden wrote:
> If what I read is correct then I am extremely disappointed as this
> pricing structure is too expensive for me.

Earlier today Kevin Miller wrote:
> Nothing has changed in the new store for existing customers, for
> any license type. The same pricing and upgrade policy applies.

--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 Follow me on Twitter:  http://twitter.com/FourthWorldSys


___
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

changes to runrev store

[Nigel Soden]

Hi All

If what I read is correct then I am extremely disappointed as this pricing 
structure is too expensive for me. Living in South Africa and our exchange rate 
being as it is would makes this product expensive to develop with. Two of the 
reasons that made me go for LiveCode was I liked the concept and its price 
structure.  Also at the moment I'm still in the learning curve and busy with 
developing an application which hopefully will be finished by the end of this 
year.  This could very will but a stop to that as I may have to look for an 
alternative. 





















___
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

[ANN] New plugin collection available

[Andre Garzia]

Hello Folks,

I am announcing a plugin collection called AAG|Tools. At this moment
is has two plugins in it but I plan to release my other custom plugins
in it as time goes by.

The current plugins are:

AAG | LayerComps a plugin for LiveCode that works just like the Layer
Comps palette from Adobe Photoshop. It allows you to record the rect
and visibility of controls in a card and switch between these recorded
states with ease.

AAG | TypeTool a plugin for LiveCode that makes it easier to change
the text properties of a control.

You can lean more about them by going to the following links:

  http://andregarzia.com/page/aagtools  -  hub page for the plugins.
  http://andregarzia.com/page/aaglayercomps  -  about LayerComps.
  http://andregarzia.com/page/aagtypetool  -  about TypeTool.

As usual, I have a support forum at:

  http://andregarzia.com/forum/

The collection is a commercial offering for U$30 and you can get them
from the pages above.

Cheers
andre

-- 
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.

___
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: more on-rev issues

[Mike Bonner]

Save the stack as legacy 2.7 and try it again. (assuming you're using lc
5.5 now)

lc server can't open 5.5 format stacks yet.
___
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: more on-rev issues

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 3:30 PM, Richard Gaskin 
wrote:
> es, RevServer should allow creation and manipulation of objects (at least
> the older Rev CGI allowed this), and using the "save" command you should
> even be able to save those changes to disk.

At that point, everything could exist, then--the output is generated by
copy or create card, copy group, move, and fill fields.

> But no, unfortunately you won't be able to do anything that involves
> rendering objects graphically.  Server environments are "faceless", they
> have no GUI components, and so there's no way for LiveCode to render
> anything into an imaging buffer such as would be need to generate PDF with
> its printToPDF external.

hmm.

I tossed together this simple stack.

In preOpenStack, it first writes a text file, then prints the first card as
pdf, then quits.

I don't *see* a flicker of it hitting the mac screen, nor does it put up
any kind of splash screen before exit.

Both files get written.

The files also get created if I ssh in from my iPad and "open quiet"

I then pushed my luck, and built it for linux and copied it over.

I telnetted in, and it crashed with an  X error.

Did a bit of googling, found and installed xvfb, and it produced my output.


I've copied it to the same on-rev directory as my test script, but I'm not
having much success.

I've got
start using stack "quiet.livecode"
put "now using "
send "preOpenStack" to stack "quiet.livecode"

and I get:

file "/home/dochawkb/public_html/test3.lc"
  row 15, col 7: Chunk: can't find stack
  row 15, col 1: start: can't find object

I get the same result if I use /home/dochawkb/public_html/quiet.livecode


> Thus far the only command-line app I've seen which can generate PDFs is
> ImageMagick:
> 

I've come to know it quite well :)   I'm sure there's more to it than
"convert", but . . .



-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: calling postgresql from the command line or within a .lc script

[Pierre Sahores]

The way we can use to deal around this server's security rule is to create 
serial of tables instead of a complete new database. This permit to do it by 
(LC-derver) script and works perfectly fine. Very handy to create companion's 
subdomains db backends on demand in saas contexts.

Le 19 août 2012 à 00:20, Dr. Hawkins a écrit :

> I just can't find a livecode lesson that doesn't just directly access a
> MySQL port . . .
> 
> I think I'm far enough along with livecode server to take a swing at
> talking to postgresql
> 
> I try
> put revOpenDatabase("postgresql", "dochawkbk.on-rev.com"
> ,"dochawkb_aTestDb","dochawkb","yeeHaw52!" ) into dbno
> put dbno & ""
> 
> 
> and get
> could not connect to server: Connection refused Is the server running on
> host "dochawkbk.on-rev.com" and accepting TCP/IP connections on port 5432?
> 
> It *should* be, shouldn't it--this is on on-rev.com?
> 
> SO I replace with "localhost" for the host, and get,
> FATAL: database "dochawkb_aTestDb" does not exist
> 
> I take it that this means that I *am* talking to the postgresql socket?
> 
> So I take a stroll to the phppgadmin page, and find the  "alter" section.
> 
> I don't have createdb checked for me.  I check it, give it passwords, and
> get the message that
> 
> *SQL error:*
> 
> ERROR:  must be superuser to alter superusers
> 
> Hmm, if I can't do this from the panel, how can I possibly create a new
> database from a script, whether lc or sh?
> -- 
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.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: remedial mysql???

[Mike Bonner]

Hmm, ok alternate idea.

I did this:


It works.

Inserting 100 records, including the time to build and create the file
takes about 14 milliseconds.

If you have trouble (like it can't find mysql) you can do a "put
shell("which mysql") and it will tell you where it is.
___
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: How to check if a group is in edit mode

[Peter Haworth]

Hi Mark,
Yes, I'm doing that when the user stops editing from within my utility.
 The problem I have is if the user stops editing by clicking the "Edit
Group" button in the LC toolbar.  There doesn't seem to be a message
generated when that happens so my utility never finds out about it.


Pete
lcSQL Software 



On Sat, Aug 18, 2012 at 4:00 PM, Mark Wieder  wrote:

> Peter-
>
> Saturday, August 18, 2012, 3:48:22 PM, you wrote:
>
> > Thanks for any ideas,
>
> Issue the command "stop editing"?
>
> --
> -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
>
___
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: How to check if a group is in edit mode

[Mark Wieder]

Peter-

Saturday, August 18, 2012, 3:48:22 PM, you wrote:

> Thanks for any ideas,

Issue the command "stop editing"?

-- 
-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

How to check if a group is in edit mode

[Peter Haworth]

In a utility I'm writing, I need to keep track of when groups in stacks
outside the utility go into and out of edit mode.  The context is as
follows.

I have a front script that traps newField, newButton, etc messages.  In
that script I can easily tell if the control is being added while the stack
is in group edit mode by checking the stack's editBackground property, but
I need to figure out how to detect when it comes out of edit mode.

To further explain, it seems that when a group is placed into group edit
mode, it no longer owns any controls, I guess it has essentially been
ungrouped although the group itself still exists.  When a control is added
to a card in group edit mode, it is owned by the card not the group.  Only
when the group comes out of edit mode do the group's controls become owned
by the group again. My utility needs to keep track of the controls in a
group and loses track of them because of the above.  The only way I can
think of to find out what controls are in the group is to detect when it
comes out of group edit mode.

I haven't been able to find any messages that would help me so looking for
advice on how to deal with this situation.

I could have edit/stop editing group buttons in my utility (and probably
will) but I would really like to be able to use the LC Edit Group button as
well.

Thanks for any ideas,

Pete
lcSQL Software 
___
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: more on-rev issues

[Richard Gaskin]

 Dr. Hawkins wrote:


In particular, what I'll ultimately need is for them to run scripts that
build cards and then put the output to pdf (which is currently working in
livecode)


Can help in about those tasks as long i only build HTML5/CSS3/JQuery
outputs from my own on-rev stack's libs.

I'm not fully following here . . . . If I can cause a stack to manipulate
its cards and fields, I can make it do what I need.


Well, yes and no.

Yes, RevServer should allow creation and manipulation of objects (at 
least the older Rev CGI allowed this), and using the "save" command you 
should even be able to save those changes to disk.


But no, unfortunately you won't be able to do anything that involves 
rendering objects graphically.  Server environments are "faceless", they 
have no GUI components, and so there's no way for LiveCode to render 
anything into an imaging buffer such as would be need to generate PDF 
with its printToPDF external.


Thus far the only command-line app I've seen which can generate PDFs is 
ImageMagick:



--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 Follow me on Twitter:  http://twitter.com/FourthWorldSys

___
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: remedial mysql???

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 2:49 PM, Mike Bonner  wrote:
>
> I've just been messing with things with the on-rev mysql server. It doesn't
> seem like you can pass a whole multiline with 1 revexecutesql


I was afraid someone would say that :)

>The error will most likely go away.  And you still get the speed benefit of
>using a single transaction for multiple alters.

But not the big part--only hitting the server once.

It's a very noticeable amount of time to hit the server, while the
time on the transaction is trivial

thanks

hawk

--
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109

___
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: more on-rev issues

[Mike Bonner]

ah k, I think I remember the trouble I had with fields/buttons/etc was
because I had scripts in them. Though certain things are still said not to
work (as mentioned, the visual stuff like snapshot)

On Sat, Aug 18, 2012 at 4:26 PM, Matthias Rebbe <
matthias_livecode_150...@m-r-d.de> wrote:

> As Mike already stated that will not work. But you could use Quartam PDF
> library. http://www.quartam.com
> That library works also with LiveCodeServer. See the example page at
> http://quartam.on-rev.com/qrtpdfdemos.irev
>
> Regards,
>
> Matthias
>
>
> Am 18.08.2012 um 23:57 schrieb Mike Bonner :
>
> > Don't believe you can manipluate the cards/objects directly. If you look
> at
> > this page: http://www.runrev.com/developers/documentation/server/  part
> 3.2
> > using stacks it says you can't use visual related stuff when using a
> stack.
> >
> > Since there is no actual stack displayed, hence no screen coords or
> > anything related.
> >
> > Also if you look at page 14 here:
> >
> http://www.runrev.com/downloads/livecode/4_6_3/LiveCodeNotes-4_6_3-Server.pdf
> > print to pdf is not yet supported.
> >
> >
> >
> >> I'm not fully following here . . . . If I can cause a stack to
> manipulate
> >> its cards and fields, I can make it do what I need.
> >>
> >> If not, I may have to relearn forth/postscript . . . (ugh.  don't miss
> >> them)
> >>
> >>
> > ___
> > 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: more on-rev issues

[Matthias Rebbe]

Hi Stephan,

that sounds very interesting. I tried this some weeks ago w/o success. Do you 
have a sample script to show.

Regards,

Matthias

Am 19.08.2012 um 00:24 schrieb stephen barncard 
:

> I've been able to read/write to a field in a stack from an .irev document
> using livecode server. And while in the IDE on land,  I've used UI elements
> in the stack for testing routines that aren't used 'in the wild'. lc server
> doesn't seem to choke on those UI elements, usually ignores.  I think I've
> created and deleted cards too.
> And of course the custom properties are gold in the server environment for
> lookup and site (not user) settings
> Sometime whole library stacks created for the desktop can work verbatim in
> the server environment  such as Mark Smith's (the late one) mp3 tag reading
> and writing library.
> 
> 
> On Sat, Aug 18, 2012 at 2:57 PM, Mike Bonner  wrote:
> 
>> Don't believe you can manipluate the cards/objects directly. If you look at
>> this page: http://www.runrev.com/developers/documentation/server/  part
>> 3.2
>> using stacks it says you can't use visual related stuff when using a stack.
>> 
>> Since there is no actual stack displayed, hence no screen coords or
>> anything related.
>> 
>> Also if you look at page 14 here:
>> 
>> http://www.runrev.com/downloads/livecode/4_6_3/LiveCodeNotes-4_6_3-Server.pdf
>> print to pdf is not yet supported.
>> 
>> 
>> 
>>> I'm not fully following here . . . . If I can cause a stack to manipulate
>>> its cards and fields, I can make it do what I need.
>>> 
>>> If not, I may have to relearn forth/postscript . . . (ugh.  don't miss
>>> them)
>>> 
>>> 
>> ___
>> 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
>> 
> 
> 
> 
> -- 
> 
> 
> 
> Stephen Barncard
> San Francisco Ca. USA
> 
> more about sqb  
> ___
> 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: more on-rev issues

[Matthias Rebbe]

As Mike already stated that will not work. But you could use Quartam PDF 
library. http://www.quartam.com
That library works also with LiveCodeServer. See the example page at
http://quartam.on-rev.com/qrtpdfdemos.irev

Regards,

Matthias


Am 18.08.2012 um 23:57 schrieb Mike Bonner :

> Don't believe you can manipluate the cards/objects directly. If you look at
> this page: http://www.runrev.com/developers/documentation/server/  part 3.2
> using stacks it says you can't use visual related stuff when using a stack.
> 
> Since there is no actual stack displayed, hence no screen coords or
> anything related.
> 
> Also if you look at page 14 here:
> http://www.runrev.com/downloads/livecode/4_6_3/LiveCodeNotes-4_6_3-Server.pdf
> print to pdf is not yet supported.
> 
> 
> 
>> I'm not fully following here . . . . If I can cause a stack to manipulate
>> its cards and fields, I can make it do what I need.
>> 
>> If not, I may have to relearn forth/postscript . . . (ugh.  don't miss
>> them)
>> 
>> 
> ___
> 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: more on-rev issues

[stephen barncard]

I've been able to read/write to a field in a stack from an .irev document
using livecode server. And while in the IDE on land,  I've used UI elements
in the stack for testing routines that aren't used 'in the wild'. lc server
doesn't seem to choke on those UI elements, usually ignores.  I think I've
created and deleted cards too.
And of course the custom properties are gold in the server environment for
lookup and site (not user) settings
Sometime whole library stacks created for the desktop can work verbatim in
the server environment  such as Mark Smith's (the late one) mp3 tag reading
and writing library.


On Sat, Aug 18, 2012 at 2:57 PM, Mike Bonner  wrote:

> Don't believe you can manipluate the cards/objects directly. If you look at
> this page: http://www.runrev.com/developers/documentation/server/  part
> 3.2
> using stacks it says you can't use visual related stuff when using a stack.
>
> Since there is no actual stack displayed, hence no screen coords or
> anything related.
>
> Also if you look at page 14 here:
>
> http://www.runrev.com/downloads/livecode/4_6_3/LiveCodeNotes-4_6_3-Server.pdf
> print to pdf is not yet supported.
>
>
>
> > I'm not fully following here . . . . If I can cause a stack to manipulate
> > its cards and fields, I can make it do what I need.
> >
> > If not, I may have to relearn forth/postscript . . . (ugh.  don't miss
> > them)
> >
> >
> ___
> 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
>



-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  
___
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

calling postgresql from the command line or within a .lc script

[Dr. Hawkins]

I just can't find a livecode lesson that doesn't just directly access a
MySQL port . . .

I think I'm far enough along with livecode server to take a swing at
talking to postgresql

I try
 put revOpenDatabase("postgresql", "dochawkbk.on-rev.com"
,"dochawkb_aTestDb","dochawkb","yeeHaw52!" ) into dbno
put dbno & ""


and get
could not connect to server: Connection refused Is the server running on
host "dochawkbk.on-rev.com" and accepting TCP/IP connections on port 5432?

It *should* be, shouldn't it--this is on on-rev.com?

SO I replace with "localhost" for the host, and get,
FATAL: database "dochawkb_aTestDb" does not exist

I take it that this means that I *am* talking to the postgresql socket?

So I take a stroll to the phppgadmin page, and find the  "alter" section.

I don't have createdb checked for me.  I check it, give it passwords, and
get the message that

*SQL error:*

ERROR:  must be superuser to alter superusers

Hmm, if I can't do this from the panel, how can I possibly create a new
database from a script, whether lc or sh?
-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: more on-rev issues

[Mike Bonner]

Don't believe you can manipluate the cards/objects directly. If you look at
this page: http://www.runrev.com/developers/documentation/server/  part 3.2
using stacks it says you can't use visual related stuff when using a stack.

Since there is no actual stack displayed, hence no screen coords or
anything related.

Also if you look at page 14 here:
http://www.runrev.com/downloads/livecode/4_6_3/LiveCodeNotes-4_6_3-Server.pdf
print to pdf is not yet supported.



> I'm not fully following here . . . . If I can cause a stack to manipulate
> its cards and fields, I can make it do what I need.
>
> If not, I may have to relearn forth/postscript . . . (ugh.  don't miss
> them)
>
>
___
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: remedial mysql???

[Mike Bonner]

I've just been messing with things with the on-rev mysql server. It doesn't
seem like you can pass a whole multiline with 1 revexecutesql

If you do:
revexecutesql connectid,"START TRANSCTION"
revexecutesql connectid,"ALTER TABLE dna ADD disp BOOLEAN"
revexecutesql connectid, "ALTER TABLE dna  ADD cont CHAR(1)"
revexecutesql connectid, "ALTER TABLE dna  ADD coDbt CHAR(1)"
revexecutesql connectid,"COMMIT"

The error will most likely go away.  And you still get the speed benefit of
using a single transaction for multiple alters.



> I've fired up again, and now, with a command of
> BEGIN
> ALTER TABLE dna  ADD disp BOOLEAN
> ALTER TABLE dna  ADD cont CHAR(1)
> ALTER TABLE dna  ADD coDbt CHAR(1)
> COMMIT
>
>
>
___
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: more on-rev issues

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 2:04 PM, Pierre Sahores wrote:

> See this example script witch acts as the stack "rias_lib.livecode"
> launcher
> start using stack "rias_lib.livecode"
>   ...
> catch tErr
> try
> ...
> start using stack "rias_lib_bis.livecode" -- this is the
> stack's lib to be used when  stack "rias_lib.livecode" is't available
> because just in the middle seconds where i'm saving its update to the
> server --
>
>

So there's a duplicate to fill in while saving/updating the primary?

I assume that when it comes back, the secondary does it?



> In particular, what I'll ultimately need is for them to run scripts that
> build cards and then put the output to pdf (which is currently working in
> livecode)

Can help in about those tasks as long i only build HTML5/CSS3/JQuery
outputs from my own on-rev stack's libs.

I'm not fully following here . . . . If I can cause a stack to manipulate
its cards and fields, I can make it do what I need.

If not, I may have to relearn forth/postscript . . . (ugh.  don't miss them)

-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: remedial mysql???

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 2:08 PM, Peter Haworth  wrote:
>
> On Sat, Aug 18, 2012 at 1:05 PM, Dr. Hawkins  wrote:

> >
> > I'm not seeing that in the 5.5.1 dictionary for revExecuteSQL (or
> > revDataFromQuery, for that matter).  Am I looking in the wrong place?
> >
>
> From the dictionary entry for revExecuteSQL:
>
> "The SQLStatement is a string  in Structured
> Query Language . (Do not include a semicolon at the
end
> of the SQLStatement.)"

OK, i finally found it.  I had to paste it  into openoffice to successfully
search, but . . .

> >
> > And while I'm asking such things, how can Livecode even *have* a
> > requirement here--shouldn't it be just passing the command to the
database?
> >
>
> Ours not to reason why, ours just to do as mother ship instructs :-)  Have
> you tried it without the semicolons?

Yes, with & without semicolons; with & without begin/end.  But here's a new
message:


I've fired up again, and now, with a command of
BEGIN
ALTER TABLE dna  ADD disp BOOLEAN
ALTER TABLE dna  ADD cont CHAR(1)
ALTER TABLE dna  ADD coDbt CHAR(1)
COMMIT


I get

You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'ALTER TABLE
dna  ADD disp BOOLEAN
ALTER TABLE dna  ADD cont CHAR(1)
ALTER TABLE ' at line 2


> > I'm trying to cut the lag from a remote db by batching those commands I
can
> > (there was really no reason for these to be individual queries in the
first
> > place, other than that there will only be one or two of them typically,
> > save when opening a new client "file", in which case there will be
dozens")
>
>
> OK, if you are doing multiple ALTER TABLE statements, then yes, wrap them
> in START/COMMIT.  I thought you were only executing one since that is what
> was in your original example.  But you still need to use revExecuteSQL;
> revDataFromQuery is for returning columns from a SELECT statement.

It will successfully execute just about any one-line command, it appears;
I've been using it for the individual ALTER and so forth for some time.


> I'm curious as to why you need to add all these columns to an existing
> table.  I assume your database must be customizable according to the
> clients' needs?

There are about 200 judicial districts in the US, all with somewhat
different requirements. Then there are the add-ons packages for chapter 13
and what-have-you, and certainly custom features.

As I have it set up, if a new field appears, whether for one of these, or
because I added a feature, it automatically gets added to the database, and
its contents swept to/from the db.

Also helpful during development, when I realize, "Oh, I also need a . . ."

The feature actually traces back to the original 1989 HyperCard prototype,
when used to dump data for mailmerge.
'thanks



--
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: remedial mysql???

[Peter Haworth]

On Sat, Aug 18, 2012 at 1:05 PM, Dr. Hawkins  wrote:

> On Sat, Aug 18, 2012 at 11:28 AM, Peter Haworth  wrote:
>
> > You don't HAVE to remove the START/COMMIT, I was pointing out that they
> are
> > superfluous.  Leave them in if you wish.
> >
>
> OK; I thought that it was up to the db what to do without them.
>
>
> > The semicolon issue has nothing to do with what mySQL requires, it's a
> > Livecode requirement - see the dictionary.
> >
>
> I'm not seeing that in the 5.5.1 dictionary for revExecuteSQL (or
> revDataFromQuery, for that matter).  Am I looking in the wrong place?
>

>From the dictionary entry for revExecuteSQL:

"The SQLStatement is a string  in Structured
Query Language . (Do not include a semicolon at the end
of the SQLStatement.)"


>
> And while I'm asking such things, how can Livecode even *have* a
> requirement here--shouldn't it be just passing the command to the database?
>

Ours not to reason why, ours just to do as mother ship instructs :-)  Have
you tried it without the semicolons?


>
>
> > Finally, if you're using revDataFromQuery to do this, I'm surprised it
> ever
> > worked.  You're not getting data from a query, you're executing SQL
> > commands so you need to use revExecuteSQL.
> >
>
> Until today, I had been sending single line commands.
>
> I'm trying to cut the lag from a remote db by batching those commands I can
> (there was really no reason for these to be individual queries in the first
> place, other than that there will only be one or two of them typically,
> save when opening a new client "file", in which case there will be dozens")


OK, if you are doing multiple ALTER TABLE statements, then yes, wrap them
in START/COMMIT.  I thought you were only executing one since that is what
was in your original example.  But you still need to use revExecuteSQL;
revDataFromQuery is for returning columns from a SELECT statement.

I'm curious as to why you need to add all these columns to an existing
table.  I assume your database must be customizable according to the
clients' needs?


> .
>
> MySQL's own examples are generally multi-line, with the begin/commit
> syntax.
>

Yep, multiline=inlcude START/COMMIT, single line= no need to include
START/COMMIT but doesn't do any harm if you do.

>
> thanks
>
> hawk, confused
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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: more on-rev issues

[Pierre Sahores]

See this example script witch acts as the stack "rias_lib.livecode" launcher



Le 18 août 2012 à 22:49, Dr. Hawkins a écrit :

> On Sat, Aug 18, 2012 at 1:10 PM, Pierre Sahores 
> wrote:
>> 
>> To target the revServer 4.6.4, the script need to be named as
> "yourchoice.irev" and to
>> target the revServer 5.0.2, the script need to be named as "yourchoice.lc"
> for simple
>> scripts and  "yourchoice.livecode" for stacks to be inserted in the path
> of the
>> "yourchoice.lc" scripts
> 
> ah-hah.
> 
> I've now got it working at http://dochawkbk.on-rev.com/test3.lc
> 
> How far can I go with those stacks?
> 
> In particular, what I'll ultimately need is for them to run scripts that
> build cards and then put the output to pdf (which is currently working in
> livecode)

Can help in about those tasks as long i only build HTML5/CSS3/JQuery outputs 
from my own on-rev stack's libs.
> 
> thanks greatly.
> 
> hawk
> 
> 
> 
> 
> 
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.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: more on-rev issues

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 1:10 PM, Pierre Sahores 
wrote:
>
> To target the revServer 4.6.4, the script need to be named as
"yourchoice.irev" and to
>target the revServer 5.0.2, the script need to be named as "yourchoice.lc"
for simple
>scripts and  "yourchoice.livecode" for stacks to be inserted in the path
of the
>"yourchoice.lc" scripts

ah-hah.

I've now got it working at http://dochawkbk.on-rev.com/test3.lc

How far can I go with those stacks?

In particular, what I'll ultimately need is for them to run scripts that
build cards and then put the output to pdf (which is currently working in
livecode)

thanks greatly.

hawk





--
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: remedial mysql???

[Mike Bonner]

If you are using revdatafromquery it wraps your query in a begin and commit
on its own.  If you have 2 queries you want to do, and can't use wheres
with and/or to do it you can still do several queries in 1 call.  To test I
just did this..

*command* queryWithTransaction

   *put* "SELECT * FROM contacts where first_name='Mike';" & cr & "SELECT *
from contacts where first_name='Carl';"  into tSql

   *get* revdatafromquery(,,1,tSql)

   *put* it

*end* queryWithTransaction

It works fine, returns all mikes and carls 1 after the other.  Only tested
on sqlite but the lc side functionality should be the same.  Of course this
is a REALLY bad example since the same thing could be accomplished with a
single query, but as a demonstration that multilines are possible, it
works.

Oh, another thing, if you do add begin and commit to the string you send
using revdatafromquery the returned error is "can't begin a transaction
within a transaction" which is how you know LC is starting and ending the
transaction for you.


If you are doing inserts with revexecutesql (or updates or deletes) then
you should be able to do multilines. I've only actually tried it with
sqlite but there are a couple methods possible (i think)

If you are looping through lots of data and inserting 1 record at a time
this can be slow due to the transaction lag at the server.

If you issue a begin transaction first, then go into the loop and send each
revexecutesql to the server in turn it will build the list waiting for a
commit. After the loop is done, you can send the commit with revexecutesql
and the inserts will be done or if there was a problem NONE of the inserts
will be done. (so you should be checking for errors being returned as
always)

I suspect that you can build the whole list on the rev side and send it as
one big chunk to the server, but I don't know what quirks you might run
into doing it that way.  (
On Sat, Aug 18, 2012 at 2:05 PM, Dr. Hawkins  wrote:

> On Sat, Aug 18, 2012 at 11:28 AM, Peter Haworth  wrote:
>
> > You don't HAVE to remove the START/COMMIT, I was pointing out that they
> are
> > superfluous.  Leave them in if you wish.
> >
>
> OK; I thought that it was up to the db what to do without them.
>
>
> > The semicolon issue has nothing to do with what mySQL requires, it's a
> > Livecode requirement - see the dictionary.
> >
>
> I'm not seeing that in the 5.5.1 dictionary for revExecuteSQL (or
> revDataFromQuery, for that matter).  Am I looking in the wrong place?
>
> And while I'm asking such things, how can Livecode even *have* a
> requirement here--shouldn't it be just passing the command to the database?
>
>
> > Finally, if you're using revDataFromQuery to do this, I'm surprised it
> ever
> > worked.  You're not getting data from a query, you're executing SQL
> > commands so you need to use revExecuteSQL.
> >
>
> Until today, I had been sending single line commands.
>
> I'm trying to cut the lag from a remote db by batching those commands I can
> (there was really no reason for these to be individual queries in the first
> place, other than that there will only be one or two of them typically,
> save when opening a new client "file", in which case there will be
> dozens").
>
> MySQL's own examples are generally multi-line, with the begin/commit
> syntax.
>
> thanks
>
> hawk, confused
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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: more on-rev issues

[stephen barncard]

I can't say enough good things about the Livecode server environment.

 A good tip for those starting to to work with the server is to put a

set the errormode to "inline"

as the first line of code after the http://www.google.com/profiles/sbarncar>
___
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

Fwd: more on-rev issues

[Pierre Sahores]

Sorry for the mistake : instead of revServer 5.0.2, please read LC-server 5.0.2

Début du message réexpédié :

> De : Pierre Sahores 
> Date : 18 août 2012 22:10:59 HAEC
> À : How to use LiveCode 
> Cc : Pierre Sahores 
> Objet : Réexp : more on-rev issues
> 
> To target the revServer 4.6.4, the script need to be named as 
> "yourchoice.irev" and to target the revServer 5.0.2, the script need to be 
> named as "yourchoice.lc" for simple scripts and  "yourchoice.livecode" for 
> stacks to be inserted in the path of the "yourchoice.lc" scripts
> 
> Début du message réexpédié :
> 
>> De : Pierre Sahores 
>> Date : 18 août 2012 22:03:15 HAEC
>> À : How to use LiveCode 
>> Cc : Pierre Sahores 
>> Objet : Rép : more on-rev issues
>> 
>> Use 
>> 
>>> >> put "Hello world."
>>> ?>
>> 
>> without space between ?rev to get a response from the revServer 4.6.4 and 
>> 
>>> >> put "Hello world."
>>> ?>
>> 
>> to get a response from the LC-Server 5.0.2.
>> 
>> As you will verify, both engines are available to each on-rev accounts
>> 
>> About the on-rev standalone, you are true and the best is to code your 
>> server-side components directly in the LC desktop dedicated IDE in using 
>> Stephen Barncard's method (double-click your server-side LC-server 
>> stack.livecode library from within your prefered FTP browser and it will 
>> launches your LC destop dev IDE - works fine, at least against CyberDuck / 
>> MacOS X 10.6.x and 10.7.x).
>> 
>> Best,
>> 
>> Le 18 août 2012 à 21:19, Dr. Hawkins a écrit :
>> 
>>> This is getting more frustrating by the minute . . .
>>> 
>>> The On-rev standalone seems unstable, at best.  hitting a couple of arrow
>>> keys to maneuver seems to knock it out of commission.  It didn't even occur
>>> to me to check or ssh access.
>>> 
>>> Anyway, on-rev doesn't seem to be rendering .irev files as such; it's
>>> simply ignoring them
>>> 
>>> The file
>>> 
>>> >> put "Hello world."
>>> ?>
>>> at http://dochawkbk.on-rev.com/mytest.irev
>>> 
>>> produces
>>> 
>>> This is new text
>>> 
>>> 
>>> -- 
>>> The Hawkins Law Firm
>>> Richard E. Hawkins, Esq.
>>> (702) 508-8462
>>> hawkinslawf...@gmail.com
>>> 3025 S. Maryland Parkway
>>> Suite A
>>> Las Vegas, NV  89109
>>> ___
>>> 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
>> 
>> --
>> Pierre Sahores
>> mobile : 06 03 95 77 70
>> www.sahores-conseil.com
>> 
> 
> --
> Pierre Sahores
> mobile : 06 03 95 77 70
> www.sahores-conseil.com
> 

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.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

Fwd: more on-rev issues

[Pierre Sahores]

To target the revServer 4.6.4, the script need to be named as "yourchoice.irev" 
and to target the revServer 5.0.2, the script need to be named as 
"yourchoice.lc" for simple scripts and  "yourchoice.livecode" for stacks to be 
inserted in the path of the "yourchoice.lc" scripts

Début du message réexpédié :

> De : Pierre Sahores 
> Date : 18 août 2012 22:03:15 HAEC
> À : How to use LiveCode 
> Cc : Pierre Sahores 
> Objet : Rép : more on-rev issues
> 
> Use 
> 
>> > put "Hello world."
>> ?>
> 
> without space between ?rev to get a response from the revServer 4.6.4 and 
> 
>> > put "Hello world."
>> ?>
> 
> to get a response from the LC-Server 5.0.2.
> 
> As you will verify, both engines are available to each on-rev accounts
> 
> About the on-rev standalone, you are true and the best is to code your 
> server-side components directly in the LC desktop dedicated IDE in using 
> Stephen Barncard's method (double-click your server-side LC-server 
> stack.livecode library from within your prefered FTP browser and it will 
> launches your LC destop dev IDE - works fine, at least against CyberDuck / 
> MacOS X 10.6.x and 10.7.x).
> 
> Best,
> 
> Le 18 août 2012 à 21:19, Dr. Hawkins a écrit :
> 
>> This is getting more frustrating by the minute . . .
>> 
>> The On-rev standalone seems unstable, at best.  hitting a couple of arrow
>> keys to maneuver seems to knock it out of commission.  It didn't even occur
>> to me to check or ssh access.
>> 
>> Anyway, on-rev doesn't seem to be rendering .irev files as such; it's
>> simply ignoring them
>> 
>> The file
>> 
>> > put "Hello world."
>> ?>
>> at http://dochawkbk.on-rev.com/mytest.irev
>> 
>> produces
>> 
>> This is new text
>> 
>> 
>> -- 
>> The Hawkins Law Firm
>> Richard E. Hawkins, Esq.
>> (702) 508-8462
>> hawkinslawf...@gmail.com
>> 3025 S. Maryland Parkway
>> Suite A
>> Las Vegas, NV  89109
>> ___
>> 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
> 
> --
> Pierre Sahores
> mobile : 06 03 95 77 70
> www.sahores-conseil.com
> 

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.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: remedial mysql???

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 11:28 AM, Peter Haworth  wrote:

> You don't HAVE to remove the START/COMMIT, I was pointing out that they are
> superfluous.  Leave them in if you wish.
>

OK; I thought that it was up to the db what to do without them.


> The semicolon issue has nothing to do with what mySQL requires, it's a
> Livecode requirement - see the dictionary.
>

I'm not seeing that in the 5.5.1 dictionary for revExecuteSQL (or
revDataFromQuery, for that matter).  Am I looking in the wrong place?

And while I'm asking such things, how can Livecode even *have* a
requirement here--shouldn't it be just passing the command to the database?


> Finally, if you're using revDataFromQuery to do this, I'm surprised it ever
> worked.  You're not getting data from a query, you're executing SQL
> commands so you need to use revExecuteSQL.
>

Until today, I had been sending single line commands.

I'm trying to cut the lag from a remote db by batching those commands I can
(there was really no reason for these to be individual queries in the first
place, other than that there will only be one or two of them typically,
save when opening a new client "file", in which case there will be dozens").

MySQL's own examples are generally multi-line, with the begin/commit syntax.

thanks

hawk, confused
-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: more on-rev issues

[Pierre Sahores]

Use 

>   put "Hello world."
>  ?>

without space between ?rev to get a response from the revServer 4.6.4 and 

>   put "Hello world."
>  ?>

 to get a response from the LC-Server 5.0.2.

As you will verify, both engines are available to each on-rev accounts

About the on-rev standalone, you are true and the best is to code your 
server-side components directly in the LC desktop dedicated IDE in using 
Stephen Barncard's method (double-click your server-side LC-server 
stack.livecode library from within your prefered FTP browser and it will 
launches your LC destop dev IDE - works fine, at least against CyberDuck / 
MacOS X 10.6.x and 10.7.x).

Best,

Le 18 août 2012 à 21:19, Dr. Hawkins a écrit :

> This is getting more frustrating by the minute . . .
> 
> The On-rev standalone seems unstable, at best.  hitting a couple of arrow
> keys to maneuver seems to knock it out of commission.  It didn't even occur
> to me to check or ssh access.
> 
> Anyway, on-rev doesn't seem to be rendering .irev files as such; it's
> simply ignoring them
> 
> The file
> 
>   put "Hello world."
>  ?>
> at http://dochawkbk.on-rev.com/mytest.irev
> 
> produces
> 
> This is new text
> 
> 
> -- 
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.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: more on-rev issues

[Mike Bonner]

Also just occurred to me if you have an .htaccess in the folder already
with something strange in it, the .htaccess itself might be breaking lc.

On Sat, Aug 18, 2012 at 1:58 PM, Alex Tweedly  wrote:

> If you go into your browser's "View source" you'll see that it contains
> something like
>
>
>  >put "This is inside the lc section"
>> ?>
>> This is outside the lc section
>>
> with the first 3 lines in some odd colour / format.
> No idea how or why or what it means - I'd try re-typing and uploading again
>
> -- Alex.
>
>
>
> On 18/08/2012 20:52, Dr. Hawkins wrote:
>
>> On Sat, Aug 18, 2012 at 12:29 PM, Mike Bonner  wrote:
>>
>>  The source of the page is this: (after being sent by on-rev)
>>>
>>> 
>>> This is new text
>>>
>>>  Thanks, but that doesn't seem to do it:
>>
>> >put "This is inside the lc section"
>> ?>
>> This is outside the lc section
>>
>> at 
>> http://dochawkbk.on-rev.com/**test2.irev
>>
>> still yields
>> This is outside the lc section
>>
>>
> __**_
> 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: more on-rev issues

[stephen barncard]

.lc is the last version of lc server that can run stacks, and .rev would
call an earlier version  - both versions are running at on-rev

On Sat, Aug 18, 2012 at 12:57 PM, Mike Bonner  wrote:

> Hmm, out of curiosity, if you change it to  ?> rather than 
> And vice versa, if you leave it as  .lc does it work then?
>
> I know there are several versions of livecode server available in on-rev
> but I don't recall how you differentiate which one you wish to use. This
> might be part of the issue. If I get a sec, i'll add some files to my
> on-rev and see if I can get the same behavior as you.
>
> On Sat, Aug 18, 2012 at 1:52 PM, Dr. Hawkins  wrote:
>
> > On Sat, Aug 18, 2012 at 12:29 PM, Mike Bonner 
> wrote:
> >
> > > The source of the page is this: (after being sent by on-rev)
> > >
> > > 
> > > This is new text
> > >
> >
> > Thanks, but that doesn't seem to do it:
> >
> >  >   put "This is inside the lc section"
> > ?>
> > This is outside the lc section
> >
> > at http://dochawkbk.on-rev.com/test2.irev
> >
> > still yields
> > This is outside the lc section
> >
> > --
> > The Hawkins Law Firm
> > Richard E. Hawkins, Esq.
> > (702) 508-8462
> > hawkinslawf...@gmail.com
> > 3025 S. Maryland Parkway
> > Suite A
> > Las Vegas, NV  89109
> > ___
> > 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
>



-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  
___
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: more on-rev issues

[Mike Bonner]

Ah yep, just found the info. .irev maps to the rev server engine, so using
the http://lessons.runrev.com/m/4070/l/41105 to do your own mappings)

On Sat, Aug 18, 2012 at 1:57 PM, Mike Bonner  wrote:

> Hmm, out of curiosity, if you change it to  ?> rather than 
> And vice versa, if you leave it as  .lc does it work then?
>
> I know there are several versions of livecode server available in on-rev
> but I don't recall how you differentiate which one you wish to use. This
> might be part of the issue. If I get a sec, i'll add some files to my
> on-rev and see if I can get the same behavior as you.
>
>
> On Sat, Aug 18, 2012 at 1:52 PM, Dr. Hawkins  wrote:
>
>> On Sat, Aug 18, 2012 at 12:29 PM, Mike Bonner  wrote:
>>
>> > The source of the page is this: (after being sent by on-rev)
>> >
>> > 
>> > This is new text
>> >
>>
>> Thanks, but that doesn't seem to do it:
>>
>> >   put "This is inside the lc section"
>> ?>
>> This is outside the lc section
>>
>> at http://dochawkbk.on-rev.com/test2.irev
>>
>> still yields
>> This is outside the lc section
>>
>> --
>> The Hawkins Law Firm
>> Richard E. Hawkins, Esq.
>> (702) 508-8462
>> hawkinslawf...@gmail.com
>> 3025 S. Maryland Parkway
>> Suite A
>> Las Vegas, NV  89109
>> ___
>> 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: more on-rev issues

[Alex Tweedly]

If you go into your browser's "View source" you'll see that it contains 
something like




This is outside the lc section

with the first 3 lines in some odd colour / format.
No idea how or why or what it means - I'd try re-typing and uploading again

-- Alex.


On 18/08/2012 20:52, Dr. Hawkins wrote:

On Sat, Aug 18, 2012 at 12:29 PM, Mike Bonner  wrote:


The source of the page is this: (after being sent by on-rev)


This is new text


Thanks, but that doesn't seem to do it:


This is outside the lc section

at http://dochawkbk.on-rev.com/test2.irev

still yields
This is outside the lc section



___
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: more on-rev issues

[Mike Bonner]

Hmm, out of curiosity, if you change it to  rather than  wrote:

> On Sat, Aug 18, 2012 at 12:29 PM, Mike Bonner  wrote:
>
> > The source of the page is this: (after being sent by on-rev)
> >
> > 
> > This is new text
> >
>
> Thanks, but that doesn't seem to do it:
>
>put "This is inside the lc section"
> ?>
> This is outside the lc section
>
> at http://dochawkbk.on-rev.com/test2.irev
>
> still yields
> This is outside the lc section
>
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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: more on-rev issues

[Alex Tweedly]

Not sure it should matter, but try omitting the space; i.e.
But even then, where does "this is new text" come from ? I wonder if 
your top-level directory on the site is pointed to a different directory 
from what you intend ? To check that, I'd suggest you try putting a 
.html file in your top level directory and see if it renders OK.


btw - I use on-rev all the time, and I use the on-rev client about once 
per month.
I use Coda2 (and sometime emacs + ftp) and find that much easier to deal 
with than the on-rev client.


-- Alex.

On 18/08/2012 20:19, Dr. Hawkins wrote:

This is getting more frustrating by the minute . . .

The On-rev standalone seems unstable, at best.  hitting a couple of arrow
keys to maneuver seems to knock it out of commission.  It didn't even occur
to me to check or ssh access.

Anyway, on-rev doesn't seem to be rendering .irev files as such; it's
simply ignoring them

The file

  
at http://dochawkbk.on-rev.com/mytest.irev

produces

This is new text





___
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: more on-rev issues

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 12:29 PM, Mike Bonner  wrote:

> The source of the page is this: (after being sent by on-rev)
>
> 
> This is new text
>

Thanks, but that doesn't seem to do it:


This is outside the lc section

at http://dochawkbk.on-rev.com/test2.irev

still yields
This is outside the lc section

-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: more on-rev issues

[Mike Bonner]

The source of the page is this: (after being sent by on-rev)


This is new text




Remove the space between ? and lc

On Sat, Aug 18, 2012 at 1:19 PM, Dr. Hawkins  wrote:

> This is getting more frustrating by the minute . . .
>
> The On-rev standalone seems unstable, at best.  hitting a couple of arrow
> keys to maneuver seems to knock it out of commission.  It didn't even occur
> to me to check or ssh access.
>
> Anyway, on-rev doesn't seem to be rendering .irev files as such; it's
> simply ignoring them
>
> The file
>
> put "Hello world."
>   ?>
> at http://dochawkbk.on-rev.com/mytest.irev
>
> produces
>
> This is new text
>
>
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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

more on-rev issues

[Dr. Hawkins]

This is getting more frustrating by the minute . . .

The On-rev standalone seems unstable, at best.  hitting a couple of arrow
keys to maneuver seems to knock it out of commission.  It didn't even occur
to me to check or ssh access.

Anyway, on-rev doesn't seem to be rendering .irev files as such; it's
simply ignoring them

The file

 
at http://dochawkbk.on-rev.com/mytest.irev

produces

This is new text


-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: changes to the runrev store

[Jérôme Rosat]

And check your charts. The chart in the store page is not the same than the 
chart in the get started page.

Could you also explain your upgrade/update policy because it's hard to find 
something on site ?

Thank you in advance.

Jerome

Le 18 août 2012 à 11:22, Kevin Miller  a écrit :

> Nothing has changed in the new store for existing customers, for any
> license type. The same pricing and upgrade policy applies. New customer
> continue to have access to all the same commercial licenses/upgrades plus
> new easy pay as you go options. We'll work on making the information
> clearer.
> 
> Kind regards,
> 
> Kevin
> 


___
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: remedial mysql???

[Peter Haworth]

You don't HAVE to remove the START/COMMIT, I was pointing out that they are
superfluous.  Leave them in if you wish.

The semicolon issue has nothing to do with what mySQL requires, it's a
Livecode requirement - see the dictionary.

Finally, if you're using revDataFromQuery to do this, I'm surprised it ever
worked.  You're not getting data from a query, you're executing SQL
commands so you need to use revExecuteSQL.

Pete
lcSQL Software 



On Sat, Aug 18, 2012 at 11:05 AM, Dr. Hawkins  wrote:

> MySQL explicitly supports the semicolons, the multi-line, and the
> START/COMMIT syntax.
>
> I have to remove *all* of these to get revDataFromQuery to work . . .
>
> This seems a bit . . . odd . . .
>
___
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: remedial mysql???

[Dr. Hawkins]

On Sat, Aug 18, 2012 at 10:38 AM, Peter Haworth  wrote:

> Assuming mySQL will accept multiple statements, I believe Livecode wants
> you to omit the semicolon statements at the end of each line.
>

And I thought that it was just sqlite tolerating the missing transactions .
. .


> Your START and COMMIT statements are superfluous in this case since SQL
> automatically wraps single statements in a transaction so I'd remove them
> and avoid whatever issue is causing the multi-line problem.
>

MySQL explicitly supports the semicolons, the multi-line, and the
START/COMMIT syntax.

I have to remove *all* of these to get revDataFromQuery to work . . .

This seems a bit . . . odd . . .

-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: remedial mysql???

[Peter Haworth]

Whoops, that should be "semicolon character at the end of each line".
Pete
lcSQL Software 



On Sat, Aug 18, 2012 at 10:38 AM, Peter Haworth  wrote:

> I believe Livecode wants you to omit the semicolon statements at the end
> of each line.
___
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: remedial mysql???

[Peter Haworth]

Assuming mySQL will accept multiple statements, I believe Livecode wants
you to omit the semicolon statements at the end of each line.

Your START and COMMIT statements are superfluous in this case since SQL
automatically wraps single statements in a transaction so I'd remove them
and avoid whatever issue is causing the multi-line problem.

Pete
lcSQL Software 



On Sat, Aug 18, 2012 at 10:13 AM, Dr. Hawkins  wrote:

> My code is designed to update the database automatically when new items are
> added to cards.  This was working fine with sqlite, although it was
> apparently ignoring some ' that shouldn't have been there.
>
> I'm even trying to group transactions now.
>
> However,
>
> START TRANSACTION;
> ALTER TABLE dna  ADD chrType CHAR(1);
> COMMIT;
>
> This, though, produces the error
>
> revdberr,You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'ALTER TABLE dna  ADD chrType CHAR(1);
> COMMIT' at line 2
>
> It's not that there is already such a variable:
>
> put revDatabaseColumnNames(getDebtordb(),"dna")
> yields
> uniqDna,dnaKey
>
> The documentation pages seem to show the same syntax
> athttp://dev.mysql.com/doc/refman/5.1/en/alter-table-examples.html
> :
>
> ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
>
> ALTER TABLE t2 ADD d TIMESTAMP;
>
>
> I must be missing something trivial at this point.
>
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> ___
> 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

remedial mysql???

[Dr. Hawkins]

My code is designed to update the database automatically when new items are
added to cards.  This was working fine with sqlite, although it was
apparently ignoring some ' that shouldn't have been there.

I'm even trying to group transactions now.

However,

START TRANSACTION;
ALTER TABLE dna  ADD chrType CHAR(1);
COMMIT;

This, though, produces the error

revdberr,You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'ALTER TABLE dna  ADD chrType CHAR(1);
COMMIT' at line 2

It's not that there is already such a variable:

put revDatabaseColumnNames(getDebtordb(),"dna")
yields
uniqDna,dnaKey

The documentation pages seem to show the same syntax
athttp://dev.mysql.com/doc/refman/5.1/en/alter-table-examples.html
:

ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);

ALTER TABLE t2 ADD d TIMESTAMP;


I must be missing something trivial at this point.

-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109
___
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: changes to the runrev store

[Andrew Kluthe]

After checking out this thread, I went to the store to have a look.
The chart with the green checkmarks is a puzzle that you can solve to
get a secret discount.

On Sat, Aug 18, 2012 at 7:54 AM, Thomas McGrath III
<3mcgr...@comcast.net> wrote:
> Yeah.. I even looked up perpetual in the dictionary to make sure I didn't 
> have the wrong meaning all these years. A footnote should be added  to that 
> item, I think.
>
> hmm…
>
> Thomas J McGrath III
> 3mcgr...@comcast.net
>
> Lazy River Software
> http://lazyriver.on-rev.com
>
>
>
>
>
> On Aug 18, 2012, at 3:53 AM, Monte Goulding  
> wrote:
>
>> Hmm... I was just looking at the table. Perpetual means forever to me and it 
>> says it includes updates. Perhaps thst should have s footnote... But i guess 
>> you cant buy until you see the subscription part.
>>
>> --
>> M E R Goulding
>> Software development services
>>
>> mergExt - There's an external for that!
>>
>> On 18/08/2012, at 4:58 PM, Warren Samples  wrote:
>>
>>> Although maybe I'm not reading Monte's response quite right... :D
>>
>> ___
>> 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



-- 
Regards,

Andrew Kluthe
and...@ctech.me

___
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

local helper application for remote database buffering

[Dr. Hawkins]

Aside from the "minor" issues of database creation and the web buffer
layer, I have my application talking to a remote server.

The lag, though, is quite noticeable, when tabbing from one field that
updates to another.

Would it make sense to stash the fields used on a card into a local
sqlite database, save to that, and have a second standalone monitoring
the buffer and doing the updates?  I know that I can simulate
multi-threading with a delayed message, but that's still going to
freeze up the interface when it happens, won't it?

-- 
The Hawkins Law Firm
Richard E. Hawkins, Esq.
(702) 508-8462
hawkinslawf...@gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109

___
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: PreOrder FieldTrip (100%)

[Curry Kenworthy]

Howdy FieldTrip Supporters,

Sorry about the silence! A health issue flared up again at the busiest 
moment and slowed me down, together with some urgent client tasks, and 
I've been catching up gradually.


Thanks for making FieldTrip possible. I'll have a prerelease ready very 
soon so that you can enjoy the new text formatting features! I'll be 
excited to see what people accomplish with it.


(Those who ordered at a higher level, be sure to let me know offlist 
your most desired features if you haven't already; I will devote the 
corresponding amount of time to those requests.)


Best wishes,

Curry K.


___
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

Multiple iOS scrollers scroll add the same time. How do I prevent this?

[William de Smet]

Hi there,

I have two iOS scrollers in my app on the same card.
They almost work fine. They do scroll and show content but two
scrollers scroll at the same time.
What do I have to do to prevent this?
Do I add the same code (different id) to scrollToTop and scrollerDidScroll

This my code:
on preOpencard
 iphoneControlCreate "scroller"
      put the result into scrollid2
      iphoneControlSet scrollid2, "rect", the rect of group "scrollGroup2"
      iphoneControlSet scrollid2, "contentRect", (0, 0, fldWidth, fldHeight)
      iphoneControlSet scrollid2, "visible", "true"
      iphoneControlSet scrollid2, "canBounce", "true"
      iphoneControlSet scrollid2, "declerationRate", "fast"
      iphoneControlSet scrollid2, "scrollingEnabled", "true"
      iphoneControlSet scrollid2, "canScrollToTop", "true"
      iphoneControlSet scrollid2, "canCancelTouches", "true"
      iphoneControlSet scrollid2, "delayTouches", "true"
      iphoneControlSet scrollid2, "vIndicator", "true"
      iphoneControlSet scrollid2, "indicatorStyle", "black"
      iphoneControlSet scrollid2, "indicatorInsets",  "0,0,0,0"
      iphoneControlSet scrollid2, "hscroll", 0
      iphoneControlSet scrollid2, "vscroll", 0

 iphoneControlCreate "scroller"
      put the result into scrollid3
      iphoneControlSet scrollid3, "rect", the rect of group "scrollGroup3"
      iphoneControlSet scrollid3, "contentRect", (0, 0, fldWidth, fldHeight)
      iphoneControlSet scrollid3, "visible", "true"
      iphoneControlSet scrollid3, "canBounce", "true"
      iphoneControlSet scrollid3, "declerationRate", "fast"
      iphoneControlSet scrollid3, "scrollingEnabled", "true"
      iphoneControlSet scrollid3, "canScrollToTop", "true"
      iphoneControlSet scrollid3, "canCancelTouches", "true"
      iphoneControlSet scrollid3, "delayTouches", "true"
      iphoneControlSet scrollid3, "vIndicator", "true"
      iphoneControlSet scrollid3, "indicatorStyle", "black"
      iphoneControlSet scrollid3, "indicatorInsets",  "0,0,0,0"
      iphoneControlSet scrollid3, "hscroll", 0
      iphoneControlSet scrollid3, "vscroll", 0
end preOpencard


on scrollerBeginDrag
   set the hilitedLine of fld 1 to empty
end scrollerBeginDrag

on scrollerScrollToTop
      iphoneControlSet scrollId2, "vscroll", 0
   iphoneControlSet scrollId3, "vscroll", 0  ???
end scrollerScrollToTop


on scrollerDidScroll hOffset, vOffset
    set the vScroll of group "scrollGroup2" to vOffset
   --- set the vScroll of group "scrollGroup3" to vOffset 
end scrollerDidScroll

greetings,

William

___
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: changes to the runrev store

[Thomas McGrath III]

Yeah.. I even looked up perpetual in the dictionary to make sure I didn't have 
the wrong meaning all these years. A footnote should be added  to that item, I 
think.

hmm…

Thomas J McGrath III
3mcgr...@comcast.net

Lazy River Software
http://lazyriver.on-rev.com





On Aug 18, 2012, at 3:53 AM, Monte Goulding  wrote:

> Hmm... I was just looking at the table. Perpetual means forever to me and it 
> says it includes updates. Perhaps thst should have s footnote... But i guess 
> you cant buy until you see the subscription part.
> 
> --
> M E R Goulding
> Software development services
> 
> mergExt - There's an external for that!
> 
> On 18/08/2012, at 4:58 PM, Warren Samples  wrote:
> 
>> Although maybe I'm not reading Monte's response quite right... :D
> 
> ___
> 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: changes to the runrev store

[René Micout]

Thank you, because that is not clear at all...

Le 18 août 2012 à 11:22, Kevin Miller  a écrit :

> Nothing has changed in the new store for existing customers, for any
> license type. The same pricing and upgrade policy applies. New customer
> continue to have access to all the same commercial licenses/upgrades plus
> new easy pay as you go options. We'll work on making the information
> clearer.

___
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: is anyone using postgresql hosting from on-rev?

[Pierre Sahores]

Deal with "n-tiers" security tasks is't that hard and has more to do with 
design than pure technical tasks

Here could be the main principles :

1.- the client app is used by a trustable user connected via login:pass and/or 
a session token that identifies the client application against the cgi/server
2.- the cgi/server just can't hear any untrusted connection (no token = exit to 
top)
3.- as long as the cgi/server receive a trustable POST/GET request, a couple 
"key-value" let the cgi/server know what kind of SQL request build and provide 
to the SQL server (the SQL request don't come from the client app over the 
internet connexion). At this point, a SQL lib alike SQLYoga can help to see how 
to go head even if all the needed functions/commands/messages are available 
from the standard Rev-Server and LC-Server (4.62/5.02)
4.- the SQL stuff is handled there and the response to the client POST/GET 
request is returned to the right sender (as pure unfishible data by anyone who 
would want to boomerang them against the server).

This kind of security design is the one to prefer in any saas services context. 
It can become by it self so rock solid that even SSL will not be able to add an 
useful security layer to a well-build n-tiers two levels strong authentication 
system.  Last but not least, LC is really very strong and usable in such kind 
of tasks.

PS : Any server connected to the public internet has to deal (as an average) 
with 7/12 months / year with cracking robots searching to get hand of them --> 
both servers and server hosted applications security really matters...

Le 18 août 2012 à 07:12, Dr. Hawkins a écrit :

> On Fri, Aug 17, 2012 at 8:14 PM, Peter Haworth  wrote:
>> The issue isn't less likely, you just have to be less smart than the
>> hackers who know how to hack into this stuff, and most of us are :-)
> 
> Yeah, that's what worries me.
> 
> I don't see how an intermediary layer that I or someone else writes
> increases security.
> 
> I *can* see how it increases deniability for the  host, though :)
> 
> -- 
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> 
> ___
> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.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: changes to the runrev store

[Kevin Miller]

Nothing has changed in the new store for existing customers, for any
license type. The same pricing and upgrade policy applies. New customer
continue to have access to all the same commercial licenses/upgrades plus
new easy pay as you go options. We'll work on making the information
clearer.

Kind regards,

Kevin

Kevin Miller ~ ke...@runrev.com ~ http://www.runrev.com/
LiveCode: Unleash Your Killer App




On 18/08/2012 10:07, "James Hale"  wrote:

>Well this is a tad confusing and inconsistent.
>The IOS PAYG package does not show desktop deployment in the table but
>does describe it in the blurb that is accessed when you click on the
>prices at the bottom of the table.
>Given it is an annual subs, I guess it means you always have access to
>the latest version.
>It also implies that if you stop paying the subscription, your copy
>ceases to work!
>OK
>The IOS Perpetual does not expire but also does not have any updates.
>
>I currently have the commercial desktop product.
>This cost me $118 to upgrade (renew?) earlier this year and I am assuming
>this was a... well I have no idea what it means actually, does it cover
>me for 5.5 dot releases or 12 months or what?
>
>In any case this is a perpetual license in that I can stay with this
>version as long as I like.
>
>If I am to believe the matrix on the home page of the store then my
>current product is only available as a perpetual license (with the IOS
>deployment thrown in). OK, but there are no updates available and no
>annual maintenance fee, as there is with the COMPLETE package.
>
>Indeed it seems that the COMPLETE package is the only non expiring option
>that has maintenance, albeit at $799 per annum.
>
>So in order to maintain my desktop development (Mac and Windows only) and
>have a non expiring development version it seems I need to pay $499 each
>time a new version comes out!
>
>Not happy.
>
>James
>___
>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: changes to the runrev store

[James Hale]

It also seems a personal license has gone the way of the Dodo too.
So much for hobbyists.

James

___
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: changes to the runrev store

[James Hale]

Well this is a tad confusing and inconsistent.
The IOS PAYG package does not show desktop deployment in the table but does 
describe it in the blurb that is accessed when you click on the prices at the 
bottom of the table.
Given it is an annual subs, I guess it means you always have access to the 
latest version.
It also implies that if you stop paying the subscription, your copy ceases to 
work!
OK
The IOS Perpetual does not expire but also does not have any updates.

I currently have the commercial desktop product.
This cost me $118 to upgrade (renew?) earlier this year and I am assuming this 
was a... well I have no idea what it means actually, does it cover me for 5.5 
dot releases or 12 months or what?

In any case this is a perpetual license in that I can stay with this version as 
long as I like.

If I am to believe the matrix on the home page of the store then my current 
product is only available as a perpetual license (with the IOS deployment 
thrown in). OK, but there are no updates available and no annual maintenance 
fee, as there is with the COMPLETE package.

Indeed it seems that the COMPLETE package is the only non expiring option that 
has maintenance, albeit at $799 per annum.

So in order to maintain my desktop development (Mac and Windows only) and have 
a non expiring development version it seems I need to pay $499 each time a new 
version comes out!

Not happy.

James
___
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: changes to the runrev store

[Monte Goulding]

Hmm... I was just looking at the table. Perpetual means forever to me and it 
says it includes updates. Perhaps thst should have s footnote... But i guess 
you cant buy until you see the subscription part.

--
M E R Goulding
Software development services

mergExt - There's an external for that!

On 18/08/2012, at 4:58 PM, Warren Samples  wrote:

> Although maybe I'm not reading Monte's response quite right... :D

___
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