Re: SQLite conundrum

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

Re: Printing Problem

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

Re: Printing Problem

2015-12-12 Thread Peter Haworth
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Dec 12, 2015 at 10:20 AM, Peter Haworth 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. &

Printing Problem

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

Re: Release 8.0 DP 11

2015-12-10 Thread Peter Haworth
> On 2015-12-10 19:21, Peter Haworth wrote: > >> I've found two bugs already but the QCC does not have an option to specify >> DP11 in the version dropdown. >> > > Thanks for the heads up - there should now be a DP11 option. > > Warmest Regards, &g

Re: Release 8.0 DP 11

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

Re: BreakPoint problems in LC8DP10

2015-12-03 Thread Peter Haworth
As Peter Brett posted, there is a bug report on this. In one of the posts to the report, it's mentioned that if the message box is open, breakpoints will break and I've found that to be the case. Pete lcSQL Software Home of lcStackBrowser

Re: Death of the Application Browser

2015-12-02 Thread Peter Haworth
Wed, Dec 2, 2015 at 5:38 PM, Peter Haworth wrote: > > > Hi Jacque, > > Interesting discussion and just emphasizes how different folks have > > different needs for the IDE. > > > > > ​We certainly do have an

Re: Death of the Application Browser

2015-12-02 Thread Peter Haworth
Hi Jacque, Interesting discussion and just emphasizes how different folks have different needs for the IDE. I haven't jumped in before but I believe it will do everything you with with the big exception of the "horizontal" layout issue. Here's a few things that I think might help with that. Geoff

Re: hunting a bug on scripted custom properties not being saved

2015-12-01 Thread Peter Haworth
I've run into this as well, don't remember if I entered a bug report or not. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Tue, Dec 1, 2015 at 5:55 PM, Dr. Hawkins wrote: >

Re: SQLite, keep connection open or close every time?

2015-11-30 Thread Peter Haworth
Turns out SQLite now has a built-in user authentication module. Revopndatabase already has user and password parameters but they have not yet been extended to sqlite. On Mon, Nov 30, 2015, 8:50 PM Dr. Hawkins wrote: > On Mon, Nov 30, 2015 at 8:28 AM, Bob Sneidar > wrote: > > > The big reason I

Re: Release 8.0 DP 10

2015-11-28 Thread Peter Haworth
Hi Clarence, That's lcStackbrowser trying to unpack the dictionary. I'll email you offline for more details. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sat, Nov 28, 2015 a

Re: Floating Point

2015-11-27 Thread Peter Haworth
can try this: > > put format( "%.2f", 42) > > > HTH, > > Thierry > > > > 2015-11-27 18:49 GMT+01:00 Peter Haworth : > > I'm working with a third party API that requires me to supply one of the > > parameter values in floating point notation.

Floating Point

2015-11-27 Thread Peter Haworth
I'm working with a third party API that requires me to supply one of the parameter values in floating point notation. The value will be a number keyed into an LC field. Does LC have a built-in way to convert a number to floating point format? Pete lcSQL Software Home of lc

Re: SQLite, keep connection open or close every time?

2015-11-26 Thread Peter Haworth
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 Thu, Nov 26, 2015 at 9:57 AM, Mark Waddingham wrote: > On 2015-11-26 18:29, Peter Haworth wrote: > >

Re: SQLite, keep connection open or close every time?

2015-11-26 Thread Peter Haworth
ues. 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 Thu, Nov 26, 2015 at 12:49 AM, Mark Waddingham wrote: > On 2015-11-25 22:19, Peter Haworth wrote

Re: Setting the color of a field's border

2015-11-26 Thread Peter Haworth
> It's always been like that. Three-d objects need at least 3 pixels to draw > the effect. If you turn off Three-d the color will show up at any border > width. > > On November 25, 2015 6:30:23 PM CST, Peter Haworth wrote: > >I've been trying to set the border around

Re: SQLite, keep connection open or close every time?

2015-11-25 Thread Peter Haworth
Perfectly explained Lynn. The SQLite website is full of caveats about directly addressing SQLite dbs over a network, mainly because they use the native file system locking mechanisms which, they claim, don't work very well in a networked environment. Having said that, the SQLite website is itself

Setting the color of a field's border

