Re: Regular Expressions in IDE

2016-10-26 Thread 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

Re: Eureka Moment: preopencontrol

2016-10-24 Thread 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 ye

Re: Bug report against lcStackBrowser

2016-10-10 Thread 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 wrote: > You had me worried for a minute there Richard! &g

Re: Bug report against lcStackBrowser

2016-10-10 Thread 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

Re: getting the "normal" messages when reopening a stack

2016-09-24 Thread 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

Re: SQL joining from list of values to match single value?

2016-09-08 Thread 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

Re: Wouldn't it be neat...

2016-08-20 Thread 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 feature

Re: [SQL] placeholders work for SQLite but not for mySQL

2016-08-08 Thread 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 does

lcStackBrowser v 2.2.4 released

2016-08-03 Thread 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

Re: [ ANN ] Release 8.1.0 DP-3

2016-08-02 Thread 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 Warwi

Re: A DataGrid is not a spreadsheet

2016-07-29 Thread 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

Re: Backspace unrecoverably deletes an object ....

2016-07-20 Thread 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 Nuge

the templateControl

2016-07-06 Thread 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 any

Re: New version of lcStackbrowser Released

2016-06-30 Thread Peter Haworth
; > 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

New version of lcStackbrowser Released

2016-06-29 Thread Peter Haworth
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 Li

Re: Storing and retrieving data from a SQL database

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

Re: Storing and retrieving data from a SQL database

2016-05-20 Thread 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 wha

Re: Storing and retrieving data from a SQL database

2016-05-19 Thread 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 libra

Re: Storing and retrieving data from a SQL database

2016-05-19 Thread Peter Haworth
As Mike said, there's no need to do that. Use the variables list parameter when inserting/updating your data, and revQueryDatabase to create a cursor when selecting the data. RevDataFromQuery would probably work too with the right column/row delimiters. On Wed, May 18, 2016, 8:01 PM Lyn Teyla wro

Re: Clearing local variables

2016-04-29 Thread 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,

Re: Error: Unable to open the database file

2016-04-08 Thread 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 wrote: > On 04/07/2016 06:41 PM, Peter Haworth wrote: > > Right,

Re: Error: Unable to open the database file

2016-04-07 Thread Peter Haworth
mportant 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 wrote: > On Wed, Apr 6, 2016 at 1:03 PM, Peter Haworth wrote: > > > Now y

Re: Error: Unable to open the database file

2016-04-06 Thread Peter Haworth
I just can't be bothered replying to that... On Wed, Apr 6, 2016 at 1:55 PM Mark Wieder 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 &g

Re: Error: Unable to open the database file

2016-04-06 Thread Peter Haworth
;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 wrote: > This is where it gets interesting. My original plan was to directly > conn

Re: Error: Unable to open the database file

2016-04-06 Thread Peter Haworth
se 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. > > >

Re: Error: Unable to open the database file

2016-04-06 Thread 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 wrote: > On Wed, Apr 6, 2016 at 9:42

Re: Error: Unable to open the database file

2016-04-06 Thread 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. p

Re: Error: Unable to open the database file

2016-04-05 Thread Peter Haworth
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. > > sq

Re: Error: Unable to open the database file

2016-04-05 Thread 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

Re: How to make the group itself a target

2016-04-01 Thread 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

Re: Script Only Stack Architecture

2016-04-01 Thread 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

Re: Script Only Stack Architecture

2016-03-30 Thread 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'

Re: negating in a regexp

2016-03-30 Thread 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. Hawki

Re: negating in a regexp

2016-03-30 Thread 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

Re: LC8DP15 feedback-IDE Issues

2016-03-02 Thread 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: > > > O

Re: LC8DP15 feedback-IDE Issues

2016-03-01 Thread 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

Re: Possible enhancement

2016-02-28 Thread Peter Haworth
I use a true/false flag which has to be checked at each control structure level. As far as I know, that's the only way, but maybe not... On Sun, Feb 28, 2016, 9:37 AM [-hh] wrote: > >> Peter H. wrote: > >> The php break statement has a numeric argument that defines how many > >> control structur

Re: Possible enhancement

2016-02-27 Thread Peter Haworth
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 .

Possible enhancement

2016-02-27 Thread 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

Re: Players in HTML5 - ETA for Full Functionality?

2016-02-26 Thread 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: >

Re: DataGrid

2016-02-25 Thread 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 bo

Re: Send multiple variables to a URL with POST to SQLSRV + php

2016-02-24 Thread Peter Haworth
Looks like you missed an "=", should be "&tCorreo="&correo? 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 & > "&tPWD=" & PWD & "&tCorreo"&corr

Re: Email Test 1

2016-02-24 Thread 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

Re: LCB: Error: illegal escape in string

2016-02-23 Thread 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 fin

Re: Finding UTC

