Re: Regular Expressions in IDE

[Peter Haworth]

Try Thierry Douez's Regex library.

On Wed, Oct 26, 2016 at 10:38 AM Dr. Hawkins  wrote:

> On Wed, Oct 26, 2016 at 9:39 AM, Peter Reid  wrote:
>
> > Does anyone know where I can get guidance notes for the regular
> expression
> > find & replace in the IDE script editor.  In particular, what is the
> syntax
> > for using remembered groups in the replacement string.
>
>
> There is only a subset of what would be expected.
>
> I don't believe that there is any circumstance under which substitution
> works.
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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: Eureka Moment: preopencontrol

[Peter Haworth]

Not surer whether it applies to preopencontrol but I came across a message
path anomaly with open control a while back.  See QCC report 14091 (still
open)

On Mon, Oct 24, 2016 at 8:05 AM Sannyasin Brahmanathaswami 
wrote:

> Just discovered "preopencontrol"
>
> wow! I wish I had discovered this years ago.
>
> dictionary needs help.. there are complete "outs" as we refer to them in
> our editing world: missing words/phrases
>
> can someone please fill in the missing parts? They are mission critical
>
> --
> Sent to a group when you go to the
> card that contains it and to a [? ] when going
> from a card which it is not placed on to one where it is.
> --
> BR: OK , Obviously the missing word there is "group"
>
> but not so obvious here:
>
> 
> For groups with their [??]  set to true, the preOpenControl message is
> sent immediately after the [?]
> is sent to the card being opened. For non-background
> groups, it is sent after the  [??entire phrase missing here??]]
> ---
>
>
> ___
> 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: Bug report against lcStackBrowser

[Peter Haworth]

Yes, you're right.  They lost some size and resolution when I moved the
website to a new host a while back.  I plan on putting some new ones up
there soon, and some new videos.

On Mon, Oct 10, 2016 at 10:52 AM Peter Haworth <p...@lcsql.com> wrote:

> You had me worried for a minute there Richard!
>
> You're right, it goes far beyond browsing stacks, although when I first
> wrote it, that's what it was, just a replacement for the Application
> Browser.  But then it grew to incorporate Tools palette and Property
> Inspector equivalents, plus several other features that aren't in the
> standard IDE like saving stack versions and undoing object deletions.  I
> just never changed the name, mainly because I have close to zero marketing
> skills, including coming up with clever product names :)
>
> Anyway, thanks a lot for plug, much appreciated.
>
> On Mon, Oct 10, 2016 at 8:52 AM Richard Gaskin <ambassa...@fourthworld.com>
> wrote:
>
> Since this involves a third-party add-on for LiveCode, Peter Haworth's
> lcStackBrowser, I could report this bug privately to the author.  But I
> feel this is important for the community as a whole to be aware of so
> I'm taking the liberty of submitting this bug report here on this public
> list:
>
> Bug description:  The name "lcStackBrowser" is too modest.
>
> Recipe: Install it, explore it, poke around.
>
> Expected result:  It would provide a means of browsing objects in LC.
>
> Observed result: it goes WAY beyond that.  Sure, it also provide some
> very nice conveniences for browsing objects, but the true scope of the
> tool is so much deeper and feature-complete that it's almost like having
> an alternate IDE, one that delivers vast functionality and asks far less
> of your screen real estate in return.
>
> Clarence ran a demo of it at our local LC user group meeting last week,
> and lcStackBrowser is pretty awesome. There's a lot in it, all lovingly
> crafted in such detail as to be an uncommonly admirable plugin.
>
> Fine bit of work there, Peter.  Just that the name is misleading. :)
> It's far more than advertised.
>
> Definitely worth checking out:
> http://www.lcsql.com/lcstackbrowser.html
>
> --
>   Richard Gaskin
>   Fourth World Systems
>   Software Design and Development for the Desktop, Mobile, and the Web
>   
>   ambassa...@fourthworld.comhttp://www.FourthWorld.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: Bug report against lcStackBrowser

[Peter Haworth]

You had me worried for a minute there Richard!

You're right, it goes far beyond browsing stacks, although when I first
wrote it, that's what it was, just a replacement for the Application
Browser.  But then it grew to incorporate Tools palette and Property
Inspector equivalents, plus several other features that aren't in the
standard IDE like saving stack versions and undoing object deletions.  I
just never changed the name, mainly because I have close to zero marketing
skills, including coming up with clever product names :)

Anyway, thanks a lot for plug, much appreciated.

On Mon, Oct 10, 2016 at 8:52 AM Richard Gaskin 
wrote:

> Since this involves a third-party add-on for LiveCode, Peter Haworth's
> lcStackBrowser, I could report this bug privately to the author.  But I
> feel this is important for the community as a whole to be aware of so
> I'm taking the liberty of submitting this bug report here on this public
> list:
>
> Bug description:  The name "lcStackBrowser" is too modest.
>
> Recipe: Install it, explore it, poke around.
>
> Expected result:  It would provide a means of browsing objects in LC.
>
> Observed result: it goes WAY beyond that.  Sure, it also provide some
> very nice conveniences for browsing objects, but the true scope of the
> tool is so much deeper and feature-complete that it's almost like having
> an alternate IDE, one that delivers vast functionality and asks far less
> of your screen real estate in return.
>
> Clarence ran a demo of it at our local LC user group meeting last week,
> and lcStackBrowser is pretty awesome. There's a lot in it, all lovingly
> crafted in such detail as to be an uncommonly admirable plugin.
>
> Fine bit of work there, Peter.  Just that the name is misleading. :)
> It's far more than advertised.
>
> Definitely worth checking out:
> http://www.lcsql.com/lcstackbrowser.html
>
> --
>   Richard Gaskin
>   Fourth World Systems
>   Software Design and Development for the Desktop, Mobile, and the Web
>   
>   ambassa...@fourthworld.comhttp://www.FourthWorld.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: getting the "normal" messages when reopening a stack

[Peter Haworth]

Try putting the code in your preOpenStack handler into a separate handler
then call it from preOpenHandler and anywhere else you need to invoke it.

On Sat, Sep 24, 2016 at 6:05 PM J. Landman Gay 
wrote:

> On 9/24/16 4:19 PM, Dr. Hawkins wrote:
> > My user interface stacks are now made by cloning the respective stack, to
> > allow multiple open debtors, and multiple windows of each type in the
> > interface.
> >
> > I store the stem that identifies tables and windows in the dbtr_stem
> custom
> > property of the stack.
> >
> > I need to lock messages as I open the stack, as no setup routines even
> make
> > sense until this property exists and is accessible. Once clones, I set
> that
> > property, as well as the name (which depend on that property).  I then
> > close the new stack.
> >
> > Is there a way to send the "normal" messages, such as preopenstack and
> open
> > card when it opens.  I had assumed that closing the stack and reopening
> > would cause this to happen, but apparently not.
> >
> > These are transient stacks; they should never get saved to disk, and are
> > deleted as part of the process of closing a debtor.
> >
>
> A stack in RAM doesn't get the open* messages because, technically, it's
> already open. If you set the destroystack property to true, then the
> next time it opens the normal messages occur. But in this case that
> would delete your temporary clone, so you can't do that.
>
> You could specifically send the messages after you set up the properties:
>
> -- set up the clone, then:
> preOpenStack
> openStack
>
> or, depending on your stack organization, you might need to:
>
> send "preOpenStack to me" , etc.
>
> If you will be closing and reopening the stacks multiple times, you
> might trap for "resumeStack" instead.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.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: SQL joining from list of values to match single value?

[Peter Haworth]

Never a good idea to put lists of items into a single column.  If you need
that capability, best to define another table with uniqdna column as a
foreign key to your main table and a column to hold a single pardna, then
have 1 row for each uniqdna/pardna pair.  With thst structure the query is
just a matter of a simple join between the two tables.

On Thu, Sep 8, 2016 at 11:23 AM Mike Kerner 
wrote:

> I would make IS IN work, and do it in two queries, OR, in the case where
> you have something less than 10k values, just build a container and chunk
> it.  If that wasn't an option, I'd N:N it, and just add the extra tables
> and a join.
>
> On Thu, Sep 8, 2016 at 1:16 PM, Dr. Hawkins  wrote:
>
> > I've been trying to wrap my head around this query for weeks, and hope
> > someone can point out what I'm missing.
> >
> > In my table, the main key is uniqDna, an integer.  There can also be
> > dpdnDnas and parDnas, the uniqDna of a dependent or parent dna.
> >
> > I'm not seeking any good way to keep the dndDnas and parDnas fields other
> > than as space departed lists.
> >
> > I'm trying to find a sane way to SELECT upon values contained in one of
> > those lists.  (if there could only be one value, this would be trivial).
> >
> > The closest I'm seeing is making sure that there are spaces before and
> > after the list, so uniqDna 2 might have dpdDnas " 6 7 8 ", and then
> "SELECT
> > uniqDna, stuff FROM theTable WHERE parDnas LIKE '% 2 %'"--but this has to
> > be done one by one.
> >
> > What I'm looking for is something like
> >
> > "SELECT uniqDna, stuff, parDnas FROM theTABLE WHERE
> > some_other_entry.parDnas CONTAINS uniqDna"
> >
> > That is, a list of all the uniqDna that have parents, with there
> associated
> > parDnas
> >
> > As i understand it, IS IN () needs a list of literals, rather than
> another
> > query result.
> >
> > I'm looking at tables with dozens, not thousands, of entries.  Hundreds
> > *might* be conceivable as a rare case, but isn't a concern for general
> use.
> >
> > I'm assuming that some kind of JOIN might do this, but the problem still
> > remains of the operator to use to check for an integer value in one
> column
> > being one of the words in another . . .
> > --
> > Dr. Richard E. Hawkins, Esq.
> > (702) 508-8462
> > ___
> > 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
> >
>
>
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>and did a little diving.
> And God said, "This is good."
> ___
> 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: Wouldn't it be neat...

[Peter Haworth]

Thanks to Jacque for allowing me to use her code as the basis of doing this
in lcstackbrowser... But then you have to pay so would be much better in
the script editor as would many other editing features.

I've recently been using NetBeans for html and php script editing and
really like its features in that environment.

On Sat, Aug 20, 2016, 8:04 PM J. Landman Gay 
wrote:

> Yes, and add parentheses, curly brackets and square brackets too. Right now
> I'm doing these with a frontscript, which I can post when I'm back at the
> computer unless Pete does it first. My version screws up undo and his
> doesn't.
>
> But I'd rather have it built into the editor.
>
>
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.com
>
>
>
> On August 20, 2016 9:48:38 PM Monte Goulding  wrote:
>
> > Wouldn't it be better if typing quote when you have more than an
> insertion
> > point quoted around the selection?
> >
> > Sent from my iPhone
> >
> >> On 21 Aug 2016, at 12:38 PM, Roger Guay  wrote:
> >>
> >> If one could double-click a word in the script editor and then simply
> click
> >> a button to put it in quotes? Has anyone already done this? Yes, I know
> I
> >> can do Find and Replace, but this would definitely be the cat’s meow!
> >
> >
> > ___
> > 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: [SQL] placeholders work for SQLite but not for mySQL

[Peter Haworth]

SQLite is very forgiving about what data type it accepts for a column. It
will pretty much accept anything no matter what the defined data type is.
mySQL on the other hand rejects anything that doesn't match the declared
data type. That would explain the difference between the two systems.

It doesn't explain the difference between using a parameter vs an embedded
value, you should get the same result either way. I think you should submit
a bug report.

On Mon, Aug 8, 2016, 5:42 AM Ludovic THEBAULT 
wrote:

>
> > Le 8 août 2016 à 13:36, Kay C Lan  a écrit :
> > Unfortunately:
> >
> > put null into pValue
> >
> > worked fine for SQLite, but I still got the exact same mySQL ERROR =
> > Incorrect integer value: '' for column 'postcode' at row 1
> >
>
> After the revexecuteSQL do a :
> if pValue = empty then ## (or null)
> replace ":2" with "NULL" in tSQL
> end if
>
> ## where :2 is the placeholder which can be empty.
> ___
> 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

lcStackBrowser v 2.2.4 released

[Peter Haworth]

lcStackBrowser v2.2.4 is now available for download at
http://www.lcsql.com/lcstackbrowser.html.  This is a free upgrade for all
existing customers.

This is a bug fix release, in particular addressing several issues when
using lcStackBrowser in conjunction with Livecode v8.  The full release
notes can be found at  https://goo.gl/Xg6gpC
___
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: [ ANN ] Release 8.1.0 DP-3

[Peter Haworth]

Hi Charles,
Not a big deal but I'm wondering why the library stack for tsNet does not
have a name that begins with "rev".  There are a few other exceptions to
that convention but I don't recall any recent IDE stack additions that
weren't named that way.

On Tue, Aug 2, 2016 at 3:51 AM Charles Warwick <
char...@techstrategies.com.au> wrote:

> On 2/08/2016 5:25 am, J. Landman Gay wrote:
> > On 8/1/2016 12:41 AM, Charles Warwick wrote:
> >> You can issue post/get/put asynchronous commands even to the same server
> >> with the Indy license using tsNet commands directly
> >
> > Remind me, is "get url" blocking?
> >
> Yes :-)
>
> ___
> 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: A DataGrid is not a spreadsheet

[Peter Haworth]

+1

On Fri, Jul 29, 2016 at 2:15 PM Jerry Jensen  wrote:

> Hello Javier,
> You might like looking at Bernd Niggemann’s modTableField. Its a lot
> simpler than the dataGrid and very useful for many purposes. It has built
> in manual editing of cells and much more.
> http://berndniggemann.on-rev.com/modTableField/modTableField_0_3_2.zip
> Its free and well documented. I’m a happy user.
> .Jerry
>
> > On Jul 28, 2016, at 7:24 PM, Javier Miranda V. 
> wrote:
> >
> > Dear friends, is it safe to say that a data grid is not a spreadsheet? I
> mean, you can not create a new data grid and then just click in a empty
> cell and enter data.
> >
> > With some practice and reading documentation, I am able to populate a
> datagrid with data from a database, and using a Table field in situation in
> which the user must fill-in data seems limited.
> >
> >
> > Saludos,
> >
> > Javier Miranda V.
> > ___
> > 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: Backspace unrecoverably deletes an object ....

[Peter Haworth]

I can only offer a third party solution. My lcStackbrowser plugin remembers
all deleted objects (stacks, cards, controls) until you quit and you can
undo the delete of any of them from either a contextual menu or the
lcstackbrowser trash can icon.
Pete

On Wed, Jul 20, 2016 at 10:43 AM Francis Nugent Dixon 
wrote:

> Mac OS X 10.9.5 - LiveCode 5.5
>
> Hi from Beautiful Brittany,
>
> I’ve just  done it again !!! I created a button, loaded it up
> with thoughtful script, and, instead of hitting return to
> continue writing the script, , I wanderered around the
> stack, checking names, etc,, and later, without thinking,
> I hit “BackSpace” - and BING, an up and coming button
> and script hit the dust …….
>
> It is not the first time I lose a button and script because
> I can’t control my fingers.
>
> Why can’t I recover a button and script (after Select-Delete),
> or, if I can, how do I do it ? Other apps respond to “Undo”
> commands, even after a “Delete”. Why can’t LiveCode do
> the same?
>
> Solutions, perhaps ??
>
> -Francis
>
>
> ___
> 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

the templateControl

[Peter Haworth]

When clicking an icon in the property inspector for a Navigation Bar
widget, a newControl message is sent for the id "widget id 1002 of stack
"Popup Widget" of the templateControl".

I can't find an entry for templateControl in the dictionary. I'm also
confused as to how a stack can be owned by anything other than another
stack or a stack file.

Finally, does anyone know of a way to reliable identify an IDE stack these
days?  Used to be they began with "rev" or "com.livecode" but "Pop Widget"
doesn't follow any of those conventions.
___
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 version of lcStackbrowser Released

[Peter Haworth]

Sorry, yes there's an "l" missing at the end. The correct url also appears
further down the email.

On Thu, Jun 30, 2016, 4:33 AM Colin Holgate <colinholg...@gmail.com> wrote:

> His version has an ‘l’ at the end:
>
> http://www.lcsql.com/lcstackbrowser.html <
> http://www.lcsql.com/lcstackbrowser.html>
>
>
> > On Jun 30, 2016, at 7:30 AM, ** Clarence P Martin ** <
> chi...@themartinz.com> wrote:
> >
> > Peter,
> > The link that was provided: www.lcsql.com/lcstackbrowser.htm is not
> working.
> >
> > Sincerely,
> >
> > Clarence Martin
> > Email: chi...@themartinz.com
> > Cell: 626 6965561
> >
> > -Original Message-
> > From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On
> Behalf
> > Of Peter Haworth
> > Sent: Wednesday, June 29, 2016 4:11 PM
> > To: How to use LiveCode <use-livecode@lists.runrev.com>
> > Subject: New version of lcStackbrowser Released
> >
> > Version 2.2.3 of lcStackbrowser is now available for download at
> > www.lcsql.com/lcstackbrowser.htm.
> >
> > The release notes are available at https://goo.gl/Xg6gpC
> >
> > lcStackbrowser is  a plugin alternative to the Livecode IDE Application
> > Browser, Project Browser, and Tools palette and is compatible with
> Livecode
> > 8.  A fully functional 30-day trial is available at
> > http://www.lcsql.com/lcstackbrowser.html
> > ___
> > 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
___
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: Storing and retrieving data from a SQL database