2015-11-25 Thread Peter Haworth
I've been trying to set the border around a field to something other than its default by setting its topColor and bottomColor but didn't see the color show up. By chance, I set the borderWidth to 3 instead of the default 2 and the color showed up. Setting the borderWidth back to 2 made the color

Re: SQLite, keep connection open or close every time?

2015-11-25 Thread Peter Haworth
Maybe I'm missing something but I don't understand why the issue of concurrent users keeps coming up in threads about SQL dbs. There are perfectly good mechanisms built into every SQL implementation to preserve the integrity of the db, that's ACID is all about, or at least the "I" in it. They req

Re: ASK dialog box

2015-11-25 Thread Peter Haworth
if the result is "Cancel" then Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Nov 25, 2015 at 9:17 AM, Randy Hengst wrote: > Hi Klauss, > > Yes, I did find that Can

Re: SQLite, keep connection open or close every time?

2015-11-24 Thread Peter Haworth
I recommend that book for anyone who wants to be serious about using SQLite. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Tue, Nov 24, 2015 at 12:42 PM, Richard Gaskin wrote

Re: SQLite, keep connection open or close every time?

2015-11-24 Thread Peter Haworth
Hi Klaus, You seem to have received several responses that don't address your parameters of a local SQLite database on desktop or mobile so I'll limit my reply to a desktop application using SQLite on a local disk with a single user, no network connections, no multi user situations. With that in m

Re: Script for finding duplicate accounts and identifying dups

2015-11-19 Thread Peter Haworth
eAdmin <http://www.lcsql.com/sqliteadmin.html> On Thu, Nov 19, 2015 at 4:42 PM, Peter Haworth wrote: > I haven't seen Bernd's code but here's one way. > > repeat for each line rLine in tUserlist >put item 2 of rLine & comma after tArray[item 1 of rLine] > en

Re: Script for finding duplicate accounts and identifying dups

2015-11-19 Thread Peter Haworth
I haven't seen Bernd's code but here's one way. repeat for each line rLine in tUserlist put item 2 of rLine & comma after tArray[item 1 of rLine] end repeat repeat for each line rKey in the keys of tArray if the number of items in tArray[rKey]>1 then put tArray[rKey] & return after tD

Re: LC8 Standalone field sizes.

2015-11-19 Thread Peter Haworth
5 at 4:31 AM, Mark Waddingham wrote: > Hi Peter, > > On 2015-11-18 18:43, Peter Haworth wrote: > >> I'm seeing a slight difference in the width of fields required to hold a >> given amount of text in the LC8 IDE and LC8 standalone. >> > > Which platform a

Re: LC8 Standalone field sizes.

2015-11-18 Thread Peter Haworth
that of QuickDraw and as a result, you will see a difference when jumping > from < 6.7 to >= 6.7.” > > But I have no knowledge why you get varied results within LC 8. > > Peter > > > On Nov 18, 2015, at 9:43 AM, Peter Haworth wrote: > > > I'm seeing a slight di

LC8 Standalone field sizes.

2015-11-18 Thread Peter Haworth
I'm seeing a slight difference in the width of fields required to hold a given amount of text in the LC8 IDE and LC8 standalone. Using one field as an example, I displayed the effective font, size, and formatted width in the IDE and in the standalone. The font/size were Helvetica Neue/14 in both

Re: JSON library

2015-11-18 Thread Peter Haworth
gt; the Copy Files pane of the standalone settings. > > On Tue, Nov 17, 2015 at 10:55 PM Peter Haworth wrote: > > > A stack that works fine in the IDE does not work when I make a standalone > > from it. In particular, clicking on a scrolling list doesn't have the > > de

JSON library

2015-11-17 Thread Peter Haworth
A stack that works fine in the IDE does not work when I make a standalone from it. In particular, clicking on a scrolling list doesn't have the desired effect. I think it may be because I'm using the new JSONImport function in my selectionChanged handler. It's part of the JSON library and perhap

Re: XML-RPC

2015-11-16 Thread Peter Haworth
.com/sqliteadmin.html> On Mon, Nov 16, 2015 at 2:05 PM, José Antonio Rocha < joseantonioro...@gmail.com> wrote: > 2015-11-15 15:48 GMT-02:00 Peter Haworth : > > > This looks like the server side of things and I'm > > looking for examples of using the revXMLRPC@ c