2016-02-21 Thread 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 [-

Re: Help using database & data conversion

2016-02-16 Thread 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, 2

Re: changing the size of the image that's combined with text

2016-02-16 Thread 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.

Re: changing the size of the image that's combined with text

2016-02-16 Thread 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

Re: sqlite db password?

2016-02-11 Thread 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

Re: shadow declarations bug back?

2016-02-11 Thread Peter Haworth
> 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

Re: shadow declarations bug back?

2016-02-11 Thread 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 run

DP14 Tooltip

2016-02-08 Thread 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 preferenc

Re: Black icons in LC 8 DP 14

2016-02-08 Thread 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.

Re: LC 6.7.8 won't load

2016-02-07 Thread 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 an

Re: LC 6.7.8 won't load

2016-02-07 Thread 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 w

Re: LC 6.7.8 won't load

2016-02-07 Thread 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

Re: LC 6.7.8 won't load

2016-02-06 Thread 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. > > Y

LC 6.7.8 won't load

2016-02-06 Thread 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?

Re: LC8 Save command

2016-02-06 Thread Peter Haworth
d > 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 wrote: > > > I'm happy to use the "with format" option, just trying to figure out how > > the get

Re: LC8 Save command

2016-02-06 Thread Peter Haworth
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 wrote: > On 02/05/2016 0

LC8 Save command

2016-02-05 Thread 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

Re: Release 8.0 DP 14

2016-02-04 Thread 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:3

Re: AW: How to create a hyperlink within a text field?

2016-02-04 Thread 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 fo

Re: AW: Re: Regex help needed...

2016-02-03 Thread 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 o

Re: launch document problem

2016-01-28 Thread Peter Haworth
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 wrote: > Hi Pete, > > On 2016-01-28 01:26, Pe

Re: launch document problem

2016-01-27 Thread Peter Haworth
ile 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 wrote: > Still get a "can't

Re: launch document problem

2016-01-27 Thread Peter Haworth
lcsql.com/sqliteadmin.html> On Wed, Jan 27, 2016 at 3:53 PM, Phil Davis 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 fa

Re: launch document problem

2016-01-27 Thread Peter Haworth
.com/sqliteadmin.html> On Wed, Jan 27, 2016 at 1:18 PM, Mark Wieder 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 >> occurrin

launch document problem

2016-01-27 Thread 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 n

Printing to pdf

2016-01-24 Thread 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

Re: Http Header question

2016-01-20 Thread 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 v

Version 2.2.2 of lcStackbrowser

2016-01-16 Thread 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.h

Re: Release: 8.0 DP 13 -- Image Library?

2016-01-16 Thread 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, A

Re: Message watcher in LC 8

2016-01-14 Thread 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.

Re: Windows 10 system version

2016-01-11 Thread 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

Re: Windows 10 system version

2016-01-11 Thread 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 > > __

Re: mySQL Host access

2016-01-07 Thread 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 wrote: > Peter Haworth wrote: > > > Thanks for that info, that will certainly help me when I start looking > into > > LC server. Unfortunate

Re: equivalent to DISTINCT ON (with SUM()) for in-memory SQLite

2016-01-07 Thread 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

Re: mySQL Host access

2016-01-07 Thread 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 wrote: > Peter

Re: mySQL Host access

2016-01-07 Thread Peter Haworth
for everyone's input on this. On Thu, Jan 7, 2016 at 4:17 PM Lyn Teyla 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 > > circu

mySQL Host access

2016-01-07 Thread 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,

Re: Dictionary alternatives

2016-01-03 Thread 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

Re: Dictionary alternatives

2016-01-02 Thread 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

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

2015-12-29 Thread 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 wrote: > On 12/29/2015 6:33 PM, Peter Haworth wrote: > > I know there is an "ask thing

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

2015-12-29 Thread Peter Haworth
oing 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://live

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

2015-12-29 Thread 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 repla

Re: Two SQLITE RevBD questions

2015-12-26 Thread 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

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

2015-12-23 Thread Peter Haworth
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 wrote: > Update on this. > > Just got an email from Dreamh

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

2015-12-23 Thread Peter Haworth
"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 bo

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

2015-12-23 Thread Peter Haworth
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> O

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

2015-12-23 Thread 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

Re: Release 8.0 DP 12

2015-12-22 Thread Peter Haworth
at'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 wrote: > > > > the"pink variables" issue. > > ___ >

Re: Release 8.0 DP 12

2015-12-22 Thread 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: > > > > >

Re: Release 8.0 DP 12

2015-12-21 Thread Peter Haworth
er 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 > > > >

Re: Release 8.0 DP 12

2015-12-21 Thread 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

Re: Improving the dictionary [was: LiveCode release notes]

2015-12-16 Thread Peter Haworth
t; > 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 >

Re: Improving the dictionary [was: LiveCode release notes]

2015-12-16 Thread 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

Re: Improving the LiveCode release notes

2015-12-15 Thread 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

Re: Improving the LiveCode release notes

2015-12-15 Thread Peter Haworth
>> On December 15, 2015 11:33:31 AM CST, Peter Haworth >> wrote: >> >>> >>> 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 >>> a

Re: Improving the LiveCode release notes

2015-12-15 Thread 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 wrote: > On 2015-12-15 17:33

  1   2   3   4   5   6   7   8   9   10   >