[Peter Haworth]

Glad you figured it out Paul.

I'll check out the SQLiteAdmin problem.

On Sun, May 22, 2016 at 7:48 AM Paul Dupuis <p...@researchware.com> wrote:

> On 5/20/2016 10:38 PM, Peter Haworth wrote:
> > Tabs shouldn't be a problem so I suspect something else.
> >
> > Have you tried using LC to select the data after updating it?  As
> mentioned
> > in an earlier post, if you use revDataFromQuery to do the SELECT, be sure
> > to use something other than tab/return for the column/row delimiters.
>
> There was a bug in my code (typo in a variable name). Query parameters
> do handle tabs just fine.
>
> Thank you for walking me through the move to using parametrized queries.
> I've been doing SQL in Livecode for ... many years .. but never tried
> query parameters before.
>
> > I'm wondering if whatever program you used to "directly check" the data
> has
> > a problem with the tabs (fingers crossed it wasn't SQLiteAdmin!).
>
> I am using SQLiteAdmin 1.3.6 (and generally love the tool!). I did just
> notice, when using it to help debug this issue, that I could not paste
> text from the clip board into a field when entering a new record.
>
>
>
> ___
> 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: Storing and retrieving data from a SQL database

[Peter Haworth]

Tabs shouldn't be a problem so I suspect something else.

Have you tried using LC to select the data after updating it?  As mentioned
in an earlier post, if you use revDataFromQuery to do the SELECT, be sure
to use something other than tab/return for the column/row delimiters.

I'm wondering if whatever program you used to "directly check" the data has
a problem with the tabs (fingers crossed it wasn't SQLiteAdmin!).

Pete

On Fri, May 20, 2016 at 6:33 PM Paul Dupuis  wrote:

> Apparently, you either DO need to escape certain characters even when
> using parametrized queries.
>
> I have the code below: I pass it an array where the description
> pArray[7] contains several lines of text from a field and the second
> line contains a tab
>
> command updateInDatabase pArray
>   --
>
> pArray[1]=ID,[2]=Name,[3]=Type,[4]=Topic,[5]=Subtopic,[6]=Duration,[7]=Description,[8]=Source
>   put the databaseID of this stack into tDatabaseID
>   put "UPDATE mytable SET
> name=:2,type=:3,topic=:4,subtopic=:5,duration=:6,description=:7,source=:8
> WHERE
> id=:1" into tQuery
>   revExecuteSQL tDatabaseID,tQuery,"pArray"
>   get the result
>   if it is not a number then
> -- error
> put it
>   else
> -- number of rows changed
>   end if
> end updateInDatabase
>
> This executes and indicates a row was update in the database and a
> direct check of the SQLite database shows that columns were updated
> EXCEPT for description where any content that was in pArray[7] AFTER and
> including the TAB is missing. So apparently TABs can not be included in
> data passed by parameters.
>
> OR is this a LiveCode 8 bug?
>
> ___
> 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: Storing and retrieving data from a SQL database

[Peter Haworth]

No substitution or escaping involved, although the dictionary makes
constant reference to to substitution which is misleading.

I think it's worth a short explanation of what goes on behind the scenes.

Although executing an sql statement in lc is just one call, it's multiple
calls to the sql library routines.

Prepare
The statement is analyzed and decisions such as which indexes to use are
made.  The statement isn't executed at this point.

Bind
The data in the variables/array you provide  is linked to the placeholders
in the statement as pointers, not substituted into the statement.

Execute
The statement is executed.

The bind and execute steps can be repeated without going through the
prepare step, providing some performance improvements, although lc doesn't
allow us to do that.

Using parameterized queries removes the need for any escaping and protects
you against some forms of SQL injection attacks. I'm not sure why people
don't use them more, but one reason is that the dictionary just lays out
their availability without explaining why it's important to use them.

On Thu, May 19, 2016, 9:02 AM Mike Kerner  wrote:

> No, it won't escape it, and it won't just substitute it.
>
> Substitution would be
> put "INSERT INTO myTable VALUES("&")"
>
> If you were to use substitution in a query, you would have to put quotes
> around the contents of variable1 and variable2 before you passed them or
> they wouldn't go at all (and if there are quotes, etc. in those containers,
> you're really hosed).
>
> If you use parameterized query, and variable1 is
> "Hello, my friend," he said.
>
> Then the value of the field in the table will be
> "Hello, my friend," he said.
>
> When you retrieve the value, you'll get it as-is.  When you perform a query
> against the table, you would send the literal string that you are looking
> for, also with parameters, including the quotes, semicolons, etc.
>
>
>
> On Thu, May 19, 2016 at 11:41 AM, Paul Dupuis 
> wrote:
>
> > On 5/19/2016 10:41 AM, Mike Kerner wrote:
> > > Remember the conversations about handling CSV?  All I will tell you
> from
> > > escaping data for SQL is...good luck.  I accidentally discovered SQL
> > > injection (as did everyone else, I'm sure) 30 years ago when C/S was
> just
> > > getting legs.  Since then, we have yet to come up with an escaping
> scheme
> > > that doesn't break down, eventually.  In simple or special cases, you
> > will
> > > be able to make it work, but understand going in that someone is going
> to
> > > break it for you.  When they do, hopefully they don't
> > > accidentally/intentionally break the rest of your system.  When
> possible,
> > > use parameterized queries, instead.
> > >
> >
> > To be more precise, several fields in a table are TEXT and the intended
> > data is large amounts of free form text (contents of documents). There
> > is no concern in this context of SQL injection by altering the contents
> > of the target documents. The concern is that the documents - being
> > documents - contain tabs and end of line characters and single quotes
> > and double quotes and any other type-able character you may find in the
> > English language.
> >
> > Mike and Peter: So you're both saying that if I use either:
> >
> > revExecuteSQL myID, "insert into mytable values(:1,:2)",
> > "Variable1","Variable2"
> > OR
> > revExecuteSQL myID,"insert into mytable values(:1,:2)","myArray"
> > where myArray[1] has the content for the first column and myArray[2] for
> > teh second column in the table
> >
> > That the revExecuteSQL command will escape the data in Variable1 or
> > myArray[1] even if it contains returns and tabs and single and double
> > quotes and so on?
> >
> > I had though that it just did substitution. I.e. it effectively just
> > replaced the :1 in the query with the contents of the variable, so for a
> > VarChar, Char, or Text column in the database, Variable1 would have to
> > contain 'some text' in single quotes. I would be happy if my assumption
> > is completely wrong.
> >
> >
> >
> > ___
> > 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
> >
>
>
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>and did a little diving.
> And God said, "This is good."
> ___
> 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 

Re: Clearing local variables

[Peter Haworth]

lcStackbrowser has a feature that adds comments to each end xxx statement
identifying it's parent, part of the script assist module.

I think named ifs, repeats, etc would be great on the context of being able
to exit out of nested instances of those structures to whatever level you
want.

On Fri, Apr 29, 2016, 6:19 PM Dr. Hawkins  wrote:

> On Fri, Apr 29, 2016 at 5:40 PM, Alex Tweedly  wrote:
>
> > Do you simply want to *see with certainty", or do you want to use these
> > tags (e.g. for exiting a control structure) ?
> >
> >
> Both, actually.  Exiting an outer loop from within an inner  takes
> contortions, but figuring out which end is attached to which if or repeat
> is time consuming.
>
>
>
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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: Error: Unable to open the database file

[Peter Haworth]

Gave that a whirl with col4=? and a bind parameter of "*" OR 1=1 for it and
it returned no data.  Pretty sure it takes the whole string as a search
value for col4.



On Thu, Apr 7, 2016 at 7:19 PM Mark Wieder <mwie...@ahsoftware.net> wrote:

> On 04/07/2016 06:41 PM, Peter Haworth wrote:
> > Right, I think I have that covered since I prepare and bind the data in
> > separate steps using the php functions for those purposes.
> >
> > So instead of assembling a SELECT statement like this:
> >
> > SELECT col1,col2,col3 FROM table WHERE col4=''
> >
> > ... and then executing it directly, I prepare this statement:
> >
> > SELECT col1,col2,col3 FROM table WHERE col4=?
> >
> > ...and then bind the supplied user data to the ? placeholder.  Any
> injected
> > data for the col4 value is treated as part of the value to be searched
> for
> > in col4 rather than an extension of the SELECT statement.
>
> ... WHERE col4='*' or 1=1;
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.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: Error: Unable to open the database file

[Peter Haworth]

Right, I think I have that covered since I prepare and bind the data in
separate steps using the php functions for those purposes.

So instead of assembling a SELECT statement like this:

SELECT col1,col2,col3 FROM table WHERE col4=''

... and then executing it directly, I prepare this statement:

SELECT col1,col2,col3 FROM table WHERE col4=?

...and then bind the supplied user data to the ? placeholder.  Any injected
data for the col4 value is treated as part of the value to be searched for
in col4 rather than an extension of the SELECT statement.

That's why is it is so important to use the variableslist parameter of the
LC DB functions if you are connecting directly to a database server.

At least I think that's how it works



On Thu, Apr 7, 2016 at 4:31 PM Dr. Hawkins <doch...@gmail.com> wrote:

> On Wed, Apr 6, 2016 at 1:03 PM, Peter Haworth <p...@lcsql.com> wrote:
>
> > Now you've got me worried!  I had the impression that since the php
> scripts
> > run on my server and access the mySQL database on the same server, there
> > wouldn't be any sql injection issues, particularly since I never send any
> > SQL statements from my client app to the server.
> >
>
> In the middle of the text, a user puts something like
>
> '; || SELECT * FROM fizzbin ;DROP TABLE fizz bin; SELECT '
>
>
> I've probably hacked up the syntax, and there might be an intermediate
> query needed to get the table name, but something like this grabs all your
> data and deletes it while you thought you were doing an INSERT or such.
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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: Error: Unable to open the database file

[Peter Haworth]

I just can't be bothered replying to that...

On Wed, Apr 6, 2016 at 1:55 PM Mark Wieder <mwie...@ahsoftware.net> wrote:

> On 04/06/2016 01:03 PM, Peter Haworth wrote:
>
> > I'm just as lazy as the next developer
>
> Oh, I could probably give you a run for your money in the lazy race any
> day. 
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.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: Error: Unable to open the database file

[Peter Haworth]

Hi Mark,
Now you've got me worried!  I had the impression that since the php scripts
run on my server and access the mySQL database on the same server, there
wouldn't be any sql injection issues, particularly since I never send any
SQL statements from my client app to the server.

I'm just as lazy as the next developer but if I'm setting myself up for
securoty issues, I guess I could reluctantly bring myself to fix the
loopholes :-)


On Wed, Apr 6, 2016 at 12:57 PM Peter Haworth <p...@lcsql.com> wrote:

> This is where it gets interesting.  My original plan was to directly
> connect to mySQL from Livecode using the variableslist parameter to the
> various Livecode db functions, which should protect against sql injection.
> To be honest, I don't recall why I went away from that plan in favor of
> middleware.
>
> Most web hosts will have a cPanel option to set up a mySQL database,
> usually using phpMyAdmin and it's pretty straightforward if you are already
> familiar with db structures.
>
> The only wrinkle I remember is that you have to specify for each db user
> which hosts they can connect from in terms of an ip address or domains.
>
> In fact, I think that's what decided me on using middleware since then all
> the db access is from your web hosts domain, thus one entry in the
> allowable hosts table.  In my case, my users were scattered across various
> domains and all had dynamic ip addresses so it would have a been a pain to
> keep all that up to date.
>
> I got a great start on the middleware scripts by downloading Bill's
> library (thanks Bill).
>
> Pete
>
>
> On Wed, Apr 6, 2016 at 10:35 AM Ray <r...@linkit.com> wrote:
>
>> Yeah, my expectation is that we'll avoid injection issues using the PHP
>> middleware.
>>
>> All in all, it seems like a pretty common need; to store on a server a
>> database that multiple users are going to be updating.  I wish there
>> were some sort of a Livecode lesson which detailed several approaches to
>> this including the necessary steps to set up the database on the remote
>> server.  Do you know of any?
>>
>> On 4/6/2016 12:42 PM, Peter Haworth wrote:
>> > Hi Ray,
>> > Lots of things for you to think about!  As someone else mentioned, I
>> > thought you were using a network file system rather than a web server.
>> >
>> > Just to set the record straight on a couple of things.
>> >
>> > mySQL does have transactions, as do all SQL implementations.  They're
>> part
>> > of the SQL spec.  postGresql may well have advantages over mySQL but
>> that
>> > isn't one of them.
>> >
>> > It's quite feasible to implement multi-user sqlite applications.  There
>> are
>> > several examples on the SQLite web site and in fact their website is
>> driven
>> > by an sqlite database.  Of course it depends on the needs of the
>> > application, as it always does.
>> >
>> > There are many ways to handle queuing of db access when the db is
>> locked.
>> > There's a PRAGMA that controls how long the lock request should wait
>> before
>> > reporting it can't get the lock.  It's easy to program that yourself in
>> a
>> > repeat loop/send in time structure too.
>> >
>> > I started a thread a few months back about direct calls to server-based
>> SQL
>> > databases from Livecode versus middleware which generated a lot of
>> possible
>> > approaches.  I ended up going the middleware route using php scripts.
>> My
>> > Livecode app uses the POST command to send a code that indicates to the
>> > server which SQL operation is to be executed along with all the data
>> needed
>> > to execute it.  No SQL statements ever go over the connection so no sql
>> > injection issues. That's just one possible implementation of course and
>> > there are many other ways to do it.
>> >
>> > Good luck!
>> >
>> > On Wed, Apr 6, 2016 at 8:32 AM Ray <r...@linkit.com> wrote:
>> >
>> >> Richard - thanks for this advice.  It's really quite helpful.  We've
>> >> abandoned the sqLite idea but I think mySQL should work fine.  The
>> >> purpose of this database is to maintain an index of bug reports. The
>> bug
>> >> reports themselves are actually Livecode stacks.  The database will
>> >> serve as an index to all bug reports.  The plan is to have just single
>> >> table of about four columns; username, bug name, date, and status.
>> >> Hopefully it will stay this simple.
>> >>
>> >> Since we'll be

Re: Error: Unable to open the database file

[Peter Haworth]

This is where it gets interesting.  My original plan was to directly
connect to mySQL from Livecode using the variableslist parameter to the
various Livecode db functions, which should protect against sql injection.
To be honest, I don't recall why I went away from that plan in favor of
middleware.

Most web hosts will have a cPanel option to set up a mySQL database,
usually using phpMyAdmin and it's pretty straightforward if you are already
familiar with db structures.

The only wrinkle I remember is that you have to specify for each db user
which hosts they can connect from in terms of an ip address or domains.

In fact, I think that's what decided me on using middleware since then all
the db access is from your web hosts domain, thus one entry in the
allowable hosts table.  In my case, my users were scattered across various
domains and all had dynamic ip addresses so it would have a been a pain to
keep all that up to date.

I got a great start on the middleware scripts by downloading Bill's library
(thanks Bill).

Pete

On Wed, Apr 6, 2016 at 10:35 AM Ray <r...@linkit.com> wrote:

> Yeah, my expectation is that we'll avoid injection issues using the PHP
> middleware.
>
> All in all, it seems like a pretty common need; to store on a server a
> database that multiple users are going to be updating.  I wish there
> were some sort of a Livecode lesson which detailed several approaches to
> this including the necessary steps to set up the database on the remote
> server.  Do you know of any?
>
> On 4/6/2016 12:42 PM, Peter Haworth wrote:
> > Hi Ray,
> > Lots of things for you to think about!  As someone else mentioned, I
> > thought you were using a network file system rather than a web server.
> >
> > Just to set the record straight on a couple of things.
> >
> > mySQL does have transactions, as do all SQL implementations.  They're
> part
> > of the SQL spec.  postGresql may well have advantages over mySQL but that
> > isn't one of them.
> >
> > It's quite feasible to implement multi-user sqlite applications.  There
> are
> > several examples on the SQLite web site and in fact their website is
> driven
> > by an sqlite database.  Of course it depends on the needs of the
> > application, as it always does.
> >
> > There are many ways to handle queuing of db access when the db is locked.
> > There's a PRAGMA that controls how long the lock request should wait
> before
> > reporting it can't get the lock.  It's easy to program that yourself in a
> > repeat loop/send in time structure too.
> >
> > I started a thread a few months back about direct calls to server-based
> SQL
> > databases from Livecode versus middleware which generated a lot of
> possible
> > approaches.  I ended up going the middleware route using php scripts.  My
> > Livecode app uses the POST command to send a code that indicates to the
> > server which SQL operation is to be executed along with all the data
> needed
> > to execute it.  No SQL statements ever go over the connection so no sql
> > injection issues. That's just one possible implementation of course and
> > there are many other ways to do it.
> >
> > Good luck!
> >
> > On Wed, Apr 6, 2016 at 8:32 AM Ray <r...@linkit.com> wrote:
> >
> >> Richard - thanks for this advice.  It's really quite helpful.  We've
> >> abandoned the sqLite idea but I think mySQL should work fine.  The
> >> purpose of this database is to maintain an index of bug reports. The bug
> >> reports themselves are actually Livecode stacks.  The database will
> >> serve as an index to all bug reports.  The plan is to have just single
> >> table of about four columns; username, bug name, date, and status.
> >> Hopefully it will stay this simple.
> >>
> >> Since we'll be updating an entire record at a time I don't think the
> >> lack of dependency will ever be a problem, but let me know what you
> think.
> >>
> >> Thanks,
> >>
> >> Ray
> >>
> >> On 4/6/2016 11:14 AM, Dr. Hawkins wrote:
> >>> On Wed, Apr 6, 2016 at 6:05 AM, Ray <r...@linkit.com> wrote:
> >>>
> >>>> I thought of downloading it, updating it, and then putting it back on
> >> the
> >>>> server but that wouldn't work if two users simultaneously did so.
> Since
> >>>> I'll have many users using the database simultaneously everything has
> >> to be
> >>>> done on the server.  I know only one user can write to an sqLite
> >> database
> >>>> at a time, but that only takes about 20 milliseconds if done on the
> >> ser

Re: Error: Unable to open the database file

[Peter Haworth]

I do remember a post from you about not being able to send multiple
statements to SQL in one Livecode call, and also I'm pretty sure it was
confirmed. so that's probably what you're thinking of.


On Wed, Apr 6, 2016 at 10:17 AM Dr. Hawkins <doch...@gmail.com> wrote:

> On Wed, Apr 6, 2016 at 9:42 AM, Peter Haworth <p...@lcsql.com> wrote:
>
> >
> > mySQL does have transactions, as do all SQL implementations.  They're
> part
> > of the SQL spec.  postGresql may well have advantages over mySQL but that
> > isn't one of them.
> >
>
> Now I'm trying to remember: is it that livecdoe that can't successfully
>  pass a compound command to mySQL?
>
> So that BEGIN, each command, and END each take a separate live code
> command?  That turns it into a brutal multiplier for a remote database, and
> one to watch on a local.
>
> I remember that mySQL was a flat-out deadend for me; I started with it when
> I realized that SQLite wasn't going to do it for the remote.
>
> Tje more I think about it, the more I think it's live code's
> implementation; maybe that is getting fixed in 8.
>
>
> > It's quite feasible to implement multi-user sqlite applications.  There
> are
> > several examples on the SQLite web site and in fact their website is
> driven
> > by an sqlite database.  Of course it depends on the needs of the
> > application, as it always does.
> >
>
> "SQLite does not compete with client/server databases. SQLite competes with
> fopen()."
> from https://www.sqlite.org/whentouse.html
>
>
> I'm going to be going the middleware route myself, but i'm not switching
> until everything else is done.
>
> I'm dealing with the presumption of multiple users accessing the same
> "case" at once--at least the lawyer's desk, secretary's computer, and the
> lawyer from court.
>
> At the moment, I periodically (about 30 seconds) send a transaction to the
> server with all of the updates that also scoops back any updates from the
> remote.   I don't need to worry about inconsistencies from users, and can
> simply use the latest value entered, without regard to whether there was an
> earlier unknown change (If Beth enters $20,000 for income, and Sarah enters
> $30,000, the office or data has bigger problems than I can solve).
>
> I very briefly synched each transaction as it occurred using remote mySQL;
> this was  brutally slow as each changed variable causes a cascade of it's
> dependencies; it was a noticeable fraction of a second to tab to the next
> field . . . (kind of like tabs in the IDE when you have multiple large
> scripts . . .)
>
> While I could stay with the current method for the distributed product once
> the ssl postgres is implemented, there are enough advantages to me for a
> persistent server that I'll still switch.   In particular, it lets me go
> asynchronous:  the client program writes and forgets, eliminating most of
> the transactions it initiates, and receives messages from the server on the
> socket when something changes at that end (which would always follow
> shortly after its own transmission).  The server on a VPS or even dedicated
> server simply watches the open sockets on a round robin basis, and writes
> back any changes (or, potentially other messages) to the client.
>
>
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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: Error: Unable to open the database file

[Peter Haworth]

Hi Ray,
Lots of things for you to think about!  As someone else mentioned, I
thought you were using a network file system rather than a web server.

Just to set the record straight on a couple of things.

mySQL does have transactions, as do all SQL implementations.  They're part
of the SQL spec.  postGresql may well have advantages over mySQL but that
isn't one of them.

It's quite feasible to implement multi-user sqlite applications.  There are
several examples on the SQLite web site and in fact their website is driven
by an sqlite database.  Of course it depends on the needs of the
application, as it always does.

There are many ways to handle queuing of db access when the db is locked.
There's a PRAGMA that controls how long the lock request should wait before
reporting it can't get the lock.  It's easy to program that yourself in a
repeat loop/send in time structure too.

I started a thread a few months back about direct calls to server-based SQL
databases from Livecode versus middleware which generated a lot of possible
approaches.  I ended up going the middleware route using php scripts.  My
Livecode app uses the POST command to send a code that indicates to the
server which SQL operation is to be executed along with all the data needed
to execute it.  No SQL statements ever go over the connection so no sql
injection issues. That's just one possible implementation of course and
there are many other ways to do it.

Good luck!

On Wed, Apr 6, 2016 at 8:32 AM Ray  wrote:

> Richard - thanks for this advice.  It's really quite helpful.  We've
> abandoned the sqLite idea but I think mySQL should work fine.  The
> purpose of this database is to maintain an index of bug reports. The bug
> reports themselves are actually Livecode stacks.  The database will
> serve as an index to all bug reports.  The plan is to have just single
> table of about four columns; username, bug name, date, and status.
> Hopefully it will stay this simple.
>
> Since we'll be updating an entire record at a time I don't think the
> lack of dependency will ever be a problem, but let me know what you think.
>
> Thanks,
>
> Ray
>
> On 4/6/2016 11:14 AM, Dr. Hawkins wrote:
> > On Wed, Apr 6, 2016 at 6:05 AM, Ray  wrote:
> >
> >> I thought of downloading it, updating it, and then putting it back on
> the
> >> server but that wouldn't work if two users simultaneously did so.  Since
> >> I'll have many users using the database simultaneously everything has
> to be
> >> done on the server.  I know only one user can write to an sqLite
> database
> >> at a time, but that only takes about 20 milliseconds if done on the
> server
> >> and the other writes get cued, something that wouldn't happen in the
> >> download/re-upload scenario.
> >>
> > You are going past what SQLite is meant to handle, and asking for
> trouble.
> >
> > When SQLite writes, it changes a patch of disk (I couldn't tell you how
> > much).
> >
> > The other users won't be queued up waiting to write; they'll be getting
> > failure to open.
> >
> > You're either going to need a persistent middleware app running on the
> > server, or to follow the advice of the SQLite team:  use postgres for
> > something like this.
> >
> > SQLite is wonderful, but it also knows it's limits.  I use it in-memory,
> > and as a convenient way to throw backup files.
> >
> > And depending upon what you're doing, mySQL may not be an appropriate
> > choice.  In particular, it doesn't handle real transactions.
> >
> > SQLite and postgres can handle
> >
> > BEGIN TRANSACTION;
> >
> > SELECT this from that;
> >
> > UPDATE that WITH thisstuff;
> >
> > UPDATE somethingElse WITH that
> >
> > END TRANSACTION;
> >
> >
> > whereas mySQL would do this as separate SELECT and  two UPDATEs
> >
> > If you need either all or none of them to happen (e.g., dependencies and
> > consistency), mySQL is not your choice.
> >
> > postgres also means a single 20ms transaction for such things, while
> mySQL
> > would be three separate 20ms transactions.
> >
> >
>
>
> ___
> 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: Error: Unable to open the database file

[Peter Haworth]

I suppose I should also mention the usual caveat about using sqlite over a
networked file system, which is that sqlite relies on file system locking
to preserve data integrity and some networked file systems are buggy in
that area according to the sqlite website.

On Tue, Apr 5, 2016, 3:57 PM Ray <r...@linkit.com> wrote:

> Peter - thanks for jumping in here.  Yes, I can read and write files to
> this location and, as a matter of fact, I can even do a straight read of
> the database file on the server and get the same cryptic characters back
> I get when I read the local copy.  I just can't establish a connection
> to it for the purpose of issuing revDatabase calls.
>
> You're right when you say the "unable to open the database file" is not
> very informative.  I get the same message when I try that on an empty
> path on the server.
>
> I'll try your sqLite3 suggestion and let you know how it works.
>
> Thanks!
>
> On 4/5/2016 6:34 PM, Peter Haworth wrote:
> > You might want to try opening the database with something other than
> > Livecode in hope that you will get a more informative error message.
> >   sqlite3 is the official sqlite command line tool.  It's distributed
> with
> > OSX but not sure if it's included with Windows.
> >
> > Are you able to access any other files in the same directory as the
> sqlite
> > db?
> >
> > On Tue, Apr 5, 2016 at 1:31 PM Ray <r...@linkit.com> wrote:
> >
> >> Devin - thanks for the idea but that's not it.  I just checked and
> >> everything on my Windows 8.1 system matches case with the database file
> >> path on the Linux server.  I even tried changing the name of the
> >> database file to all lower case but that didn't work either. Thanks...
> >>
> >> On 4/5/2016 3:38 PM, Devin Asay wrote:
> >>> Ray,
> >>>
> >>> You may have moved your DB file from a system that is not case
> >> sensitive, like MacOS, to one this is case sensitive, like Linux. Do
> all of
> >> your folders and file names have the same exact spelling, including
> upper
> >> and lower case letters, as the string in your path variable?
> >>> Devin
> >>>
> >>>
> >>>> On Apr 5, 2016, at 12:39 PM, Ray <r...@linkit.com> wrote:
> >>>>
> >>>> ...one other note.  I'm guessing calls to sqLite need drivers. These
> >> drivers are probably built in to Livecode and the OnRev server which
> would
> >> explain why LC's database commands works so well locally and with the
> OnRev
> >> based samples.
> >>>> If this is the problem, does anybody know how I could install these
> >> drivers on my own server?
> >>>> On 4/5/2016 1:18 PM, Ray wrote:
> >>>>> I've never worked with sqLite databases before but it appears I
> should
> >> be able to access one on a server pretty much the same as I do locally.
> >>>>> Here's what I've done:
> >>>>> put revOpenDatabase("sqLite",localPath) into theDbId
> >> -- this creates a zero K local database file
> >>>>> put "CREATE TABLE bugs(Name char(50), Date char(50))" into
> myQuery
> >>>>> revExecuteSQL theDbId,myQuery -- the local database file is no 2
> K
> >>>>>
> >>>>> revCloseDatabase theDbId -- close it or I won't be able to copy
> it
> >> to the server
> >>>>> I then copy the local database file to a remote server and make sure
> >> all 9 permissions are checked (777).
> >>>>> I now load the well-tested server path into the variable dbPath and
> >> try this:
> >>>>> put revOpenDatabase("sqLite",dbPath) into myResult
> >>>>>
> >>>>> but all I get back is:
> >>>>> Error: Unable to open the database file
> >>>>>
> >>>>> Suggestions?
> >>>> ___
> >>>> 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
> >>> Devin Asay
> >>> Office of Digital Humanities
> >>> Brigham Young University
> >>>
> >>>
> >>> ___
> >>> use-livecode mailing list
> >>> use-livecod

Re: Error: Unable to open the database file

[Peter Haworth]

You might want to try opening the database with something other than
Livecode in hope that you will get a more informative error message.
 sqlite3 is the official sqlite command line tool.  It's distributed with
OSX but not sure if it's included with Windows.

Are you able to access any other files in the same directory as the sqlite
db?

On Tue, Apr 5, 2016 at 1:31 PM Ray  wrote:

> Devin - thanks for the idea but that's not it.  I just checked and
> everything on my Windows 8.1 system matches case with the database file
> path on the Linux server.  I even tried changing the name of the
> database file to all lower case but that didn't work either. Thanks...
>
> On 4/5/2016 3:38 PM, Devin Asay wrote:
> > Ray,
> >
> > You may have moved your DB file from a system that is not case
> sensitive, like MacOS, to one this is case sensitive, like Linux. Do all of
> your folders and file names have the same exact spelling, including upper
> and lower case letters, as the string in your path variable?
> >
> > Devin
> >
> >
> >> On Apr 5, 2016, at 12:39 PM, Ray  wrote:
> >>
> >> ...one other note.  I'm guessing calls to sqLite need drivers. These
> drivers are probably built in to Livecode and the OnRev server which would
> explain why LC's database commands works so well locally and with the OnRev
> based samples.
> >>
> >> If this is the problem, does anybody know how I could install these
> drivers on my own server?
> >>
> >> On 4/5/2016 1:18 PM, Ray wrote:
> >>> I've never worked with sqLite databases before but it appears I should
> be able to access one on a server pretty much the same as I do locally.
> >>>
> >>> Here's what I've done:
> >>>put revOpenDatabase("sqLite",localPath) into theDbId
>-- this creates a zero K local database file
> >>>
> >>>put "CREATE TABLE bugs(Name char(50), Date char(50))" into myQuery
> >>>revExecuteSQL theDbId,myQuery -- the local database file is no 2 K
> >>>
> >>>revCloseDatabase theDbId -- close it or I won't be able to copy it
> to the server
> >>>
> >>> I then copy the local database file to a remote server and make sure
> all 9 permissions are checked (777).
> >>>
> >>> I now load the well-tested server path into the variable dbPath and
> try this:
> >>>put revOpenDatabase("sqLite",dbPath) into myResult
> >>>
> >>> but all I get back is:
> >>>Error: Unable to open the database file
> >>>
> >>> Suggestions?
> >> ___
> >> 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
> > Devin Asay
> > Office of Digital Humanities
> > Brigham Young University
> >
> >
> > ___
> > 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: How to make the group itself a target

[Peter Haworth]

the short name of the owner of me

On Fri, Apr 1, 2016, 8:09 PM Sannyasin Brahmanathaswami 
wrote:

> Assume we have a small group duplicated on the card 10-20 times.
>
> each group contains three objects named
>
> portal-link-background
> portal-link-label
> portal-link-thumbnail
>
> The above is grouped... acts as a template; and is programatically
> duplicated X number of times
>
> Each of the resulting groups is assigned a unique name
>
> home
> surprises
> learn
> practice
> audio
> visuals
>
> etc.
>
> Now I want to set a behavior that will return the name of the group on
> mouse up.
>
> the target won't work, because the mouse up is trapped by the field,
> background or image in the group so the group itself is never the target.
>
> I realize I can test for the long id of the target, then extract the name
> of the group from that.
>
> field id 1348 of group id 1346 of group id 1354 of card id 1082 of stack
> "/Users/Brahmanathaswami/Documents/App Development/SivaSiva App/App
> Source/SivaSiva.livecode"
> put the long idea of the target into tTargetID
>
> go to card (the short name of group (word 7 of tTargetID)
>
> I always prefer not parsing this kind of string for hard values, as things
> can change...
>
>  But  this is the only method I can think of.  Is there a better way?
> Obviously we dont' want to be putting "pass mouseup" into all the child
> elements of the group, as that breaks the whole point of using a behavior.
>
> BR
>
>
>
> ___
> 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: Script Only Stack Architecture

[Peter Haworth]

lcStackbrowser shows an icon for the object's script and one icon for each
of its behavior scripts. Clicking on any of them opens the appropriate
script.  In addition, the tooltip for an object lists how many lines are in
its script, the objects in its behavior chain and how many lines are in
each behavior script.

On Fri, Apr 1, 2016 at 8:39 AM Mark Wieder  wrote:

> On 04/01/2016 07:34 AM, Ali Lloyd wrote:
> >> It's a pain to open the object inspector and copy the behavior reference
> >> then use the message box to to "open script of…"
> >
> > This is no longer necessary in the latest DPs of 8.0 - the behavior
> > property in the property inspector has an 'edit script' button.
>
> In addition, the Project Browser that I'm usually kicking has a very
> nice feature in that if there is a behavior object associated with a
> stack or control you will see that indicated to the left of the script
> lines, and it also shows the number of lines in the behavior script.
> Right-click or control-click on that and you can directly edit the
> behavior script.
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.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: Script Only Stack Architecture

[Peter Haworth]

"start using" puts all handlers in the stack into the message path as front
scripts which is why all your mouseUp messages are being caught.

If your script-only stack is a separate main stack from your application's
main stack, just open the script-only stack in the preOpenxxx handler of
your app's main stack.  I haven't used script-only stacks yet but I think
they could be included in your app as substacks rather than separate main
stacks, then you wouldn;t need to do anything special after opening your
app's main stack.

On Wed, Mar 30, 2016 at 4:03 PM Sannyasin Brahmanathaswami 
wrote:

> Monte:
>
> Thanks for the thoughtful response.
>
> For now, even the basics would help... in the dictionary... I had to test
> this morning to learn things that could all be placed on a single page of
> documentation
>
> 1) create a script only stack. Save to disk and leave open call it
> "behavior-field-text.livecodescript)
> 2) create field; set behavior, aha! my new script only stack is available.
> 3) assign the stack to the field  -- should accept on mousup, field is
> locked and the behavior refers to "me") for testing the behavior stack has
> a simple:
>
>
> on mouseup
>
> answer "from stack behavior"
>
> put the formattedheight of me into tTotalTextHeight
>
> put ( the height of me - tTotalTextHeight ) / 2 into tTopBottomMargins
>
> set topmargin of me to tTopBottomMargins
>
> end mouseUp
>
> 4) lock field, click on field... nothing happens  hhh (blink)
>
> 5) go to the message box... on a hunch type
>
> "start using behavior-field-text.livecodesript"
>
> 6) click on field ... Oh, it works now!
>
> 7) save stack quit LC
>
> 8) boot LC again... open main stack with field that has the behavior
>
> 9) click on field that has behavior assign, Oh gosh... now it doesn't work.
>
> 10) But wait... inspect field  the behavior is assigned to
> "behavior-field-text.livecodesript"
> -- Why doesnt' it work... duh
>
> 11) to go main stack, preopenstack handler  add this:
>
> put specialFolderPath("Resources") into tAppRoot
> start using stack (tAppRoot
> &"/"&"/main-stack-scripts/behaviors/sv_field-behaviors.livecode"
>
> 12) from msg box run "preopenstack" -- my behavior stack is now in use,
> theoretically.
>
> 13) Note that only one  field has this stack behavior assigned
>
> but now: any mouseup anywhere on the UI triggers the script.. mouseup msg
> from anywhere is intercepted by the script-only-stack that is assigned to
> just a single field.
>
> Also: reference to "me" obviously lost and the behavior script thinks "me"
> refers to itself and not the child field.
>
>
> [X] executing at 12:42:02 PM<
> http://airmail.calendar/2016-03-30%2012:42:02%20HST>
>
> Type Object: does not have this property
>
> Object sv_field-behaviors
>
> Line put the formattedheight of me into tTotalTextHeight
>
> Hint mouseup
>
>
> 14) move that script to a button... change the field behavior to that
> button.
>
>
> on mouseup
>
> answer "from btn behavior"
>
> put the formattedheight of me into tTotalTextHeight
>
> put ( the height of me - tTotalTextHeight ) / 2 into tTopBottomMargins
>
> set topmargin of me to tTopBottomMargins
>
> end mouseUp
>
>
> and it works out of the box...
>
>
> --- pretty much a complete nightmare...lost all day yesterday<
> http://airmail.calendar/2016-03-29%2012:00:00%20HST> and all morning
> today...
>
> Sure what I hope for is a full scope architecture thing...
>
> but for now: We are  not asking for a lot, just enough to understand how
> to make it work?
>
> Since this model has been in use since 6.5 or something like that...
> clearly it works.  Can we just document how?
>
> unable to assign behavior to script-only-stack.
>
>
>  What am I Missing?
>
> BR
>
>
> ___
> 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: negating in a regexp