Re: XML-RPC

2015-11-15 Thread Peter Haworth
stDateInSeconds to seconds > put the date && the time into tCurrentDateInSeconds > convert tCurrentDateInSeconds to seconds > > if (tPostDateInSeconds > tCurrentDateInSeconds) then > next repeat > end if > >

XML-RPC

2015-11-14 Thread Peter Haworth
Starting on a project to have an LC client talk to a server using XML-RPC. I see various functions in the dictionary but are there any lessons/examples out there? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: Release 8.0 DP 9

2015-11-13 Thread Peter Haworth
how group "please stand by" > > You know what - I'll just wait for a better version of LC8, and the news > that both you and bvg have been able to successfully run your plugins, and > then I'll try to move up from LC7 to LC8. > > Thanks > -- Alex. &g

Re: Release 8.0 DP 9

2015-11-13 Thread Peter Haworth
Hi Alex, I will do some testing with lcStackbrowser and dp9. It goes through a process of discovering new properties when it is run under a version of LC it hasn't seen before and that process has changed considerably with the advent of LC8. It was based on how things were in DP7 and since LC8 is

Re: LC 8 and JSON

2015-11-13 Thread Peter Haworth
Hi Devin, I'm using jsonImport in LC8DP7 with no issues, haven't tried it in DP8 or DP9 yet. The only difference is I use textDecode on the URL. I'm using it to decode the LC8 dictionary file. Pete lcSQL Software Home of lcStackBrowser

Re: what id "discover new properties ?

2015-11-11 Thread Peter Haworth
Hi Bill, Thai has to do with new properties that are introduced in each version of Livecode. lcStackbrowser needs to gather info about them for it's property editing features. For each new property it finds, it will ask you to specify how it should be edited (text, checkbox, etc). It will displa

[OT] MacHeist

2015-11-10 Thread Peter Haworth
Here's their latest bundle: https://macheist.com/ You can name your won price but you have to spend at least $15 to the more powerful apps including Supercard Suite Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: How to interface with third party API using URLs

2015-11-07 Thread Peter Haworth
is the phx_dropboxLib that Gugliermo wrote that has been > updated and tweaked by the community > > On Sat, Nov 7, 2015 at 12:30 PM, Peter Haworth wrote: > > > Thanks Devin, I need to remember to always check your site when I'm > looking > > to get started

Re: How to interface with third party API using URLs

2015-11-07 Thread Peter Haworth
n Fri, Nov 6, 2015 at 5:28 PM, Devin Asay wrote: > Pete, > > See my notes at http://livecode.byu.edu/indexgeneric.php under Web > Services. Pretty basic, and I may be missing some important points, but it > might get you started. > > Devin > > > On Nov 6, 2015, at 2:

Re: How to interface with third party API using URLs

2015-11-06 Thread Peter Haworth
Thanks Andy, I'll take a look. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Fri, Nov 6, 2015 at 3:10 PM, AndyP wrote: > Hi Peter, I've found this site to be very useful > h

Re: How to interface with third party API using URLs

2015-11-06 Thread Peter Haworth
eAdmin <http://www.lcsql.com/sqliteadmin.html> On Fri, Nov 6, 2015 at 2:07 PM, Mark Wieder wrote: > On 11/06/2015 01:52 PM, Peter Haworth wrote: > >> I'm working on a project that requires I learn about using URLs to >> interface to a third party API. I have been giv

How to interface with third party API using URLs

2015-11-06 Thread Peter Haworth
I'm working on a project that requires I learn about using URLs to interface to a third party API. I have been given php code that does what I need so I could just execute the php scrips from LC and grab the output. But should I ever need to make changes to the php code, I wouldn't know where to s

Re: mySQL and accented chars revisited

2015-11-04 Thread Peter Haworth
Kay's right. You can define the encoding to be used in an SQL database and utilities should observe that encoding by default. I added that in the last release of my SQLiteAdmin program, although I also included preferences to not encode/decode and/or specify an encoding. That's necessary because t

Re: mySQL and accented chars revisited

2015-11-04 Thread Peter Haworth
I agree, it is strange it's not in the textEncode entry, never noticed that. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Nov 4, 2015 at 5:06 PM, Kay C Lan wrote: > As