[Peter Haworth]

Wasn't sure about the need for "+".  The dictionary entry for replaceText
says it replaces all instances of strings that match the regex.

On Wed, Mar 30, 2016 at 12:33 PM Roger Eller 
wrote:

> *put* replaceText(fld 1, "[^0-9]+", space) into fld 2
>
>
>
> On Wed, Mar 30, 2016 at 3:14 PM, Dr. Hawkins  wrote:
>
> > I'm trying to filter a string to change everything but digits to spaces.
> >
> > It would seem that
> >
> >
> > replaceText("ab26 g9", "^\d",space)
> >
> >
> > should produce "  26   9", but for the live of me, I can't get ^ to work
> in
> > any context.
> >
> > I've even tried playing with the regex builder plugin, with no success.
> >
> > Am I missing something simple (again)?
> >
> > thanks
> > --
> > Dr. Richard E. Hawkins, Esq.
> > (702) 508-8462
> > ___
> > 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: negating in a regexp

[Peter Haworth]

Try [^\d]

^ outside [] means start of line.

On Wed, Mar 30, 2016 at 12:15 PM Dr. Hawkins  wrote:

> I'm trying to filter a string to change everything but digits to spaces.
>
> It would seem that
>
>
> replaceText("ab26 g9", "^\d",space)
>
>
> should produce "  26   9", but for the live of me, I can't get ^ to work in
> any context.
>
> I've even tried playing with the regex builder plugin, with no success.
>
> Am I missing something simple (again)?
>
> thanks
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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: LC8DP15 feedback-IDE Issues

[Peter Haworth]

An lcstackbrowser user requested the "single tool with option to set the
style "some time ago and I implemented it.  It takes a lot less screen
space and I think is useful for experienced users but might be a little
daunting for new users.

On Wed, Mar 2, 2016 at 2:56 PM Devin Asay  wrote:

>
> > On Mar 2, 2016, at 3:42 PM, Richard Gaskin 
> wrote:
> >
> > I haven't used the Tools palette in years, but this conversation
> prompted me to take a gander.
> >
> > I wonder if having the Widgets above the basic controls is the best
> place for them.
> >
> > I tend to think of UIs as telling a story, and sometimes that can
> include communicating the importance of things by their placement.
> >
> > Having the Browse and Pointer tools at the top, and giving them the
> largest target area, seem like good choices given their very central role
> throughout development.
> >
> > But I'll spend weeks at a time adding only buttons and fields to cards,
> only occasionally using anything else.
> >
> > The Widgets, while both useful and cool, are less commonly used. Indeed,
> most projects will use most of them once or twice if at all.
> >
> > Given this, I wonder if it makes more communicative sense to consider
> moving the basic controls above the Widgets, closer to the always-used
> Browse and Pointer icons.
> >
> > I might even go so far as to consider moving the graphics above Widgets
> as well, to be consistent in terms of frequency of use, though I recognize
> that the paint tools are perhaps the least commonly used of all, and they
> make sense being grouped near the drawing tools, so perhaps leaving that
> whole set at the bottom is fine, and we could just consider moving the
> basic tools (buttons, fields, and such) above the Widgets.
> >
> > Any opinions on this?
>
> I’m with you on this, Richard. The tools palette is getting very cluttery,
> and could stand a tidying up. For instance, right now there are:
> - 5 button tools
> - 5 field tools
> - 5 menu button tools
> - 4 scrollbar tools
>
> Would it make sense to fold each object class into a single tool with an
> option to set a different style of each object as the default? Sort of how
> Photoshop’s tools palette lets you select the type of marquee tool (or
> shape tool, or magic wand tool, etc. etc.) that is the default.
>
> >
> >
> > PS: What happens when one has 100 Widgets installed?
>
> Right. Now you can choose to hide or show entire sections of the tools
> palette. (Although I had somehow completely missed that option, and only
> noticed it when someone here referred to it.)
>
> I’d like to see an option to display only selected widgets (or other
> tools) on the tools palette.
>
>
> Devin
>
>
> Devin Asay
> Office of Digital Humanities
> Brigham Young University
>
> ___
> 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: LC8DP15 feedback-IDE Issues

[Peter Haworth]

I've also noticed the first issue you mentioned.  In my case, it's not so
much that clicking an object doesn't select but trying to grab the handles
to resize an object has to be very accurate or the object is deselected.  I
guess I should enter a QCC report.

Don't use the Project Browser so can't comment on the second issue

On Tue, Mar 1, 2016 at 2:40 PM Peter TB Brett 
wrote:

>
>
> On 01/03/2016 22:28, William Prothero wrote:
>
> > The first thing I’ve noticed is that selecting objects in the Project
> > Browser and stack window is poor. In 7.1 versions and older, when I
> > clicked on an object on the stack window, it would hilite the
> > corresponding entry on the project browser. First off, I find that
> > clicking on different objects in the stack screen, it often refuses
> > to “select” a new object until I click around. Secondly, when I click
> > on an object on the stack window, it should hilite in the project
> > browser. This is very convenient when developing, and it doesn’t seem
> > to happen in LC8.
>
> Hi Bill,
>
> Selected objects are now shown in the Project Browser with a highlighted
> border.  You can "zoom to" an object by right-clicking on it (on the
> stack) and selecting "Show in Project Browser".  This was an intentional
> change to make it slightly easier to not "lose your place" in the
> Project Browser view when you change the selected object in a stack with
> lots of controls.
>
> I think I remember seeing a bug relating to selecting things, but I
> can't find it right now... please go ahead and file a bug report if you
> can reliably reproduce the problem.
>
> > So, I’m still on LC8, but the IDE, nice and shiny new as it is, still
> > needs some work. Or, perhaps I just haven’t figured out all of its
> > new options yet.
>
> Feedback is always appreciated.  Currently I'm finding that the LiveCode
> 8 IDE is actually a big improvement over the LiveCode 7 one for the
> things that I use it for (but I'm aware that I'm a *very* atypical user!)
>
>   Peter
>
> --
> Dr Peter Brett 
> LiveCode Open Source Team
>
> LiveCode 2016 Conference https://livecode.com/edinburgh-2016/
>
> ___
> 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: Possible enhancement

[Peter Haworth]

I like that better.  It's more inline with LC's English-like structure.  It
also removes a potential problem with the break number if you add or remove
a control structure. Is there already an enhancement request for it?

On Sat, Feb 27, 2016 at 1:21 PM Mark Wieder <mwie...@ahsoftware.net> wrote:

> On 02/27/2016 12:53 PM, Peter Haworth wrote:
>
> > Worth an enhancement request?
>
> What I'd rather see, and I think Robert Calliau has suggested this
> before, is the ability to have named loops. Then you could exit from a
> loop by specifying its name.
>
>   repeat . as outerLoop
>   repeat. as loopyLoop
>  repeat. as innerLoop
> if  then exit loopyLoop
>  end repeat -- end of innerLoop
>   end repeat -- end of loopyLoop
>   -- after the 'exit loopyLoop' the script continues here
>   end repeat -- end of outerLoop
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.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

Possible enhancement

[Peter Haworth]

Following on from my post about the ability to enclose strings in single
quotes, I came across another php feature which I think would be useful in
LC.

The php break statement has a numeric argument that defines how many
control structures to break out off  I sometimes find myself in 3 or 4
nested repeat statements and need to get out of the whole structure if a
particular condition is met in one of the inner structures. With the php
break format, I could:

repeat .
   repeat.
  repeat.
 if  then break 3
  end repeat
   end repeat
end repeat

or:

repeat.
   switch .
  case...
 ...
 break
  case...
 ...
 break
  default
 ...
 break 2
   end switch
end repeat

The default would be 1 so no existing code would be affected.

Worth an enhancement request?
___
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: Players in HTML5 - ETA for Full Functionality?

[Peter Haworth]

I agree, I think that's what he means.  Wasn't there a personal use license
at one point?  I seem to recall that standalones built with it displayed a
splash screen for 10 seconds at startup.

On Fri, Feb 26, 2016 at 12:15 PM J. Landman Gay 
wrote:

> On 2/26/2016 1:38 PM, stephen barncard wrote:
> > I don't understand why the OSS version won't work for you if it's a
> 'hobby'
> > thing
>
> I understand what he means. The OSS version would work fine, but that's
> not the point. His point is that he thinks LC is losing money from those
> who would like to contribute by purchasing a license at a reduced rate
> (possibly restricted to personal use only, or something similar I'm
> guessing.)
>
> It isn't that there is no path forward, but rather that he thinks the
> current licensing model is costing the company some sales. I don't know
> if that's true or not, I'm just playing interpreter.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.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: DataGrid

[Peter Haworth]

modTableField is a great alternative to a DG table.  Don't have the link to
hand but hopefully Bernd will chime in.

On Thu, Feb 25, 2016 at 9:13 AM Richard Gaskin 
wrote:

> stephen barncard wrote:
>
> > ...back to a tabbed scrolling field
>
> No harm in that.  The DG was written to support both list and form row
> types only because at the time the LC field object didn't allow
> independent column alignment, needed for financial apps and others where
> text may be left-aligned while numbers need to be right-aligned.
>
> Now that we have the tabAlign property we can use LC's native field
> object for a wide range of cases we used to have to use the DG for.
>
> --
>   Richard Gaskin
>   Fourth World Systems
>   Software Design and Development for the Desktop, Mobile, and the Web
>   
>   ambassa...@fourthworld.comhttp://www.FourthWorld.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: Send multiple variables to a URL with POST to SQLSRV + php

[Peter Haworth]

Looks like you missed an "=", should be "="?

On Wed, Feb 24, 2016 at 3:09 PM david alfredo zuñiga soto <
david_alfredo...@hotmail.com> wrote:

> Hi all, a little help please.
> in my app of LiveCode use this sentence:put "tIDUsr=" & IDUsr &
> "=" & PWD & "" into tArgListpost tArgLists to
> URL "http://172.16.2.130:8080/BuscarNombreUsr.php;put it into
> encodeNombre
> Presumably, sent the user id, password and mail my script of php.. but.
> This only marks | Undefined index: tIDUsr in| and this is for all data
> sent..
>
> my script php does this..
>
>  $IDUsr=$_POST["tIDUsr"]; $nIDUsr=(int)$IDUsr; #convertir la cadena a
> entero, para comparar con tynit en la bd $PWD=$_POST["tPWD"];
> $Correo=$_POST["tCorreo"];$query = "SELECT Nombre FROM tblusuarios
> WHERE IDUsuario='$nIDUsr' and Contraseña='$PWD' and Correo='$Correo'";
> $stmt4 = sqlsrv_query( $conn, $query);if( $stmt4 === false)
> { echo "Error in query preparation/execution.\n";
> die( print_r( sqlsrv_errors(), true));}while( $row
> = sqlsrv_fetch_array( $stmt4, SQLSRV_FETCH_ASSOC)){echo
> $row['Nombre']."\n";}$stmt4 = null;$conn = null;?>
> any suggestions ?? thanks for everything
>
> ___
> 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: Email Test 1

[Peter Haworth]

I use gMail, Inbox actually.  The only problem I've had in the past has
been that messages from folks on the list with aol addresses were
classified as spam.  Since there were only a handful of them, I set up a
filter to make sure they didn't end up in my spam folder.

On Wed, Feb 24, 2016 at 8:55 AM Rick Harrison 
wrote:

> Hi Stephen, Sean, Mark, Kee, Frans and LiveCoders,
>
> Thank you for letting me know you received my email test message.
>
> Yes, I’m using Gmail as my host email, has that been causing issues for
> anyone else?
> If so, any ideas what the problem might be?
>
> Thanks,
>
> Rick
>
> > On Feb 23, 2016, at 7:04 PM, stephen barncard <
> stephenrevoluti...@barncard.com> wrote:
> >
> > Rick I see it here. Are you using Gmail?
> >
> > sqb
> >
> > Stephen Barncard - Sebastopol Ca. USA -
> > mixstream.org
>
> ___
> 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: LCB: Error: illegal escape in string

[Peter Haworth]

Doesn't seem like it should be treated as an escape character since it's in
quotes, as you say.  I'd enter a QCC report about it and see what the LCB
team have to say.

On Tue, Feb 23, 2016 at 5:55 PM Stephen MacLean 
wrote:

> Hi Phil,
>
> Thanks for responding, I’m not one either and it works fine with no issues
> when run directly in LC.
>
> Removing the “\” does cure the error, but of course doesn’t work any more.
>
> So the question I guess is two fold: 1) Why is that considered an escape
> character when it is enclosed in quotes and 2) How do you escape it?
>
> Sorry, trying to learn LCB. Documentation is hard to find, at least for
> me. The dictionary for LCB is very light at the moment.
>
> Thanks,
>
> Steve MacLean
>
> > On Feb 23, 2016, at 6:25 PM, Phil Davis  wrote:
> >
> > I'm not much of a regex guy, but what happens if you remove the
> backslash after {1,63} ?  I assume something will probably stop working,
> but that's the only \ in the string.
> >
> > Phil Davis
> >
> >
> >
> > On 2/23/16 1:59 PM, Stephen MacLean wrote:
> >> Hi All,
> >>
> >> Working to build a library extension and I’m getting an error on this
> line when I go to test it in LCB:
> >>
> >> put "^[A-Z0-9._%+-]{1,64}@(?:[A-Z0-9-]{1,63}\.){1,125}[A-Z]{2,63}$"
> into tRegex
> >>
> >> The error is:
> >>
> >> illegal escape in string '^[A-Z0-9._%+-]{1,64}@
> (?:[A-Z0-9-]{1,63}\.){1,125}[A-Z]{2,63}$’
> >>
> >> Any ideas?
> >>
> >> Thanks,
> >>
> >> Steve MacLean
> >>
> >> ___
> >> 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
> >
> > --
> > Phil Davis
> >
> >
> > ___
> > 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: Finding UTC

[Peter Haworth]

I don;t have the link to hand but there's a Youtube video that's been
posted on this list before about what a nightmare it is to handle all the
scenarios involving what date and time it is in different parts of the
world and keeping up to date with changes.

Pete

On Sun, Feb 21, 2016 at 1:10 PM [-hh]  wrote:

> Sorry, typo in link, should read
> http://hh.on-rev.com/html5/countUpOrDown-8.0.0-dp-9X.html
>
>
> ___
> 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: Help using database & data conversion

[Peter Haworth]

What are the commands you are using to insert/update data in your mySQL
database and your local SQLite database?  Data needs to be textEncoded
before the insertion/deletion and textDecoded when SELECTing.  Also, not
sure what you mean by "manually in the local database".
Pete

On Tue, Feb 16, 2016 at 12:28 PM tkuyp...@telenet.be 
wrote:

> After 2 nights I give up!!!
> Even though I can’t, I must fix this :-(
>
> I’m using LiveCode Community 7.1.2 (rc 1) on a Mac.
>
> I have a database setup in mySQL, from which I need to retrieve data and
> insert it into a local SQLite database.
> Both the online and local databases are setup the same, but store UTF-8
> data
>
> In one of the fields in a mySQL database there is the word “bacteriën”.
>
>
> When I use
> put textDecode(revDataFromQuery(,,dbID, vSQL),"UTF8") into vData
> to retrieve the data from the mySQL database, vData contains “bacterin"
>
> When I use
> put textEncode(revDataFromQuery(,,dbID, vSQL),"UTF8") into vData
> to retrieve the data from the mySQL database, vData contains “bacteriÎn"
>
> When I use
> put revDataFromQuery(,,dbID, vSQL) into vData
> to retrieve the data from the mySQL database, vData contains binary data
>
> When I enter the word “bacteriën” manually in the local database, I can
> retrieve it without any problems, but I just can’t get it in there using
> the regular database functions :-(
>
> Anyone? please? How do I get the correct data in my local database?
>
>
> Met vriendelijke groeten,
> Warm Regards,
>
>
>
> Ton Kuypers
> +32 (0) 477 739 530
>
> Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium
> www.publishingtools4u.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: changing the size of the image that's combined with text

[Peter Haworth]

QCC Report #16941

On Tue, Feb 16, 2016 at 9:47 AM [-hh]  wrote:

> > I've been doing some php coding recently and it allows the us
> > of single or double quotes as string delimiters so you can use
> > single quotes around a string that includes double quotes. Would
> > be nice to have that in LC.
>
> Yes, this is so comfortable! I miss it in LC since years. Please
> make a feature request so that we can second it.
>
> ___
> 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: changing the size of the image that's combined with text

[Peter Haworth]

I've been doing some php coding recently  and it allows the use of single
or double quotes as string delimiters so you can use single quotes around a
string that includes double quotes. Would be nice to have that in LC.

On Tue, Feb 16, 2016, 5:45 AM Peter M. Brigham  wrote:

> On Feb 16, 2016, at 1:32 AM, Matt Maier wrote:
>
> > I found the right syntax for writing html that will combine text and
> images:
> > lerg
> > and also that the char reference isn't necessary, so this works
> > 
> > It's a bit tedious to code, since you have to escape the quotes like
> this:
> > put " > quote & ">" into tHTML
> > but whatevs, it works.
>
> A slightly tangential offering — here's what I use to create strings that
> contain quotes — it simplifies the tedious and error-prone process of
> constructing these strings.
>
> ---
>
> function qInString pStr, pAltChar
>-- use for creating strings that contain quotes
>--eg, for constructing ask/answer dialogs, error messages, etc.
>-- default is to use "^" as quote placeholder, can be overridden
>-- eg,
>--qInString("fld ^text^ of card ^apple^ of stack ^fruits^")
>-- returns:
>--fld "text" of card "apple" of stack "fruits"
>-- shorter, and easier to proofread than
>--put "fld" && quote & "text" & quote && "of card" && quote &
> "apple" \
>   --& quote && "of stack" && quote & "fruits" & quote into tStr
>-- by Peter M. Brigham, pmb...@gmail.com — freeware
>--from a handler on the Use-LC list
>
>if pAltChar = empty then put "^" into pAltChar
>replace pAltChar with quote in pStr
>return pStr
> end qInString
>
> ---
>
> -- Peter
>
> Peter M. Brigham
> pmb...@gmail.com
> http://home.comcast.net/~pmbrig
>
>
> ___
> 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: shadow declarations bug back?

[Peter Haworth]

You're probably right, can't remember the exact details.

On Thu, Feb 11, 2016 at 3:35 PM Ben Rubinstein <benr...@cogapp.com> wrote:

> FWIW I think the repro case is a little tighter than that: I think it's
> when
> execution is stopped from the debugger, *with the variable inspection pane
> selected*.
>
> I won't swear to it...
>
> On 11/02/2016 18:40, Peter Haworth wrote:
> > I haven't seen the shadowed variable bug for a long time.  I think it was
> > established that the bug occurs when execution is stopped by clicking the
> > blue square icon to stop execution during a debug run. Don't know if the
> > underlying cause of that has been fixed but I try to remember to let
> debug
> > runs continue to the end these days and have not experienced the problem
> > since.
> >
> > On Thu, Feb 11, 2016 at 10:23 AM Dr. Hawkins <doch...@gmail.com> wrote:
> >
> >> The once common shadow-declaration bug seems to have largely gone away;
> I
> >> realized that I hadn't seen it in some time.
> >>
> >> It seems to have appeared again in 7.1.2_rc1 & rc2; are other people
> seeing
> >> it again?
>
>
> ___
> 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 db password?

[Peter Haworth]

Hi Bill,
SQLite didn't have built-in password protection until a fairly recent
release and the SQLite library.  I dont recall which version.  The SQLite
library included with Livecode 8 is a fairly recent one and I believe
includes the password feature

Unfortunately, Livecode has not been updated to include the necessary
parameters to revOpenDatabase to pass in a password for sqlite, as you've
found. If you know the password, you can remove it using the sqlite3
command line tool but I'd have to reserach that further for you.

Pete

On Thu, Feb 11, 2016 at 4:37 PM William Prothero 
wrote:

> Folks:
>
> I have an sqlite database created in Adobe Director using an old Xtra
> (Arca). It has a password. Can livecode open an sqlite database that is
> password protected? I can’t tell from the dictionary, how to open a
> password protected db that is local.
>
> Thanks for any info.
> Best,
> Bill
>
>
> William Prothero, Ph.D.
> University of California, Santa Barbara, Emeritus
> proth...@earthednet.org
>
>
>
>
> ___
> 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: shadow declarations bug back?

[Peter Haworth]

I haven't seen the shadowed variable bug for a long time.  I think it was
established that the bug occurs when execution is stopped by clicking the
blue square icon to stop execution during a debug run. Don't know if the
underlying cause of that has been fixed but I try to remember to let debug
runs continue to the end these days and have not experienced the problem
since.

On Thu, Feb 11, 2016 at 10:23 AM Dr. Hawkins  wrote:

> The once common shadow-declaration bug seems to have largely gone away; I
> realized that I hadn't seen it in some time.
>
> It seems to have appeared again in 7.1.2_rc1 & rc2; are other people seeing
> it again?
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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

DP14 Tooltip

[Peter Haworth]

The background color tooltips is white in DP14, used to a yellow color.  Is
this another result of theming?
___
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: Black icons in LC 8 DP 14

[Peter Haworth]

I'm seeing what I think is a related issue in the Script Editor.  Not sure
what font was used in the SE tabs prior to 8 DP14 but it was noticeably
bold on the active tab.  In DP14, the bold is hardly noticeable so I'm
guessing it's using the system font and this is the same issue as with the
icons.

On Mon, Feb 8, 2016 at 1:14 PM Devin Asay  wrote:

>
> > On Feb 8, 2016, at 1:58 PM, Ali Lloyd  wrote:
> >
> > The label text of the menu buttons actually does go bold, but it seems to
> > be an unfortunate feature of the system font on OSX (Yosemite onwards)
> that
> > it either changes imperceptibly or not at all when bolded. I have noted
> it
> > as something we should deal with.
>
> Possibly because the system font on OS X doesn’t have a Bold variant?
>
> Devin
>
> Devin Asay
> Office of Digital Humanities
> Brigham Young University
>
> ___
> 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: LC 6.7.8 won't load

[Peter Haworth]

Thanks Mark.

I found the culprit that caused the 6.7.8 issue - a tiny little plugin I
write that loads at startup, although I'm not sure why the coding error in
it should cause LC to silently quit or why it didn't have the same effect
in other LC versions.

I have separate prefs locations for 7 and pre-7.  Should I have a separate
one for 8?

On Sun, Feb 7, 2016 at 1:46 PM Mark Wieder  wrote:

> On 02/07/2016 01:14 PM, [-hh] wrote:
> > Peter H. wrote:
> >> It looks like this is a plugin issue.  I removed all my plugins
> >> and 6.7.8 now loads fine.  Will experiment to find which plugin
> >> is causing the problem.
> >
> > Tried your no-plugin-method. Had until now no startup-crash with
> > 6.7.8, but two with 7.1.1 and one with 8.0.0-dp14.
>
> Delete or rename your preferences file or folder and try again.
> I find myself having to do this on a regular basis - there are some
> things in the preferences file that won't work across versions. And if
> you have a livecode.rev file then LC8 will grab the preferences from it
> to incorporate into livecode7.rev. Things are messed up after that.
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.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: LC 6.7.8 won't load

[Peter Haworth]

It looks like this is a plugin issue.  I removed all my plugins and 6.7.8
now loads fine.  Will experiment to find which plugin is causing the
problem.

On Sun, Feb 7, 2016 at 10:45 AM [-hh]  wrote:

> > Sounds like you may be experiencing something different. 6.7.8 is the
> only
> > version that won't run for me. I've tried a half dozen time with the same
> > result. Is there some sort of system logfile I can look at and include
> > with a QCC report?
> > On Sun, Feb 7, 2016 at 3:54 AM [-hh]  wrote:
> > > > Peter H. wrote:
> > > > ... Surprised it hasn't been fixed yet since 6.7.8 is dead in the
> water
> > > for me.
> > >
> > > Sadly it's all the same on MacOS**, from LC 6.7 to LC 8.0, also with
> newest
> > > rc- or dp-releases.
> > > I don't report repeatedly, because probably MacOS/SIPS is (more) the
> > > culprit.
> > >
> > > __
> > > ** Mac OS 10.11.3 (also tested with newest MacOS 10 developer
> previews).
> > > ___
>
> Couldn't find a report in QC. Can remember now: I 'reported' it in
> "forums/Bug  Triage" with 0 answers for 14 days or so, so I deleted it.
> There was another problem with frequent relicensing in QC (for me connected
> to that) but its better to open a new report in QC. Please do that.
>
> I have a system log from just now for 6.7.8 Indy (the one that is offered
> to send to Apple). I'll add it zipped to your report -- please use
> "startup"
> in the header so I can find it fast.
>
> hh
> ___
> 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: LC 6.7.8 won't load

[Peter Haworth]

Sounds like you may be experiencing something different.  6.7.8 is the only
version that won't run for me.  I've tried a half dozen time with the same
result.

Is there some sort of system logfile I can look at and include with a QCC
report?

On Sun, Feb 7, 2016 at 3:54 AM [-hh]  wrote:

> > Peter H. wrote:
> > ...  Surprised it hasn't been fixed yet since 6.7.8 is dead in the water
> for me.
>
> Sadly it's all the same on MacOS**, from LC 6.7 to LC 8.0, also with newest
> rc- or dp-releases.
> I don't report repeatedly, because probably MacOS/SIPS is (more) the
> culprit.
>
> __
> ** Mac OS 10.11.3 (also tested with newest MacOS 10 developer previews).
> ___
> 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: LC 6.7.8 won't load

[Peter Haworth]

OK thanks, sounds like it's already been reported.  Surprised it hasn't
been fixed yet since 6.7.8 is dead in the water for me.

On Sat, Feb 6, 2016 at 2:25 PM [-hh]  wrote:

> This is a great advantage of the forum (at least for me):
> One can edit a post and correct typos and wrong wording.
>
> You have please simply to overlook such things here ;-)
>
> ___
> 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

LC 6.7.8 won't load

[Peter Haworth]

I just installed LC 6.7.8.  When I ran it for the first time, it went
through the usual license check and the aborted with no error message.
Same thing happens every time I run it (sans the license check).

This is on OSX 10.10.  Anyone else seeing this?
___
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: LC8 Save command

[Peter Haworth]

Thanks Jacque.  Have implemented that now.  It just seems like there should
be a less kludgy way to get hold of such a basic piece of information.

On Sat, Feb 6, 2016 at 10:46 AM J. Landman Gay <jac...@hyperactivesw.com>
wrote:

> That's what I do. If you use "open file" instead of URL syntax you can read
> just the first few bytes without loading the whole stack into RAM and it's
> very quick.
>
>
> On February 6, 2016 12:02:32 PM Peter Haworth <p...@lcsql.com> wrote:
>
> > I'm happy to use the "with format" option, just trying to figure out how
> > the get the stack file's format if it is to be saved in that format. I
> did
> > find a stackfileversion cprop in the cREVGeneral cprop set of some stacks
> > but it was empty.  There are other stacks where it is not present at
> all. I
> > guess I will have to open the stack file and read the first few
> characters
> > as detailed.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.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: LC8 Save command

[Peter Haworth]

This is the context of a scripted Save command so the preference setting
doesn't help unfortunately.

I'm happy to use the "with format" option, just trying to figure out how
the get the stack file's format if it is to be saved in that format. I did
find a stackfileversion cprop in the cREVGeneral cprop set of some stacks
but it was empty.  There are other stacks where it is not present at all. I
guess I will have to open the stack file and read the first few characters
as detailed.




On Fri, Feb 5, 2016 at 6:08 PM Mark Wieder <mwie...@ahsoftware.net> wrote:

> On 02/05/2016 03:13 PM, Peter Haworth wrote:
>
> > Would be nice if there was a "with current format" or something similar
> > that would save the stack with the format it already has.
>
> Expanding on what Mark said, the IDE will do this if you have the
> preference set, but the save command invoked from a script won't.
>
> As you have discovered, calling the save command without options will
> save in 7.0 format unless there are widgets in the stack, in which case
> it will save in 8.0 format.
>
> To save in other formats you can either set the stackFileVersion before
> saving or use "with format" option of the save command.
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.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

LC8 Save command

[Peter Haworth]

If I'm reading the documentation correctly, saving a stack file without
specifying the "with format" clause results in it being saved in the format
specified in the stackFileVersion.

If I open a stack file created with 6.x or 7.x in 8.0 and save it without
changing the stackFileVersion and without specifying the format in the
"with" clause, it becomes unreadable by 6.x or 7.x, even if it uses none of
the 8.0 features.

I'd be happy to use the" with format" clause but is there a property of a
stack that contains its stackFileVersion?  The IDE obviously knows what it
is since it puts out a nice error message if you try to open a stack file
created with a later LC version.

Would be nice if there was a "with current format" or something similar
that would save the stack with the format it already has.
___
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: AW: How to create a hyperlink within a text field?

[Peter Haworth]

This might be something I need to do in a different context.  I had been
thinking of using the metadata property of the lines referenced by the
links as a means to locate the correct line. Is that a plausible solution?


On Thu, Feb 4, 2016 at 1:29 PM BNig  wrote:

> J. Landman Gay wrote
> > The formattedtext returns the correct metrics for me even when the field
> > size is changed and the text re-wraps. Do you get different results?
>
> If you make the field not wide enough it it can happen that the chapter
> title breaks. The same if you give the user the option to increase text
> size
> or choose a different font
>
>
>
> http://forums.livecode.com/viewtopic.php?f=9=26468
>
> number 4 is the stack that uses your code and is set to be admittedly
> ridiciously narrow. It shows the problem
>
> There is also Mark Waddinghams suggestion of using the formattedHeight.
> That
> would actually be the way to do a generalised solution including text that
> has non-fixed textHeight.
>
> Kind regards
>
> Bernd
>
>
>
> --
> View this message in context:
> http://runtime-revolution.278305.n4.nabble.com/How-to-create-a-hyperlink-within-a-text-field-tp4700650p4700736.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
>
___
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: Release 8.0 DP 14

[Peter Haworth]

I saw that this release includes "better desktop theming" for desktop apps,
but should all my stacks be displayed with a grey background on OSX?  I
know I can override this but is that really the way native apps look on
OSX?  I'm having a hard time finding one that does.

On Thu, Feb 4, 2016 at 6:35 PM Roger Eller 
wrote:

> I installed it and launched it just before leaving work for the day.  There
> wasn't time to file a report, but hey, apparently RunRev didn't care enough
> to even try it in Windows 7 64-bit.  Therefore, I don't feel too bad about
> my share of effort in testing thus far.
>
> I'll have a closer look tomorrow, unless my job gets in the way.
> On Feb 4, 2016 9:21 PM, "Richard Gaskin" 
> wrote:
>
> > Roger Eller wrote:
> >
> >> I installed it in Win 7 64-bit.  When it starts, a bunch of errors are
> >> shown, and the message box ui text is overlapping.  It is unusable.
> >>
> >
> > Thanks for testing.  What's your bug report number?
> >
> > --
> >  Richard Gaskin
> >  Fourth World Systems
> >  Software Design and Development for the Desktop, Mobile, and the Web
> >  
> >  ambassa...@fourthworld.comhttp://www.FourthWorld.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: AW: Re: Regex help needed...

[Peter Haworth]

Hi Thierry,
I might have missed it but did you publish your Regex2 to the list?
Pete

On Wed, Feb 3, 2016 at 12:07 PM Richard Gaskin 
wrote:

> Thierry Douez write:
>
> >>  Regex has  been around a long time
> >>  and lots of smart computer science types has
> >> spent time coming up with ways to optimize its performance for pattern
> >> matching.
> >
> > That's was true, it's still true and will always be true!
>
> It's true that there are almost always ways to improve performance using
> any method, but there are times when one method may be faster than
> another so it's worth testing out, as you did here:
>
> > and here are some benchmarks
> > done in a late rainy sunday evening:
> >
> >
> > * Regex2 faster than Chunk by: 2.1 times*
>
> Great results - what was the regex you used for that?
>
>
> > For the details:
> >
> > 1) Regex1 is the original regex, Chunk1 is  from Richard, Regex2 is mine.
> > 2) You can noticed the difference in time depending on the value of pPage
> > ( that's a normal behavior with regex)
> > 3) I've done the calculation the same way as Richard did, so you can
> compare
> >
> >
> >
> > **  aPage = 1, Same? true true
> > Regex1: 8943 ms
> > Chunk1: 210 ms
> > Regex2: 99 ms
> > Regex2 faster than orig regex by: 90.3 times
> > Regex2 faster than Chunk by: 2.1 times
> >
> > **  aPage = 2, Same? true true
> > Regex1: 9946 ms
> > Chunk1: 212 ms
> > Regex2: 100 ms
> > Regex2 faster than orig regex by: 99.5 times
> > Regex2 faster than Chunk by: 2.1 times
> >
> > **  aPage = 3, Same? true true
> > Regex1: 4451 ms
> > Chunk1: 210 ms
> > Regex2: 98 ms
> > Regex2 faster than orig regex by: 45.4 times
> > Regex2 faster than Chunk by: 2.1 times
> >
> > **  aPage = 4, Same? true true
> > Regex1: 11465 ms
> > Chunk1: 200 ms
> > Regex2: 98 ms
> > Regex2 faster than orig regex by: 117 times
> > Regex2 faster than Chunk by: 2 times
> >
> > **  aPage = 5, Same? true true
> > Regex1: 11457 ms
> > Chunk1: 201 ms
> > Regex2: 94 ms
> > Regex2 faster than orig regex by: 121.9 times
> > Regex2 faster than Chunk by: 2.1 times
> >
>
> --
>   Richard Gaskin
>   Fourth World Systems
>   Software Design and Development for the Desktop, Mobile, and the Web
>   
>   ambassa...@fourthworld.comhttp://www.FourthWorld.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: launch document problem