Re: mySQL and accented chars revisited

2015-11-04 Thread Peter Haworth
It would depend if they had been properly encoding the data in the database or not. If yes, then using textDecode when SELECTing should get you the correct results. If no, you'd need to do the one-time conversion I described (assuming it works of course!). Pete Pete lcSQL Software

Re: mySQL and accented chars revisited

2015-11-04 Thread Peter Haworth
Hi John, Sounds like you're using LC7 since I see textDecode in there. I don;t know enough about the URL side of things but I think the issue on the database side is what you are doing when you INSERT or UPDATE the data. It needs to be textEncoded at that point. After that, you need to textDecod

[ANN] lcStackBrowser v2.2.1

2015-11-02 Thread Peter Haworth
I'm pleased to announce the release of lcStackBrowser v2.2.1,a plugin replacement for the Livecode Application Browser, Project Browser, Property Inspector, and Tools palette. This is a free update for existing users. A free 30-day trial version is available at http://www.lcsql.com/lcstackbrowser

Re: [ANN] "language-livecode" 0.6.1 for Atom editor

2015-10-27 Thread Peter Haworth
ow the trick is to figure out how to tell Atom to treat it as a Livecode > Script. > > Bob S > > > On Oct 27, 2015, at 09:59 , Peter Haworth p...@lcsql.com>> wrote: > > There is - STS MLXEditor > > Pete > > __

Re: [ANN] "language-livecode" 0.6.1 for Atom editor

2015-10-27 Thread Peter Haworth
There is - STS MLXEditor Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Tue, Oct 27, 2015 at 9:57 AM, Bob Sneidar wrote: > Thanks Brett. Autocomplete seems to work with varia

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-24 Thread Peter Haworth
11:12 AM, Mark Wieder wrote: > On 10/24/2015 09:47 AM, Peter Haworth wrote: > >> Interesting, I haven't seen that problem, at least not in regards to >> indentation. >> > > Try this: > > /* > * this is indented six spaces for emphasis > *

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-24 Thread Peter Haworth
Interesting, I haven't seen that problem, at least not in regards to indentation. I have seen the script editor fairly frequently highlight code outside a block comment in green as if it were inside it. The code still executes OK but a bit scary the first time I saw it happen. Pete lcSQL Software

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-24 Thread Peter Haworth
Thanks Monte. I agree with your choice. FYI, the LC module for Textmate does it per your first example with the case, and all the statements under it at the same indent level, not pretty. Pete lcSQL Software Home of lcStackBrowser

Re: How can a button not have properties?

2015-10-23 Thread Peter Haworth
The properties property is an array so a simple put will not display anything. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Fri, Oct 23, 2015 at 1:43 PM, Dr. Hawkins wrote:

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-22 Thread Peter Haworth
Well there's Mark Wieder's GLX2 editor plugin Mark? On Thu, Oct 22, 2015, 4:27 PM Bob Sneidar wrote: > Trevor and Jerry worked on the Remo project, which was actually quite > good. It ran as a separate application, but was able to access and save > scripts. It also had a great application mana

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-22 Thread Peter Haworth
Hi Mike, There's already a plugin for that, the STS MLXEditor plugin. I'm using that and it works great. Right now, I'm liking TextMate better than Atom for editing stack scripts because it does the automatic indentation I mentioned, but maybe there's a way a setting in Atom to control that? Under

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-22 Thread Peter Haworth
ature. 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 Thu, Oct 22, 2015 at 2:51 AM, Kay C Lan wrote: > On Thu, Oct 22, 2015 at 7:36 AM, Peter Haworth wro

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-22 Thread Peter Haworth
Hi Peter, The only confusion for me was the section on the linter and the installation of LC server. I've never installed LC server so don;t know where to start. I assume there are instructions somewhere so a link to wherever that is would be good. Pete lcSQL Software Home

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-21 Thread Peter Haworth
.lcsql.com/sqliteadmin.html> On Wed, Oct 21, 2015 at 1:15 PM, Mike Kerner wrote: > This conversation is exactly why we need to develop some better > instructions for the non-command-liners. > > On Wed, Oct 21, 2015 at 3:49 PM, Peter Haworth wrote: > > > Thanks Mark a

[ANN] Version 2.2.0 of lcStackBrowser Released