[Peter Haworth]

Thanks Mark. I filed  report (16776) and it's been classified as a bug with
the workaround documented by Kay.

The only issue I have now is avoiding hard coding the browser to use.  Does
anyone know of a way to find the default browser setting in OSX (this
program will only be running on Macs).

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Jan 27, 2016 at 11:46 PM, Mark Waddingham <m...@livecode.com> wrote:

> Hi Pete,
>
> On 2016-01-28 01:26, Peter Haworth wrote:
>
>> Prowling around the web, I found that the url I'm seeing is a "file
>> reference url", not sure whether this is an Apple thing or cross platform.
>> Since it works in Safari and not in Chrome, I suspect it may be an Apple
>> thing.
>>
>
> I believe 'launch document' uses the Launch Services API - it might be
> that needs a bit of patching to ensure it is using the latest and greatest
> way of communicating file references. The Apple APIs have made a move
> towards using URIs for most things these days so it could be that the
> engine is using a 'legacy' API these days.
>
> However the engine processes a launch document command is converting the
>> normal filepath to this file reference url which apparently Chrome doesn't
>> like.  I think I will file a QCC report about it.  Not sure it's really a
>> bug since the file reference url is valid in Safari but would be nice to
>> have a way to have the filepth not be converted to a file reference url.
>>
>
> Given that Kay observed that 'launch document with' works, but 'launch
> document' does not I suspect it should be easy to figure out. Please do
> file a report :)
>
> Warmest Regards,
>
> Mark.
>
> --
> Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
> LiveCode: Everyone can create apps
>
>
> ___
> 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: launch document problem

[Peter Haworth]

Prowling around the web, I found that the url I'm seeing is a "file
reference url", not sure whether this is an Apple thing or cross platform.
Since it works in Safari and not in Chrome, I suspect it may be an Apple
thing.

However the engine processes a launch document command is converting the
normal filepath to this file reference url which apparently Chrome doesn't
like.  I think I will file a QCC report about it.  Not sure it's really a
bug since the file reference url is valid in Safari but would be nice to
have a way to have the filepth not be converted to a file reference url.


Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Jan 27, 2016 at 4:13 PM, Peter Haworth <p...@lcsql.com> wrote:

> Still get a "can't open file" error or "no association" error depending on
> whether I use launch document or launch url.
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
> On Wed, Jan 27, 2016 at 3:53 PM, Phil Davis <rev...@pdslabs.net> wrote:
>
>> Try replacing spaces with "%20" in your url and see if that works.
>>
>> Phil Davis
>>
>>
>> On 1/27/16 3:31 PM, Peter Haworth wrote:
>>
>>> If I urlencode it, the launch command fails with "can't open file".  I
>>> also
>>> tried sticking "file:" at the front of the filepath and used launch url
>>> but
>>> that resulted in a "no association" error.
>>>
>>> I'm also finding that if I simply double click on the file in the Finder,
>>> Chrome opens it just fine withe filepath shoing up as the url not the
>>> transgomred string I see when I launch it from within LC.
>>>
>>> Pete
>>> lcSQL Software <http://www.lcsql.com>
>>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>>>
>>> On Wed, Jan 27, 2016 at 1:18 PM, Mark Wieder <mwie...@ahsoftware.net>
>>> wrote:
>>>
>>> On 01/27/2016 12:02 PM, Peter Haworth wrote:
>>>>
>>>> /Users/Pete/Documents/BandTrak/Report Data/Remittance.html
>>>> Does anyone know why this transformation of the file reference is
>>>>
>>>>> occurring? Also why it is recognized in Safari and not Chrome?
>>>>>
>>>>> urlencode it or (better) remove that embedded space.
>>>>
>>>> --
>>>>   Mark Wieder
>>>>   ahsoftw...@gmail.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
>>>
>>>
>> --
>> Phil Davis
>>
>>
>>
>> ___
>> 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: launch document problem

[Peter Haworth]

If I urlencode it, the launch command fails with "can't open file".  I also
tried sticking "file:" at the front of the filepath and used launch url but
that resulted in a "no association" error.

I'm also finding that if I simply double click on the file in the Finder,
Chrome opens it just fine withe filepath shoing up as the url not the
transgomred string I see when I launch it from within LC.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Jan 27, 2016 at 1:18 PM, Mark Wieder <mwie...@ahsoftware.net> wrote:

> On 01/27/2016 12:02 PM, Peter Haworth wrote:
>
> /Users/Pete/Documents/BandTrak/Report Data/Remittance.html
>>
>
> Does anyone know why this transformation of the file reference is
>> occurring? Also why it is recognized in Safari and not Chrome?
>>
>
> urlencode it or (better) remove that embedded space.
>
> --
>  Mark Wieder
>  ahsoftw...@gmail.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: launch document problem

[Peter Haworth]

Still get a "can't open file" error or "no association" error depending on
whether I use launch document or launch url.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Jan 27, 2016 at 3:53 PM, Phil Davis <rev...@pdslabs.net> wrote:

> Try replacing spaces with "%20" in your url and see if that works.
>
> Phil Davis
>
>
> On 1/27/16 3:31 PM, Peter Haworth wrote:
>
>> If I urlencode it, the launch command fails with "can't open file".  I
>> also
>> tried sticking "file:" at the front of the filepath and used launch url
>> but
>> that resulted in a "no association" error.
>>
>> I'm also finding that if I simply double click on the file in the Finder,
>> Chrome opens it just fine withe filepath shoing up as the url not the
>> transgomred string I see when I launch it from within LC.
>>
>> Pete
>> lcSQL Software <http://www.lcsql.com>
>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>>
>> On Wed, Jan 27, 2016 at 1:18 PM, Mark Wieder <mwie...@ahsoftware.net>
>> wrote:
>>
>> On 01/27/2016 12:02 PM, Peter Haworth wrote:
>>>
>>> /Users/Pete/Documents/BandTrak/Report Data/Remittance.html
>>> Does anyone know why this transformation of the file reference is
>>>
>>>> occurring? Also why it is recognized in Safari and not Chrome?
>>>>
>>>> urlencode it or (better) remove that embedded space.
>>>
>>> --
>>>   Mark Wieder
>>>   ahsoftw...@gmail.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
>>
>>
> --
> Phil Davis
>
>
>
> ___
> 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

launch document problem

[Peter Haworth]

In an application I wrote several years ago, I create reports by writing
html into a file and then using the launch document command to open the
file in the user's preferred browser.  All has been working fine with that
approach until OSX Yosemite came along.

The launch command references a file named:

/Users/Pete/Documents/BandTrak/Report Data/Remittance.html

The user has their default browser set to Chrome and when Chrome launches
with the above file reference, the URL is:

file:///.file/id=6571367.405704

... which results in a "web page not found" message.  If I copy/paste the
URL into Safari, the file is successfully displayed.

Does anyone know why this transformation of the file reference is
occurring? Also why it is recognized in Safari and not Chrome?
Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 
___
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

Printing to pdf

[Peter Haworth]

Following along with the lesson at
http://lessons.livecode.com/m/4071/l/29177-how-to-create-pdfs-using-livecode.
All is the same as the lesson except adjusted the print rectangle to fit
the card I'm printing.  Running on OSX 10.10 and LC8 DP11, using Preview to
display the pdf.  Font is Arial, size 10.

The field on my card shows all the text correctly with each line wrapped
appropriately.  The pdf cuts off the last few characters on each line.

If I reduce the width of the print rectangle by approx 50 pixels, the pdf
is created correctly.

Why is this adjustment necessary and is it a case of trial and error to get
the correct width or is there a formula that will yield it?
___
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: Http Header question

[Peter Haworth]

If you were doing this from an html form, the file in question would be
uploaded to the server's temp directory and the php script can access it
from there using the "tmp_name" key.  I think the $_FILES array is created
as a result of the  enctype setting.  Not sure how you would replace all
that via LC though.

On Tue, Jan 19, 2016 at 5:38 PM William Prothero 
wrote:

> Folks:
> Dave got me started, but I’m still confused, unfortunately. I am having
> trouble seeing how the variables and data are passed from the POST command
> to the php script. What I’m trying to reproduce is:
>
> if(isset($_FILES['image'])){
>   $errors= array();
>   $file_name = $_FILES['image']['name'];
>   $file_size =$_FILES['image']['size'];
>   $file_tmp =$_FILES['image']['tmp_name'];
>   $file_type=$_FILES['image']['type'];
>   $file_ext=strtolower(end(explode('.',$_FILES['image']['name'])));
>
>   $expensions= array("jpeg","jpg","png");
>
>   if(in_array($file_ext,$expensions)=== false){
>  $errors[]="extension not allowed, please choose a JPEG or PNG
> file.";
>   }
>
>   if($file_size > 2097152){
>  $errors[]='File size must be excately 2 MB';
>   }
>
>   if(empty($errors)==true){
>  move_uploaded_file($file_tmp,"images/".$file_name);
>  echo "Success";
>   }else{
>  print_r($errors);
>   }
>}
> ?>
> 
>
>
>   
>  
>  
>   
>
>
> 
>
> I’m familiar with a php script getting variables from lines like:
> $tName =  $_POST["name"];
>
> But, in the above example, how do the file variables get sent? I suppose,
> in the headers? But, I don’t seem to be successful. The file doesn’t seem
> to be passing to the php. I’m thinking that the image data gets embedded in
> the header, but I don’t see the file on my server and nothing seems to be
> getting into the $_FILES variable.
>
> Help?? thanks.
> Bill
>
>
> > On Jan 19, 2016, at 3:55 PM, William Prothero 
> wrote:
> >
> > Dave:
> > That’s it! I knew there was something like that, but couldn’t remember
> it.
> > Thanks!
> > Bill
> >
> >> On Jan 19, 2016, at 3:51 PM, Dave Cragg 
> wrote:
> >>
> >> Bill,
> >>
> >> Take a look at libUrlMultipartForm and libUrlMultipartFormAddPart in
> the dictionary. There are examples there that might help you.
> >>
> >> Cheers
> >> Dave Cragg
> >>
> >>
>
> ___
> 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

Version 2.2.2 of lcStackbrowser

[Peter Haworth]

lcStackBrowser v2.2.2 is now available.  This is mainly a bug fix release
with a couple of minor enhancements, all listed in the release notes at
https://goo.gl/DGUg65.

This is a free release for existing users.  A fully functional, 30-day demo
is available at http://www.lcsql.com/lcstackbrowser.html.
___
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: Release: 8.0 DP 13 -- Image Library?

[Peter Haworth]

Youre right, I can't find it either, used to be on the Development menu.
Should enter a bug report.

In the meantime, you can get to it from the lcstackbrowser Tools icon.

On Sat, Jan 16, 2016 at 10:29 AM Sannyasin Brahmanathaswami <
bra...@hindu.org> wrote:

> On January 13, 2016 at 8:05:44 AM, Ali Lloyd (ali.ll...@livecode.com
> ) wrote:
> We are pleased to announce the release of LiveCode 8.0 DP 13.
>
>
> Can we get the image library back?  I frequently dev using standard icons
> and then change those out later with custom designed ones after review… but
> currently in LC 8 dp13… unless I’m blind… I don’t see this in the IDE
> anywhere…
>
>
> BR
> ___
> 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: Message watcher in LC 8

[Peter Haworth]

Hi Alex,
The messages after openStack are coming from lcStackBrowser's front script
which traps openStack.  I guess the question is where the openStack
messages are coming from in the first place.  You might try Richard's
4WFlightRecorder stack, I find it much more useful than the message
watcher.  I believe it will tell you where the openStack messages are
coming from.

On Thu, Jan 14, 2016 at 6:02 PM Paul Hibbert  wrote:

> There have been a lot of bugs squashed since DP9, so I’d suggest trying
> DP13, I’m not seeing any such messages in this version.
>
> Paul
> ___
> 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: Windows 10 system version

[Peter Haworth]

NT 6.2

On Mon, Jan 11, 2016 at 2:34 PM J. Landman Gay 
wrote:

> Could someone on Windows 10 tell me what the systemVersion returns? Thanks.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.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: Windows 10 system version

[Peter Haworth]

Right, that was on an older version of LC, 6.6.something I think.

On Mon, Jan 11, 2016 at 4:05 PM J. Landman Gay 
wrote:

> On 1/11/2016 5:48 PM, Colin Holgate wrote:
> > Just went through some sort of big Windows 10 update, and the
> > systemVersion is showing NT 10.0 for me.
>
> That's more what I'd expect. Thanks.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.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: mySQL Host access

[Peter Haworth]

Hi Lyn,
Thanks for that info, that will certainly help me when I start looking into
LC server.  Unfortunately, I think I'm about 6 months into a 2-year
contract with my current web host so probably could not switch at this
point.


On Thu, Jan 7, 2016 at 4:17 PM Lyn Teyla <lyn.te...@gmail.com> wrote:

> Peter Haworth wrote:
>
> > Is this common practice when accessing mySQL on a host server?  If so, is
> > there a better way to set about accessing a mySQL database in these
> > circumstances, perhaps using php scripts on the server instead of
> accessing
> > the db directly with the LC database functions?
>
> One of my hosting providers HostM.com has been offering a free
> LiveCode-based MariaDB/MySQL API solution. It was previously available only
> to clients who needed this setup.
>
> I told them about the widespread interest in the LiveCode community for
> such a solution, and they’ve kindly made their API demo available for free
> download by any LiveCode developer.
>
> You can download it at:
>
> https://www.hostm.com/tutorials/livecode/api-mariadb-mysql
>
> Hope this helps!
>
> Lyn
>
>
>
> ___
> 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: mySQL Host access

[Peter Haworth]

Hi Alex,
You're probably right on the lc server issue (and thanks for the
compliment).

I already had a library of php db access scripts on my server which I've
been using in batch cron jobson a nightly basis so the guts of what I
needed to do was already in place, whereas I have never installed LC server
or used it.  Now that it's all working I will probably try using LC
server.  My web host is Dreamhost - does anyone know if they support LC
server?

I have all this working now using php middleware.  I ended up using the LC
post command with a command code that indicates what SQL action is required
plus other parameters that contain the required data for the SQL action.

The php script return a JSON containing either the data from SELECT
statements, number of rows affected for INSERT/UPDATE/DELETE, or error
message information if there's a mySQL error.

No SQL commands are sent out, they are all constructed by the sever php
script.  I think, but would like opinions, that doing it that way means I
can embed the data in the SQL commands and not have to worry about
injection attacks since the actual SQL commands go directly from my php
script to mySQL.

Thanks for everyone's input on this.

On Thu, Jan 7, 2016 at 4:17 PM Lyn Teyla <lyn.te...@gmail.com> wrote:

> Peter Haworth wrote:
>
> > Is this common practice when accessing mySQL on a host server?  If so, is
> > there a better way to set about accessing a mySQL database in these
> > circumstances, perhaps using php scripts on the server instead of
> accessing
> > the db directly with the LC database functions?
>
> One of my hosting providers HostM.com has been offering a free
> LiveCode-based MariaDB/MySQL API solution. It was previously available only
> to clients who needed this setup.
>
> I told them about the widespread interest in the LiveCode community for
> such a solution, and they’ve kindly made their API demo available for free
> download by any LiveCode developer.
>
> You can download it at:
>
> https://www.hostm.com/tutorials/livecode/api-mariadb-mysql
>
> Hope this helps!
>
> Lyn
>
>
>
> ___
> 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: mySQL Host access

[Peter Haworth]

OK, thanks Lyn.  I will have to check with my web host (Dreamhost) how to
set LC server up.

On Thu, Jan 7, 2016 at 6:05 PM Lyn Teyla <lyn.te...@gmail.com> wrote:

> Peter Haworth wrote:
>
> > Thanks for that info, that will certainly help me when I start looking
> into
> > LC server.  Unfortunately, I think I'm about 6 months into a 2-year
> > contract with my current web host so probably could not switch at this
> > point.
>
> The stacks are a free download, and from what I can tell, don’t require
> you to be a HostM.com client. You just need to be able to run LiveCode
> Server.
>
> Lyn
>
>
>
> ___
> 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

mySQL Host access

[Peter Haworth]

It seems that to access a mySQL database on my web host's servers from a
Livecode program, I have to configure "Allowable hosts" in the database
configuration.  That can be an ip address or a domain name such as "@.
mydomain.com"

The program in question will be used by perhaps a half dozen users, all
from their home computers and likely using different internet providers so
it appears every time I give the program to a new user, I will have to add
either their ip address (if it's fixed) or a domain as above.

Is this common practice when accessing mySQL on a host server?  If so, is
there a better way to set about accessing a mySQL database in these
circumstances, perhaps using php scripts on the server instead of accessing
the db directly with the LC database functions?

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 
___
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: equivalent to DISTINCT ON (with SUM()) for in-memory SQLite

[Peter Haworth]

I think this will work

SELECT sum(due) from mytable WHERE  ORDER BY cname || caddr GROUP
BY cname || caddr

GROUP may have to come before ORDER, don't remember.



On Thu, Jan 7, 2016 at 4:32 PM Dr. Hawkins  wrote:

> I need to sum amounts and return keys where other fields are the same on an
> in-memory database.
>
> I have my own unique key uniqDna, fields cname and cadr, and numeric field
> due
>
> I want to SUM(due) for each unique cname||cadr, and get get the
> corresponding keys.
>
> DISTINCT ON would due this, but it's not supported by SQLite.
>
> At the moment, I'm not seeing any approach other than returning them all,
> and using cname||cadr as a matrix key, and summing myself.
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> ___
> 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: Dictionary alternatives

[Peter Haworth]

I have a really simple one using the new dictionary access functions in
DP12.  It works fine for the Livecode Script entries but the functions that
return the Livecode Builder and Extensions dictionary info are broken (QCC
report added).  Need to add a generic search function.


Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Sat, Jan 2, 2016 at 5:01 PM, Mike Bonner  wrote:

> Thanks Ali.  Thats one of the things I tried, but got no keys after
> arraydecode. I'll go back and see what I did wrong.  Appreciate it.
>
> Sorry for the tangent richard, alas, now i'm interested in making this
> work, so i'm off to beat my head against the brick wall again.
>
> On Sat, Jan 2, 2016 at 5:34 PM, Richard Gaskin  >
> wrote:
>
> > I appreciate all the good ideas about rolling my own interim fix for
> this,
> > but perhaps I should clarify my interest:
> >
> > Part of my soon-to-be-release devolution 4.0 toolkit includes the ability
> > to switch between standard IDE components and community-based
> > alternatives.  For example, it has a "Browser" button that lets you
> choose
> > between the Project Browser, App Browser, or Navigator.
> >
> > The one common IDE component I can't find an alternative for is the
> > Dictionary.  Many years ago there was the MC Dict, but I stopped
> > maintaining that once I migrated my work to LiveCode v4.6.4.
> >
> > BVG Docu was a very nice alternative, but I'm unsure whether it's still
> > being maintained for v8 forward.  With the changes to the structure of
> the
> > Dictionary content in v8 I would imagine some non-trivial work would be
> > required to rewrite that to import into Docu.
> >
> > So yes, lots of good options for rolling my own.  LC is very flexible and
> > a joy to work with, and as well suited for making Dictionary viewers as
> > anything else.
> >
> > But my goal here is simpler: I'm just looking for currently-maintained
> > Dictionary solutions in our community to make sure they're represented as
> > alternatives in devolution once it's released.  It would be nice to offer
> > at least one if we have a current one in our community, or more if there
> > are other such projects I'm unfamiliar with.
> >
> > --
> >  Richard Gaskin
> >  Fourth World Systems
> >  Software Design and Development for the Desktop, Mobile, and the Web
> >  
> >  ambassa...@fourthworld.comhttp://www.FourthWorld.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: Dictionary alternatives

[Peter Haworth]

Looks like entry_data has a data type of blob so who knows what format it's
in.  There were a bunch of new functions introduced in DP12 to access
various levels of data in the dictionary so might be easier to use those.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Sat, Jan 2, 2016 at 2:19 PM, Mike Bonner  wrote:

> So, can anyone guide me as far as decoding the actual entry data from the
> api.sqlite file?  I'm close to having a basic dictionary browser done, but
> am clueless as far as decoding column "entry_data" from table
> "dictionary_data"
> The sqlite file is located at..
> C:\Program Files (x86)\RunRev\LiveCode Community 8.0 (dp
> 12)\Documentation\html_viewer\resources\data\api\api.sqlite
>
> On Sat, Jan 2, 2016 at 2:16 PM, Richmond 
> wrote:
>
> > On 02/01/16 15:53, Richard Gaskin wrote:
> >
> >> While the Dictionary is being repaired for v8.0dp13, I was hoping to
> >> install an alternative from the community, but alas I can't find one.
> >>
> >> I haven't maintained the one I'd made for MetaCard in years, and BVG
> Docu
> >> appears inaccessible (and I don't even know if it's been updated for v7
> or
> >> v8):
> >> 
> >>
> >> Are there any other alternative Dictionary resources in the community,
> >> other than the web-based mirror at  >?
> >> (I'd prefer something that can be accessible even without an Internet
> >> connection)
> >>
> >> TIA -
> >>
> >>
> > Here's a "quick 'N' dirty" that works as long
> > as you have an internet connexion.
> >
> > http://forums.livecode.com/viewtopic.php?f=6=26203
> >
> > Richmond.
> >
> >
> > ___
> > 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: Question about "that thing you key in that's not a user name when you're logging in"

[Peter Haworth]

Thanks Mark. A search for "thing field" was indeed very helpful.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Tue, Dec 29, 2015 at 5:00 PM, Mark Schonewille <
m.schonewi...@economy-x-talk.com> wrote:

> I have one thing field in this list:
> http://www3.economy-x-talk.com/file.php?node=overview
>
> There have been quite a few discussions about things on this mailing list
> as well as on the forum. I really recommend doing a good search for "thing
> field". Some very clever solutions have been posted.
>
> Kind regards,
>
> Mark Schonewille
> http://economy-x-talk.com
> https://www.facebook.com/marksch
>
> Buy the most extensive book on the
> LiveCode language:
> http://livecodebeginner.economy-x-talk.com
>
> Op 12/30/2015 om 01:33 schreef Peter Haworth:
>
>> Sorry for the cryptic subject line but I sent a prior email with the word
>> that means "that thing you key in that's not a user name when you're
>> logging in" and it got sent to the moderator.  I'll just call it "thing"
>> for the rest of this email.
>>
>> I know there is an "ask thing" command that will replace the thing with
>> black dots as it is being typed in but is there some way to do that using
>> a
>> regular field?  I'm sure I could code it myself but wondering if there's a
>> property of some sort that does it for me.
>>
>> Pete
>> lcSQL Software <http://www.lcsql.com>
>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>> ___
>> 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

Question about "that thing you key in that's not a user name when you're logging in"

[Peter Haworth]

Sorry for the cryptic subject line but I sent a prior email with the word
that means "that thing you key in that's not a user name when you're
logging in" and it got sent to the moderator.  I'll just call it "thing"
for the rest of this email.

I know there is an "ask thing" command that will replace the thing with
black dots as it is being typed in but is there some way to do that using a
regular field?  I'm sure I could code it myself but wondering if there's a
property of some sort that does it for me.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 
___
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: Question about "that thing you key in that's not a user name when you're logging in"

[Peter Haworth]

That's the one I went with. I might adapt it to show each character briefly
before hiding it and/or provide an option to show it in plain text.

On Tue, Dec 29, 2015, 7:19 PM J. Landman Gay <jac...@hyperactivesw.com>
wrote:

> On 12/29/2015 6:33 PM, Peter Haworth wrote:
> > I know there is an "ask thing" command that will replace the thing with
> > black dots as it is being typed in but is there some way to do that
> using a
> > regular field?
>
> Here is my favorite approach:
>
> <
> http://runtime-revolution.278305.n4.nabble.com/custom-password-dialogue-tp290635p290644.html
> >
>
> After I read Bill Marriott's solution, I adopted it forever after. It
> requires almost no work at all and takes advantage of LC's built-in text
> handling. Very easy.
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.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: Two SQLITE RevBD questions

[Peter Haworth]

Hi James,
No need to escape quotes when using bound variables.

You'll still need to encode your date before inserting it and decode it
when selecting it or you'll lose its utf8-ness.

On Sat, Dec 26, 2015, 6:44 AM James Hale  wrote:

> I am moving my app from LC6 to LC7 (in prep for LC8) and have a couple of
> questions regarding some changes I have made in the way I use SQLITE.
>
> 1. Escaping quotes when using binding variables
>
> Originally I was doing the standard INSERT into the DB where I constructed
> my SQL and then used "revExecuteSQL"
>put "INSERT INTO content "& sq_cols & sq_values into tsql
>revExecuteSQL db_conn_id,tsql
>
> Where sq_cols was a string of the columns in the content table and sq_vals
> was a concatenated string of the actual values (each enclosed in quotes).
> I also escaped any quotes within these values.
>
> I decided to change this to the binding form where I now placed the values
> into an array and simply bound them to the column names as in...
>
>   put "INSERT INTO content "_cols&" VALUES(:1,:2,:3,:4,:5,:6)" into
> tsql
>   revExecuteSQL db_conn_id,tsql,"varray"
>
> Where "varray" is an array with 6 values.
>
> My question is: Do I need to escape quotes in these values?
>
> 2. All text data us UTF8 encoded having been read in from their original
> source via "textDecode(variable,"UTF8") (LC7 version)
> The values I store and read into my db will only be read by my app.
> Do I need to encode them before storing and then decode them on reading
> given my app is the only access?
>
>
> 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: [OT] Configure web server to parse php in .html files

[Peter Haworth]

Update on this.

Just got an email from Dreamhost support to use:

AddHandler fcgid-script .html
FCGIWrapper "/dh/cgi-system/php55.cgi" .html

That does indeed work.  However I also need to enable SSI in html files
with "AddHandler server-parsed .html" and if that line is in there, the php
isn;t parsed.

So now I guess the question is how to get both php and ssi parsed in html
files.



Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Dec 23, 2015 at 10:03 AM, Peter Haworth <p...@lcsql.com> wrote:

> I've just finished my first php script that needs to be embedded in a file
> with a .html extension.  The php script is in a file referenced with a php
> require command in the .html file.
>
> The script does not run when the web page is loaded unless I change the
> file extension to .php.
>
> I believe there are directives that can be put into my .htaccess file to
> should cause files with a .html extension to be parsed for php,  I've tried
> the following directives I found on the web and none of them work:
>
> AddHandler x-httpd-php .html .htm
>
> AddHandler php-script .php .html .htm
>
> AddHandler php5-script .php .html .htm
>
> AddType application/x-httpd-php .htm
> AddType application/x-httpd-php .html
>
> The last two of the above caused any url for a page on my website to start
> a download (using Chrome).
>
> Anyone have the correct directive?
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
___
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

[OT] Configure web server to parse php in .html files

[Peter Haworth]

I've just finished my first php script that needs to be embedded in a file
with a .html extension.  The php script is in a file referenced with a php
require command in the .html file.

The script does not run when the web page is loaded unless I change the
file extension to .php.

I believe there are directives that can be put into my .htaccess file to
should cause files with a .html extension to be parsed for php,  I've tried
the following directives I found on the web and none of them work:

AddHandler x-httpd-php .html .htm

AddHandler php-script .php .html .htm

AddHandler php5-script .php .html .htm

AddType application/x-httpd-php .htm
AddType application/x-httpd-php .html

The last two of the above caused any url for a page on my website to start
a download (using Chrome).

Anyone have the correct directive?

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 
___
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] Configure web server to parse php in .html files

[Peter Haworth]

Thanks Mark.  Did you mean "It might be insecure" :-)

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Dec 23, 2015 at 10:25 AM, Mark Schonewille <
m.schonewi...@economy-x-talk.com> wrote:

> Hi Peter,
>
> I have the following at the end of my php.conf file:
>
> # PHP5 module
> LoadModule php5_module "c:/php/php5apache2_2.dll"
> AddType application/x-httpd-php .php .htx .htm .html
> PHPIniDir "C:/php"
>
> I added .htm and .html for testing. This works. I don't recommend using
> this approach. I might be insecure.
>
> Kind regards,
>
> Mark Schonewille
> http://economy-x-talk.com
> https://www.facebook.com/marksch
>
> Buy the most extensive book on the
> LiveCode language:
> http://livecodebeginner.economy-x-talk.com
>
> Op 12/23/2015 om 19:03 schreef Peter Haworth:
>
>> I've just finished my first php script that needs to be embedded in a file
>> with a .html extension.  The php script is in a file referenced with a php
>> require command in the .html file.
>>
>> The script does not run when the web page is loaded unless I change the
>> file extension to .php.
>>
>> I believe there are directives that can be put into my .htaccess file to
>> should cause files with a .html extension to be parsed for php,  I've
>> tried
>> the following directives I found on the web and none of them work:
>>
>> AddHandler x-httpd-php .html .htm
>>
>> AddHandler php-script .php .html .htm
>>
>> AddHandler php5-script .php .html .htm
>>
>> AddType application/x-httpd-php .htm
>> AddType application/x-httpd-php .html
>>
>> The last two of the above caused any url for a page on my website to start
>> a download (using Chrome).
>>
>> Anyone have the correct directive?
>>
>> Pete
>> lcSQL Software <http://www.lcsql.com>
>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>> ___
>> 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: [OT] Configure web server to parse php in .html files

[Peter Haworth]

Thanks for the xbithack link. I'd come to the conclusion that it's not
possible to enable SSI and php parsing via the .htaccess file for one
website.  I've replaced my SSI commands with simple php include scripts and
all seems to be working.  But I'll check out the link.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Dec 23, 2015 at 10:22 AM, Peter Haworth <p...@lcsql.com> wrote:

> Update on this.
>
> Just got an email from Dreamhost support to use:
>
> AddHandler fcgid-script .html
> FCGIWrapper "/dh/cgi-system/php55.cgi" .html
>
> That does indeed work.  However I also need to enable SSI in html files
> with "AddHandler server-parsed .html" and if that line is in there, the php
> isn;t parsed.
>
> So now I guess the question is how to get both php and ssi parsed in html
> files.
>
>
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
> On Wed, Dec 23, 2015 at 10:03 AM, Peter Haworth <p...@lcsql.com> wrote:
>
>> I've just finished my first php script that needs to be embedded in a
>> file with a .html extension.  The php script is in a file referenced with a
>> php require command in the .html file.
>>
>> The script does not run when the web page is loaded unless I change the
>> file extension to .php.
>>
>> I believe there are directives that can be put into my .htaccess file to
>> should cause files with a .html extension to be parsed for php,  I've tried
>> the following directives I found on the web and none of them work:
>>
>> AddHandler x-httpd-php .html .htm
>>
>> AddHandler php-script .php .html .htm
>>
>> AddHandler php5-script .php .html .htm
>>
>> AddType application/x-httpd-php .htm
>> AddType application/x-httpd-php .html
>>
>> The last two of the above caused any url for a page on my website to
>> start a download (using Chrome).
>>
>> Anyone have the correct directive?
>>
>> Pete
>> lcSQL Software <http://www.lcsql.com>
>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>>
>
>
___
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: Release 8.0 DP 12

[Peter Haworth]

I guess one man's meat is another man's poison. For me, DP12 is pretty much
unusable since about 50% of the time, debugging is impossible due to
the"pink variables" issue.

On Tue, Dec 22, 2015, 7:29 AM Trevor DeVore 
wrote:

> On Tue, Dec 22, 2015 at 8:52 AM, panagiotis merakos 
> wrote:
>
> >
> > However, since the DP 12 release contains 25
> > bugfixes plus some more features, we thought it would be better to
> release
> > it before the Christmas break. This will give plenty of time to both the
> > community and the LiveCode team to do some further testing, report bugs
> and
> > have them fixed in the next release.
> >
>
> I'm glad you released it. Previous DPs had a serious memory bug that would
> cause LiveCode to crash a lot when I was using it. DP-12 fixes it and I can
> now get a lot of work done with it, even with the bugs.
>
> --
> Trevor DeVore
> ScreenSteps
> www.screensteps.com-www.clarify-it.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: Release 8.0 DP 12

[Peter Haworth]

I haven't narrowed down the cause of it yet, but the variables tab of the
script editor window is sometimes colored pink. The bigger issue is when
that happens, no variable names or contents are visible.

I remember the Pink Variables back in the day.  They once opened for the
Blue Meanies.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Tue, Dec 22, 2015 at 11:49 AM, Monte Goulding <mo...@appisle.net> wrote:

> I haven't pulled and built the latest yet. What's the pink variables
> issue? Sounds like a good band name to me ;-)
>
> Sent from my iPhone
>
> > On 23 Dec 2015, at 3:18 am, Peter Haworth <p...@lcsql.com> wrote:
> >
> > the"pink variables" issue.
>
> ___
> 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: Release 8.0 DP 12

[Peter Haworth]

The dictionary window has no content.

Adding a Tree View Widget then deleting it leaves the selection handles
visible.

Selecting a tree view highlights part of it in pink.  After doing that, the
variables tab of the Script Editor window is one big pink blob with no
variable names/contents visible.

I don't remember how I did this now, but prior to this version, the handler
list  at the left of the script editor window was hidden and a dropdown
menu of handler names was at the top of the window.  The dropdown menu is
still there but so is the list at the right.  In addition the handler list
is initially empty; its content appears when I resize it.

Similar issues as already reported on showing the script editor window.