2015-10-21 Thread Peter Haworth
I'm pleased to announce the availability of version 2.2.0 of lcStackbrowser, a plugin replacement for the Livecode Application Browser and Project Browser. This is a free update for all existing users. A demo version is available at http://www.lcsql.com/lcstackbrowser.html. This release includes

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-21 Thread Peter Haworth
Thanks Mark and Monte. I'm now up and running but have not tried to deal with the linter/livecode server yet. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Oct 21, 2015

Re: Resize modal stack

2015-10-21 Thread Peter Haworth
gham wrote: > On 2015-10-21 19:38, Peter Haworth wrote: > >> Prior to 7.0, modal stacks could be resized by the user. From 7.0 >> onwards, >> they can't. Is this a bug or was it done deliberately for some reason? >> Pete >> > > Does setting the re

Re: LC8 Geometry Manager

2015-10-21 Thread Peter Haworth
Waddingham wrote: > On 2015-10-21 19:46, Peter Haworth wrote: > >> My first post on this thread was actually regarding the lack of Geometry >> Manager functionality in LC8. Is this a temporary situation or is there a >> plan to restore it? >> > > Your post

Re: LC8 Geometry Manager

2015-10-21 Thread Peter Haworth
On Wed, Oct 21, 2015 at 12:24 AM, Mark Waddingham wrote: > So this is an error in the translation of the previous property inspectors > structure into the new model which should be extremely easy to fix. Thanks Mark, good to hear it should be an easy fix. My first post on this thread was actua

Re: LC8 Geometry Manager

2015-10-21 Thread Peter Haworth
On Tue, Oct 20, 2015 at 11:08 PM, Kay C Lan wrote: > Table Tool not available for: Label and Field > Table Tool available for: Scrolling Field, Table Field and Scrolling List > Field > That's interesting, I don't see a Table icon for an scrolling list field here. Probably doesn;t matter in view

Resize modal stack

2015-10-21 Thread Peter Haworth
Prior to 7.0, modal stacks could be resized by the user. From 7.0 onwards, they can't. Is this a bug or was it done deliberately for some reason? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: [ANN] "language-livecode" 0.6.0 for Atom Editor

2015-10-21 Thread Peter Haworth
I just downloaded the file but not having any success figuring out how to install it in Atom. It seems their standard install only lists packages that have been registered at atom.io. Any help would be welcome. Pete lcSQL Software Home of lcStackBrowser

Re: LC8 Geometry Manager

2015-10-20 Thread Peter Haworth
es have been keyed to something being a > 'Rev table field' which uses a front script to 'improve' table like > behavior. > > Could you file a bug report? > > Sent from my iPhone > > > On 20 Oct 2015, at 01:19, Peter Haworth wrote: > > > >

Re: LC8 Geometry Manager

2015-10-20 Thread Peter Haworth
+1 tabstops is another property I use quite a bit in scrolling list fields which is no longer available in the LC8 PI. Will the geometry manager appear at some point? I know it's a bit rough round the edges for complex situations but I've always found it to work quite well for simple resizing.

Re: LC8 Geometry Manager

2015-10-19 Thread Peter Haworth
..like wise the Table tab stuff - hgrid, vgrid, tabstops 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, Oct 19, 2015 at 5:11 PM, Peter Haworth wrote

LC8 Geometry Manager

2015-10-19 Thread Peter Haworth
Am I just not looking in the right place or did the GM disappear from the LC8 Properties Inspector? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin __

Re: LC8 Missing Dictionary entries

2015-10-18 Thread Peter Haworth
Admin <http://www.lcsql.com/sqliteadmin.html> On Sun, Oct 18, 2015 at 9:09 AM, Mark Wieder wrote: > On 10/17/2015 05:56 PM, Peter Haworth wrote: > >> The propertynames includes loadExtensions and mirrored but there are no >> dictionary entries for them. Anyone know what th

LC8 Missing Dictionary entries

2015-10-17 Thread Peter Haworth
The propertynames includes loadExtensions and mirrored but there are no dictionary entries for them. Anyone know what they are? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: SQLite: how to open existing database in memory