I'm thinking it was not a good decision to rush this out before going on
Christmas break.



Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Mon, Dec 21, 2015 at 11:30 AM, Paul Hibbert  wrote:

> +1
>
> Paul
>
> > On Dec 21, 2015, at 10:17 AM, John Dixon  wrote:
> >
> >
> > Yes... I see this as well..
> >
> >
> >> Subject: Re: Release 8.0 DP 12
> >> To: use-livecode@lists.runrev.com
> >> From: mwie...@ahsoftware.net
> >> Date: Mon, 21 Dec 2015 10:05:07 -0800
> >>
> >> On 12/21/2015 08:10 AM, panagiotis merakos wrote:
> >>
> >>> Warning: this is not a stable release. Please ensure you back up your
> >>> stacks before testing them.
> >>
> >> Interesting.
> >>
> >> It now takes two attempts to edit a script in either the Application
> >> Browser or the Project Browser. The first attempt right-clicking on the
> >> object you want to edit brings up the contextual menu, and selecting
> >> "Edit script" starts a spinning cursor. Ignoring that, clicking
> >> somewhere else, and trying again brings up the script editor.
> >>
> >> Note that if you're using the AB, the script editor comes up *behind*
> >> it, which is somewhat annoying, but whatever.
> >>
> >> http://quality.livecode.com/show_bug.cgi?id=16641
> >>
> >> --
> >>  Mark Wieder
> >>  ahsoftw...@gmail.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
>
___
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: Release 8.0 DP 12

[Peter Haworth]

Thanks Jim.  Glad lcsb is behaving itself, lots of changes necessary for
LC8.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Mon, Dec 21, 2015 at 1:33 PM, James Little <littlejam...@mac.com> wrote:

> @ Pete
>
> I’m seeing both the absent dictionary content and the pink widget tree
> view on Mac 10.9.5.  The tree view issue resolved when I quit and restarted
> Livecode but still get no content in the dictionary.
>
> DP12 does seem faster and the browser widget has more features.  I built a
> complex standalone for Mac with a browser widget and a tree view widget and
> both work well on initial testing.
>
> I have lcStackBrowser open and it seems to be functioning well on my
> limited testing so far.
>
> Jim
>
>
>
> On Dec 21, 2015, at 1:11 PM, Peter Haworth <p...@lcsql.com> wrote:
>
> > The dictionary window has no content.
> >
> > Adding a Tree View Widget then deleting it leaves the selection handles
> > visible.
> >
> > Selecting a tree view highlights part of it in pink.  After doing that,
> the
> > variables tab of the Script Editor window is one big pink blob with no
> > variable names/contents visible.
> >
> > I don't remember how I did this now, but prior to this version, the
> handler
> > list  at the left of the script editor window was hidden and a dropdown
> > menu of handler names was at the top of the window.  The dropdown menu is
> > still there but so is the list at the right.  In addition the handler
> list
> > is initially empty; its content appears when I resize it.
> >
> > Similar issues as already reported on showing the script editor window.
> >
> > I'm thinking it was not a good decision to rush this out before going on
> > Christmas break.
> >
> >
> >
> > Pete
> > lcSQL Software <http://www.lcsql.com>
> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
> >
> > On Mon, Dec 21, 2015 at 11:30 AM, Paul Hibbert <p...@livecode.org>
> wrote:
> >
> >> +1
> >>
> >> Paul
> >>
> >>> On Dec 21, 2015, at 10:17 AM, John Dixon <dixo...@hotmail.co.uk>
> wrote:
> >>>
> >>>
> >>> Yes... I see this as well..
> >>>
> >>>
> >>>> Subject: Re: Release 8.0 DP 12
> >>>> To: use-livecode@lists.runrev.com
> >>>> From: mwie...@ahsoftware.net
> >>>> Date: Mon, 21 Dec 2015 10:05:07 -0800
> >>>>
> >>>> On 12/21/2015 08:10 AM, panagiotis merakos wrote:
> >>>>
> >>>>> Warning: this is not a stable release. Please ensure you back up your
> >>>>> stacks before testing them.
> >>>>
> >>>> Interesting.
> >>>>
> >>>> It now takes two attempts to edit a script in either the Application
> >>>> Browser or the Project Browser. The first attempt right-clicking on
> the
> >>>> object you want to edit brings up the contextual menu, and selecting
> >>>> "Edit script" starts a spinning cursor. Ignoring that, clicking
> >>>> somewhere else, and trying again brings up the script editor.
> >>>>
> >>>> Note that if you're using the AB, the script editor comes up *behind*
> >>>> it, which is somewhat annoying, but whatever.
> >>>>
> >>>> http://quality.livecode.com/show_bug.cgi?id=16641
> >>>>
> >>>> --
> >>>> Mark Wieder
> >>>> ahsoftw...@gmail.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
> >>
> > ___
> > 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: Improving the dictionary [was: LiveCode release notes]

[Peter Haworth]

Thanks Monte, looks like that might help.


Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Dec 16, 2015 at 12:08 PM, Monte Goulding <mo...@appisle.net> wrote:

> Pete they are all little markdown files in the livecode repo:
>
> https://github.com/livecode/livecode/tree/develop/docs/notes <
> https://github.com/livecode/livecode/tree/develop/docs/notes>
>
> You can use git to extract a list of notes added between two tagged
> versions:
>
> put shell("git diff 6.7.8-rc-4 6.7.8 --diff-filter=AM --name-only —
> ‘docs/notes'") into tFiles
>
> You probably want to modify this to add stuff to a database:
>
> https://github.com/livecode/livecode/blob/develop/builder/release_notes_builder.livecodescript
>
>
> > On 17 Dec 2015, at 6:02 am, Peter Haworth <p...@lcsql.com> wrote:
> >
> > That would certainly help.  I still believe a fully searchable database
> of
> > the release notes would be useful though and still willing to take that
> > on.  I need to be able to minimize or even eliminate the manual effort
> > required to enter the release note data into the database.  I don't
> believe
> > I can do that using the pdf versions of the release notes so if there is
> > indeed an html version somewhere as mentioned recently, I'd love to get
> > access to it in the hope that I can parse it programmatically and load it
> > into the database.
> >
> > Pete
> > lcSQL Software <http://www.lcsql.com>
> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
> >
> > On Wed, Dec 16, 2015 at 12:50 AM, Peter TB Brett <
> peter.br...@livecode.com>
> > wrote:
> >
> >> On 15/12/2015 19:26, Mark Wieder wrote:
> >>
> >>> On 12/15/2015 11:09 AM, J. Landman Gay wrote:
> >>>
> >>> Most of the entries do show the initial release date in the dictionary
> >>>> but the problem is that we often can't recall what term to look up.
> >>>>
> >>>
> >>> Also, bug fixes don't necessarily fall into that category and probably
> >>> won't show up in the dictionary.
> >>>
> >>
> >> Anything that changes the behaviour of the syntax definitely should be
> >> noted in the dictionary.
> >>
> >> If it doesn't change the behaviour but just, for example, improves
> >> performance or fixes a crash in a pathological case, then it generally
> >> shouldn't be noted in the dictionary.
> >>
> >> The core dev team tries very hard to *not* change behaviour of existing
> >> script syntax where it can be avoided -- because it's important not to
> >> break stacks that currently work (c.f. discussion about "save" vs
> >> "stackFileVersion").
> >>
> >> I would like the dictionary to have a way to search its entries by "last
> >> changed in", "introduced in", and "deprecated in", but it currently
> looks
> >> like we won't have time to introduce that in 8.0.0.
> >>
> >>Peter
> >>
> >> --
> >> Dr Peter Brett <peter.br...@livecode.com>
> >> LiveCode Open Source Team
> >>
> >> LiveCode on reddit: https://reddit.com/r/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
>
> ___
> 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: Improving the dictionary [was: LiveCode release notes]

[Peter Haworth]

That would certainly help.  I still believe a fully searchable database of
the release notes would be useful though and still willing to take that
on.  I need to be able to minimize or even eliminate the manual effort
required to enter the release note data into the database.  I don't believe
I can do that using the pdf versions of the release notes so if there is
indeed an html version somewhere as mentioned recently, I'd love to get
access to it in the hope that I can parse it programmatically and load it
into the database.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Wed, Dec 16, 2015 at 12:50 AM, Peter TB Brett 
wrote:

> On 15/12/2015 19:26, Mark Wieder wrote:
>
>> On 12/15/2015 11:09 AM, J. Landman Gay wrote:
>>
>> Most of the entries do show the initial release date in the dictionary
>>> but the problem is that we often can't recall what term to look up.
>>>
>>
>> Also, bug fixes don't necessarily fall into that category and probably
>> won't show up in the dictionary.
>>
>
> Anything that changes the behaviour of the syntax definitely should be
> noted in the dictionary.
>
> If it doesn't change the behaviour but just, for example, improves
> performance or fixes a crash in a pathological case, then it generally
> shouldn't be noted in the dictionary.
>
> The core dev team tries very hard to *not* change behaviour of existing
> script syntax where it can be avoided -- because it's important not to
> break stacks that currently work (c.f. discussion about "save" vs
> "stackFileVersion").
>
> I would like the dictionary to have a way to search its entries by "last
> changed in", "introduced in", and "deprecated in", but it currently looks
> like we won't have time to introduce that in 8.0.0.
>
> Peter
>
> --
> Dr Peter Brett 
> LiveCode Open Source Team
>
> LiveCode on reddit: https://reddit.com/r/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 conundrum

[Peter Haworth]

Hi James,
Very strange. I seriously doubt sqlite is manipulating the data in any way.
Are you displaying the data using lc calls? Don't recall if you are an
SQLiteAdmin customer but if so, I suggest you go to the SQL tab, execute an
insert with sample data, then execute a select statement to display it. The
SQL tab passes all commands to the sqlite3 command line tool and does not
use any lc db calls so that should help narrow down where the problem is
occurring. You could also do it by running sqlite3 directly of course.

On Tue, Dec 15, 2015, 7:26 AM James Hale  wrote:

> I have an array of text values (actually book chapters) that I am adding
> to a database.
> The text is a mixture of alphabetic and numerals.
> For some of it I have line numbers at the beginning of each paragraph.
> E.g
> blah blah1. Blah blah more blah.2. Some more blah
>
> After I insert this text into my database the line numbers have been
> deleted.
> If I look at the db record I see...
> blah blahBlah blah more blah.Some more blah
>
> Yet other numbers contained within the text are still present.
>
> If I examine the SQL values I pass to the INSERT statement the numbers are
> still present.
>  In the text.
> They just don't appear in the db!
>
> I thought it might be a general thing  such as a number followed by a
> period is rejected, but I also create some FTS tables which have entries
> for each of these lines. In this case it is without the HTML tags but each
> line (corresponding to a paragraph of text) begins with a number as in...
>1. Blah blah more blah.
> And these are correctly stored in the table.
>
> Does anyone have any idea as to what might be deleting the numbers?
>
> 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: Improving the LiveCode release notes

[Peter Haworth]

I  guess this next thought would be dealt with if we had the search
capability that's been mentioned but I'd prefer the release notes to be
ordered primarily by the release (DP!, DP2, etc) and within that the
various sections for that release (Engine Changes, IDE Changes, Bug Fixes,
etc).

I agree with Monte that the whole section on Platform Support,
Installation, etc should be in a separate document with the release notes
only documenting any changes that apply to that document.

The LC8 Release notes also include several pages of information about
widgets which I think should be in a separate document, referred to by the
release notes where necessary.  But then that gets into the whole issue of
getting the User Guide updated (or having a separate Widgets Guide), which
is where the Widget information should be.

Having said all that, I think LC8 is not a typical release since there have
been so many DP releases and presumably there'll be RC releases too before
we're done.

Going back to the search issue, I'd be willing to spend some time creating
a database and an LC app to query, sort and extract.  Creating the DB and
the app won't be difficult, populating the db will be the hard part since I
think everything is in pdf format.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Tue, Dec 15, 2015 at 9:16 AM, Mark Wieder  wrote:

> On 12/15/2015 01:00 AM, Peter TB Brett wrote:
>
> How about alphabetizing the Dictionary Additions and Dictionary Changes
>>> lists?
>>>
>>
>> Good plan.
>>
>> How useful are those sections?  Does anyone actually rely on them for
>> anything?
>>
>
> Well, *I* do, but maybe it's just me. When we do weekly releases at work I
> do the same for historical tracking. Otherwise it's really hard to query a
> bug-tracking tool (I'm talking at you, bugzilla) to get a list of the bugs
> that were fixed/features added for a given release. If a bug that was fixed
> in a previous release pops up again in a later one, I can go back in the
> release notes and see when it was fixed, and that narrows the window for
> finding the code changes. But if I'm the only one who cares about this
> stuff then I'm ok with dropping the sections from the release notes.
>
> --
>  Mark Wieder
>  ahsoftw...@gmail.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: Improving the LiveCode release notes

[Peter Haworth]

Thanks, good to know.



Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Tue, Dec 15, 2015 at 10:52 AM, Peter TB Brett <peter.br...@livecode.com>
wrote:

> On 2015-12-15 17:33, Peter Haworth wrote:
>
> The LC8 Release notes also include several pages of information about
>> widgets which I think should be in a separate document, referred to by the
>> release notes where necessary.  But then that gets into the whole issue of
>> getting the User Guide updated (or having a separate Widgets Guide), which
>> is where the Widget information should be.
>>
>
> There's already a separate widgets guide, which contains all of the
> explanatory information from the release notes, in more detail, and much
> more besides.  It's available in the "Guides" tab of the dictionary stack
> -- you're looking for the "Extending LiveCode" guide.  The bits on widgets
> in the release notes are just a summary (for people who haven't used LC8
> before) and info on what's changed since earlier developer preview releases
> (for people who have).
>
> BTW, Ali has done some work today on improving the layout and
> accessibility of the guides in the IDE.
>
>  Peter
>
> --
> Dr Peter Brett <peter.br...@livecode.com>
> LiveCode Open Source Team
>
> LiveCode on reddit! <https://reddit.com/r/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

Printing Problem

[Peter Haworth]

I have a form with two fields on it:

- A field control that contains the text to be used as a heading
- A scrolling list field with the main text to be printed.

I'm using the following to print :

revPrintText (the htmlText of field "AttendeeList"),(the htmlText of field
"Heading")

The printed document shows the heading OK. It prints the contents of the
scrolling list field down to the bottom of the first page.  At the top of
the second page, the last 8 lines of the first page are repeated before
printing the rest of the scrolling list field contents.

Trying to figure out why the repeated lines are being printed.

This is on OSX 10.10 and LC8 DP11



Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 
___
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: Printing Problem

[Peter Haworth]

I'd also add to this that I used the htmltext of the field because some
text in it is in bold.  HOwever the bold does not show up on the printed
version.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Sat, Dec 12, 2015 at 10:20 AM, Peter Haworth <p...@lcsql.com> wrote:

> I have a form with two fields on it:
>
> - A field control that contains the text to be used as a heading
> - A scrolling list field with the main text to be printed.
>
> I'm using the following to print :
>
> revPrintText (the htmlText of field "AttendeeList"),(the htmlText of field
> "Heading")
>
> The printed document shows the heading OK. It prints the contents of the
> scrolling list field down to the bottom of the first page.  At the top of
> the second page, the last 8 lines of the first page are repeated before
> printing the rest of the scrolling list field contents.
>
> Trying to figure out why the repeated lines are being printed.
>
> This is on OSX 10.10 and LC8 DP11
>
>
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
___
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: Release 8.0 DP 11

[Peter Haworth]

I've found two bugs already but the QCC does not have an option to specify
DP11 in the version dropdown.

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 

On Thu, Dec 10, 2015 at 8:27 AM, Ali Lloyd  wrote:

> Dear list members,
>
> We are pleased to announce the release of LiveCode 8.0 DP 11.
>
> Warning: this is not a stable release. Please ensure you back up your
> stacks before testing them.
>
> *Release contents*
>
> *HTML 5 Enhancements*
> The following have been added for HTML 5 standalones in DP 11
> - ability to use 'wait'
> - ability to write to stdout / stderr
>
> *Linux printing*
> The Linux printing commands now use revpdfprinter to generate a PDF to send
> through the
> system printing process. Among other things, this means that there is now
> full support for
> Unicode text.
>
> *Application Browser*
> The application browser, which was missing from the DP 9 and 10 installers,
> has been
> reinstated.
>
> *LiveCode Builder*
> Number -> string formatting has been improved so that it should no longer
> be necessary
> to strip trailing zeroes.
> Access to the current clipping bounds in OnPaint has been added.
>
> *Documentation API*
> Part a new documentation API has been added, allowing access to individual
> entries in the
> LiveCode Script dictionary.
>
> *31 bug fixes*
>
> *Known Issues*
> - Cef Browser (and therefore the dictionary and browser widget) does not
> currently work on 32-bit Linux
> - HTML 5 standalones do not currently function when they contain extensions
> with dependencies.
>
> *Getting the release*
> You can get the release at http://downloads.livecode.com/livecode/
>
> LiveCode 8 is still in development so we’d love to hear any
> feedback you have on it. There are a number of features that we’d like to
> implement but aren’t ready yet and the existing features are subject to
> change during development - we can’t guarantee that extensions written in
> Developer Previews will continue to work the same way in later versions.
>
> Please report any bugs encountered on our Bugzilla at
> http://quality.livecode.com/
>
> We have a forum available for discussing LiveCode Builder at
> http://forums.livecode.com/viewforum.php?f=93
>
> The LiveCode Team
> ___
> 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