2015-10-17 Thread Peter Haworth
would be more convenient. > > For example, if I don't the user to be able to look into the database > (which I believe can be done if it is written to disk) using in memory > would be the way to go...true? > > On Sat, Oct 17, 2015 at 12:55 PM, Peter Haworth wrote: > > >

Re: SQLite: how to open existing database in memory

2015-10-17 Thread Peter Haworth
.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Oct 17, 2015 at 9:54 AM, Paul Dupuis wrote: > On 10/17/2015 12:25 PM, Peter Haworth wrote: > > Sorry, I should have looked at your syntax mo

Re: SQLite: how to open existing database in memory

2015-10-17 Thread Peter Haworth
lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Oct 17, 2015 at 9:42 AM, Glen Bojsza wrote: > Thanks for the clarification...this changes the direction I need to take. > > In creating an in memory database can you create one with a name? >

Re: SQLite: how to open existing database in memory

2015-10-17 Thread Peter Haworth
n existing one into the > database that is in memory? > > On Sat, Oct 17, 2015 at 10:36 AM, Peter Haworth wrote: > > > You created a database but you didn't create any tables in it. You'll > need > > to issue a CREATE TABLE command after opening the db. &

Re: SQLite: how to open existing database in memory

2015-10-17 Thread Peter Haworth
You created a database but you didn't create any tables in it. You'll need to issue a CREATE TABLE command after opening the db. On Sat, Oct 17, 2015, 7:22 AM Glen Bojsza wrote: > I am trying to open an existing SQLite database in memory. > > When I do this (or think I do this) I get a database

Re: Arrays and TextEncode/Decode

2015-10-16 Thread Peter Haworth
.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Fri, Oct 16, 2015 at 12:27 PM, Monte Goulding < mo...@sweattechnologies.com> wrote: > > > On 17 Oct 2015, at 6:03 am, Peter Haworth wrote: >

Arrays and TextEncode/Decode

2015-10-16 Thread Peter Haworth
I have an array that can contain Unicode characters in either it's keys or key values. I arrayEncode the array and write out to a file. Should I textEncode the keys/values before arrayEncoding the array and then textDecode the keys/values when reading it back in and arrayDecoding it? Pete lcSQL S

Re: LC8 (dp7) - pretty darn good

2015-10-16 Thread Peter Haworth
I've been using LC8 quite a bit recently in connection with adding support for widgets in lcstackbrowser. No experience using it for mobile platform but it seems to behave itself quite well on OSX, except. I've had a number of issues when running in debug mode. Red dot breakpoints don't alwa

Re: CSV again.

2015-10-15 Thread Peter Haworth
Right I remember that although not what the exact problem was. In any case, csv4Tab has been working fine in my SQLiteAdmin program for at least a couple of years now, but I have no idea what flavor of csv files have been imported. Pete lcSQL Software Home of lcStackBrowser

Re: Forcing string comparisons, or When is "0" not 0?

2015-10-15 Thread Peter Haworth
There is a new operator in LC8, "is really" which may help the string/number comparison issue. See the LC8 dictionary for details. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin O

Re: LC8 lineOffset

2015-10-14 Thread Peter Haworth
k, but couldn't replicate it and there > wasn't a sample stack in the bug report for me to try. > > > -- > Sent from my iPhone > > On 15 Oct 2015 at 09:28:18 AEST, Mark Talluto > wrote: > > > > On Oct 14, 2015, at 4:05 PM, Peter Haworth wrote: >

Re: LC8 lineOffset

2015-10-14 Thread Peter Haworth
ql.com/sqliteadmin.html> On Wed, Oct 14, 2015 at 4:28 PM, Mark Talluto wrote: > > On Oct 14, 2015, at 4:05 PM, Peter Haworth wrote: > > > > Has anyone run into problems using lineOffset in LC8? I'm seeing it > return > > an incorrect line number in some case

LC8 lineOffset

2015-10-14 Thread Peter Haworth
Has anyone run into problems using lineOffset in LC8? I'm seeing it return an incorrect line number in some cases. I'm wondering if it could have something to do with the data I'm searching, since some lines have the characters \n embedded in them Pete lcSQL Software Home

Re: LC 8 Property Inspector

2015-10-14 Thread Peter Haworth
eadmin.html> On Wed, Oct 14, 2015 at 10:58 AM, Richard Gaskin wrote: > Peter Haworth wrote: > >> Would be great if that were the case and maybe it will be eventually but >> when I tried "get the keys of widget 1 of this card", I got an empty >> array. >&g

Re: LC 8 Property Inspector

2015-10-14 Thread Peter Haworth
companies any widget - however, > we really need to document them :) > > What approach did you take in the end? > > Mark. > > Sent from my iPhone > > > On 14 Oct 2015, at 18:33, Peter Haworth wrote: > > > > Would be great if that were the case and maybe it w

Re: LC 8 Property Inspector

2015-10-14 Thread Peter Haworth
QLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Wed, Oct 14, 2015 at 10:07 AM, Richard Gaskin wrote: > Peter Haworth wrote: > >> New version of lcStackBrowser coming out this week with Widget support. >> Not super difficult but did involve some searching around to figure ou

Re: LC 8 Property Inspector

2015-10-14 Thread Peter Haworth
New version of lcStackBrowser coming out this week with Widget support. Not super difficult but did involve some searching around to figure out how to get the properties of a widget. Pete lcSQL Software Home of lcStackBrowser and SQ

LC8 Dictionary

2015-10-13 Thread Peter Haworth
A note to the team: Can we please have a search box for the Guides section of the new dictionary. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin ___

LC8 Widget Documentation

2015-10-13 Thread Peter Haworth
Looking for a function that will return the documentation created for a widget. The revIDEExtensionsLibrary has a function named revIDEExtensionDocsData but it returns only author and title for every installed widget. I know where the JSON file is for each widget and could parse it myself but wou

Re: LC 8 Property Inspector

2015-10-13 Thread Peter Haworth
I see nothing. My bug report has been confirmed so not sure why you see a message. Were you using lc8 dp7? On Tue, Oct 13, 2015, 6:12 AM Richard Gaskin wrote: > Peter Haworth wrote: > > The publish/subscribe stuff sounds great, especially since I just > > found no newxxx me

Re: [ANN] LiveCode List Processor

2015-10-12 Thread Peter Haworth
+1 On Mon, Oct 12, 2015, 8:36 PM Kay C Lan wrote: > On Tue, Oct 13, 2015 at 7:49 AM, Richard Gaskin < > ambassa...@fourthworld.com> > wrote: > > > > > Peter's original problem statement was: > > > >LiveCode chunking is great for handling lists but, as far > >as I can tell, is missing for

Re: LC 8 Property Inspector

2015-10-12 Thread Peter Haworth
The publish/subscribe stuff sounds great, especially since I just found no newxxx messages are sent when creating a control from the tools palette. On Mon, Oct 12, 2015, 7:11 PM Mark Wieder wrote: > On 10/12/2015 01:31 PM, Richard Gaskin wrote: > > > 1. How do we open them? Currently third-part

Re: Widget Properties

2015-10-11 Thread Peter Haworth
On Sun, Oct 11, 2015 at 2:08 AM, Mark Waddingham wrote: > Moreover, we have worked quite hard in the IDE to provide a mechanism for > (2) - it is what the new property inspector is based on - i.e. APIs for > returning information and data about objects in the environment. > Hi Mark, The PI for a

Re: Widget Properties

2015-10-11 Thread Peter Haworth
You have my vote to go ahead with that and thanks for proposing it. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sat, Oct 10, 2015 at 11:44 PM, Monte Goulding < mo...@sweatte

Re: Widget Properties

2015-10-10 Thread Peter Haworth
te Goulding wrote: > > > On 11 Oct 2015, at 11:06 am, Peter Haworth wrote: > > > > I assume widgets can have standard LC built-in properties as well as > their > > own specific properties? > > > > For example if I set the disabled of a widget, it no long

Widget Properties

2015-10-10 Thread Peter Haworth
I assume widgets can have standard LC built-in properties as well as their own specific properties? For example if I set the disabled of a widget, it no longer reacts to mouse clicks, but if I get its properties, they are empty. I know widgets have their own property definitions but I would have

Re: Widget structure questions

2015-10-10 Thread Peter Haworth
Yes, I've been using them for a long time now and also wonder why they aren't in the dictionary. I think I might have filed a bug report about that a long while ago but don;t remember for sure. Pete lcSQL Software Home of lcStackBrowser

<    1   2   3   4   5   6   7   8   9   10   >