[ANN] lcStackBrowser v2.2.1

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: mySQL and accented chars revisited

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

Re: mySQL and accented chars revisited

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

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

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

How to interface with third party API using URLs

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: How to interface with third party API using URLs

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

Re: How to interface with third party API using URLs

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

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

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

[OT] MacHeist

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: what id "discover new properties ?

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

Re: MS SQL

n tracing in the odbc driver and I can see field names in > the > >>> > data. So I'm assuming the query is working. But still can't figure > out > >>> why > >>> > LC is hanging. I have database checked in the stand alone settings, > not &g

Re: [Enhancement Request] Open and BackUp in LiveCode DP and RC

It is interesting how different people work in different ways. In my lcStackBrowser plugin I tried to include functionality that I've found useful in my own work environment and also keep the number of open utility stacks to a minimum, hoping to provide as much flexibility as possible. Like Richar

Re: Really basic SQLite questions

Hi James, I'd leave them open until you quit the app. You might also think about using the ATTACH command for the second and subsequent connections so they'll all be open on the same connection. This allows you to, for example, define JOINs across databases, although you'll need to change the refer

Re: Backdrop in in 6.7.0 dp2 under Lubuntu Linux 13.10

Backdrop is messed up on OSX also. Plugins loaded at startup disappear and when you get them back, clicking on the backdrop hides them again. Also, parts of Livecode are still visible. Pete lcSQL Software On Apr 25, 2014 8:23 PM, "Alejandro Tejada" wrote: > Read this report: > http://quality.

RunRevInstaller Issue

RunrevInstaller is chewing up around 70-80% of the CPU on my Mac running OSX 10.7.4. I believe it's the 6.7 DP2 installer. That's what shows up in Activity Monitor yet, the installer doesn't show up as a running program in the dock. I've terminated it but wondering if anyone else has come across

Re: Backdrop in in 6.7.0 dp2 under Lubuntu Linux 13.10

Already there - 12302 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, Apr 26, 2014 at 8:19 AM, Richmond wrote: > On 26/04/14 17:19, Peter Haworth wr

Re: Backdrop in in 6.7.0 dp2 under Lubuntu Linux 13.10

tackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Apr 26, 2014 at 12:42 PM, J. Landman Gay wrote: > On 4/26/14, 9:19 AM, Peter Haworth wrote: > >> Backdrop is messed up on OSX also. >> > >

Re: Backdrop in in 6.7.0 dp2 under Lubuntu Linux 13.10

Gay wrote: > >> On 4/26/14, 9:19 AM, Peter Haworth wrote: >> >>> Backdrop is messed up on OSX also. >>> >> >> That's listed as a known issue in the 6.7 dp 1 release notes. I haven't >> looked at dp 2 yet though. >> >

Date/Time/Number/Currency formats

I've put together a script that gets the date/time/number/currency formats using shell to issue locale commands on OSX. How can I get that info on Windows? Linux? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: Date/Time/Number/Currency formats

get the values. > > You find more information about the registry settings for international > settings at > > http://technet.microsoft.com/en-us/library/cc784842%28v=ws.10%29.aspx > > Regards, > > Matthias > > > > Am 27.04.2014 um 20:22 schrieb Peter Haworth : > >

Re: Really basic SQLite questions

Well I guess it depends on the application but how do you manage locks and/or cursors when continually opening/closing? I'm also interested in what type of errors you've encountered that make your database inaccessible? SQLite is most definitely designed for multiple connections, just not by diffe

Re: Date/Time/Number/Currency formats

On Sun, Apr 27, 2014 at 2:14 PM, Matthias Rebbe | M-R-D < matthias_livecode_150...@m-r-d.de> wrote: > You find more information about the registry settings for international > settings at > > http://technet.microsoft.com/en-us/library/cc784842%28v=ws.10%29.aspx > Only thing missing is the time zo

Re: Date/Time/Number/Currency formats

On Mon, Apr 28, 2014 at 12:14 PM, Matthias Rebbe | M-R-D < matthias_livecode_150...@m-r-d.de> wrote: > HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation > Thanks Matthias Pete lcSQL Software Home of lcStackBrowser

Re: I lost my property inspector

Open an inspector for one of your objects then check the option to include IDE stacks in the Application browser. Do you see stacks named either "revTemplatePalette" or "revPropertyPalette 1" (the former should be hidden)? If you see the second, check out its location by - put the location of sta

Re: Really basic SQLite questions

On Tue, Apr 29, 2014 at 8:16 PM, Kay C Lan wrote: > I've just done a check and I'm not seeing any error. I use to get something > like 'table not available' or 'table doesn't exist'. All I'd have to do was > close the management tool and LC would work properly again. So a couple of > years ago I

Re: Full text justification

Hi Dave, This doesn't seem to work on OSX 10.7.4, LC 5.5.4, For example, with the wide field, I get a line break after the word "explains", then a line with "what those" in it, then a line with "numbers mean." SImilar results with the other paragraphs and also with the other field widths. Same re

Re: Reporting the number of duplicates in a list of numbers?

If you're using an sql db: SELECT , count(*) AS C FROM GROUP BY < thewordnumber > ORDER BY C DESCENDING Returns the word numbers and count sorted by count high to low. Pete lcSQL Software On May 4, 2014 8:47 PM, "JOHN PATTEN" wrote: > Thanks Kay! > > That’s what I needed. I knew it was prett

Re: Need to compare two datagrids

Hi Skip, Following Phil's suggestion, I think you could do this using the filter command, something like this: put the dgText of group dg1 into tdg1Text put the dgText of group dg2 into tdg2Text set the itemdelimiter to tab repeat for each line rLine in tdg1Text filter lines of tdg2Text with it

Re: Need to compare two datagrids

On Mon, May 5, 2014 at 2:42 PM, Peter Haworth wrote: > filter lines of tdg2Text with item 1 of of rLine into tTemp I think that line should be: filter lines of tdg2Text with (item 1 of rLine & tab) into tTemp That should work as long as item 1 doesn't appear in anything other th

Re: Need to compare two datagrids

On Mon, May 5, 2014 at 2:53 PM, Peter Haworth wrote: > filter lines of tdg2Text matching tRegexp into tTemp And yet another correction to the filter syntax: filter lines of tdg2Text with regex pattern tRegexp into tTemp I tested the code this time and it seems to work. Pete lcSQL Softw

Re: SUMMARY Re: LiveCode Books

Hi Andre, Without wishing to dampen the enthusiasm to do this, it does result in yet another place to look for Livecode resources online. It might be better to ask Scott McDonald to add a section to his Livecode supersite for books. Pete lcSQL Software Home of lcStackBrowse

Re: Modularising Code

I'd also recommend Richard Gaskin's excellent article on the subject which can be found at http://www.fourthworld.com/embassy/articles/revolution_message_path.html Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Resizing a group's controls when the group is resized

I have a resizeControl handler for a group in which I've tried changing the height and width of the controls in the group but I can't get it to work correctly. The lockLocation of the controls in the group is set true. To narrow down the problem, I changed the resizeControl handler to have just o

Re: Mysql UNIQUE and .lc server scripts?

Hi John, What's in the result after calling revExecuteSQL to issue your INSERT statement? You should get either an integer count of the number of rows inserted or an error message. Pete lcSQL Software Home of lcStackBrowser and SQ

Re: Mysql UNIQUE and .lc server scripts?

tuniqueid", "treddescription", > "tbluedescription", "tgreendescription", "ttitle", "ttextselection" > revCloseDatabase tConID > put empty > ?> > > I’m not sure how to send the result back to my app in order to act on it? &

Re: Resizing a group's controls when the group is resized

May 10, 2014 at 8:54 AM, Randy Hengst wrote: > Hi Peter, > > Check out: ResizeGroup by Bernd Niggemann on the LiveCode user samples… > and > > And: http://forums.runrev.com/viewtopic.php?f=9&t=17614&p=102374#p102374 > > be well, > randy > > On May 8, 2014

Re: functionNames, commandNames, etc. not returning complete list

There are bug reports on this. Not only is there a lot of stuff missing but you'll also find things like "abbrev " which to my mind are keywords not functions. Pete lcSQL Software On May 11, 2014 3:17 PM, "Mark" wrote: > Hi list, > > I was mucking around in the IDE trying to get a complete list

Re: Error Messages Are Evil

Perfect example - signing up for an account online and getting an error because your password didn't meet the site 's rules which they didn't reveal to start with. That's evil! Pete lcSQL Software On May 11, 2014 2:24 PM, "Alejandro Tejada" wrote: > Probably, the point of Mr. Donald Norman is:

Re: IDE oddities (was Re: Error Messages Are Evil)

One thing that confused the heck out of me at the start is how the menu bar changes depending on whether a stack or the script editor is in front (this is on OSX). When in the script editor, the menu bar shows File, Edit, Debug, Handler, Window, Help and the File menu has no entries to open a stac

Re: Nice news for builders of financial apps

+1 Pete lcSQL Software On May 19, 2014 11:09 PM, "Jerry Jensen" wrote: > On May 19, 2014, at 2:55 PM, Richard Gaskin > wrote: > > > Alejandro Tejada wrote: > > > >> Richard Gaskin wrote > >>> [snip] > >>> With the field object now supporting independent column alignment, we > >>> get attractive

Re: Handler is being ignored: Why?

I've seen similar issues when the backscript flags a runtime error of some sort, perhaps because arg1 or arg2 contains an unexpected value. I would try putting the thatcommand handler into the same script as the thiscommand handler then stepping into it to see what happens. Pete lcSQL Software On

Re: Highlited text in a cd fld

Are you changing the contents of the list field in any way when you return to the card it is on, perhaps in a resumestack handler? Any change to Alistair field loses the hilited lines property. Pete lcSQL Software On May 23, 2014 3:36 PM, "Terence Heaford" wrote: > > On 23 May 2014, at 13:57, du

Re: silent fail of revDataFromQuery() in standalone; works in IDE

What do you get in theRes when it works? CREATE shouldn't return any data. I always use revExecuteSQL for any SQL statement other than SELECT, although if revDataFromQuery works in the IDE it should work in the standalone. Pete lcSQL Software On May 23, 2014 11:33 PM, "Dr. Hawkins" wrote: > Th

Re: Highlited text in a cd fld

I don't see this in my scrolling list fields, maybe because they're on a modeless stack? Pete lcSQL Software On May 24, 2014 8:20 PM, "J. Landman Gay" wrote: > On 5/24/2014, 1:39 AM, Terence Heaford wrote: > >> Has it always been this way? I am a newcomer to LiveCode. >> >> It is easy enough to

Re: Highlited text in a cd fld

one card that you navigate from/to? > > If the style of the window is a factor, that'd be good to know. > > On 5/24/2014, 3:48 PM, Peter Haworth wrote: > >> I don't see this in my scrolling list fields, maybe because they're on a >> modeless stack? >

Re: Quitting with the close box on Mac

> > That said, there's an auto-save plugin (RevSmartSave) that ships with LC for those who want it. > LcStackBrowser does this too, either at timed intervals or on request, along with an optional user supplied comment. Versions can be restored from a list showing the creation date and time along wi

Re: Quitting with the close box on Mac

On May 29, 2014 7:49 AM, "Igor de Oliveira Couto" wrote: > > Now, how useful would that be if we were able to do the same from, let’s say, inside a stack window (viewing previous versions of an interface), or directly from the script editor?… > LcStackDiff provides a way to view all the changes be

Re: Setting a behavior in the IDE

On May 30, 2014 6:17 AM, "J. Landman Gay" < > > So I thought maybe we could click some gizmo in the property inspector that would list everything in the stack and ask us to choose a behavior object. But if there were more than a few controls that's unweildy and building the list for a large stack w

Re: Setting a behavior in the IDE

I think that was directed at me... Pete lcSQL Software On May 30, 2014 7:12 PM, wrote: > Mike. > > > Over-plugging? > > > > I was trying to determine if there was a way to reproduce what Mark > mentioned, that a property set in the inspector changed (or emptied),. In > other words, if that is wh

Re: Import text file into sqlite

First thing to do is get a copy of Alex Tweedly's excellent handler for unpacking csv files. After that, a lot depends on the structure of your database versus the structure of the csv file but in general you just need to create a SQL INSERT statement for each line in the csv file (except the head

Re: Need to filter out items of list

Hi Skip, If this is related to your earlier post about loading a text file into an SQL database, it's probably just as easy/fast to load all the data into your database then delete the rows that have the columns corresponding to items 9/15 set to empty/greater than zero. Pete lcSQL Software

Re: Need to filter out items of list

On Wed, Jun 4, 2014 at 3:37 AM, Skip Kimpel wrote: > For now I have things working and it is smooth. Maybe I will rework it > this weekend. If the text file that I am using already contains headers in > line 1, is there a quick and simple way to create and dump all that data > into a mysqlite f

Running an LC app from the command line

I would like to run an existing lc standalone from the command line, passing it parameters that will determine what it should do. Searched the list archives and found that I can reference $1, $2, etc to get the parameters and that works just fine. I would also like the app to not display its main

Re: field losing formatting on copying

Not seeing this with LC 5.5.4 and OSX 10.7.4 The original caseno field in the rawforms stack had its margin set to 8 so yes, it ended up that way after being copied. I changed the margins to 0,2,0,0, copied again and the margins of the copied caseno field stayed at 0,2,0,0. Pete lcSQL Software <

Re: Running an LC app from the command line

Thanks everyone. SOunds like hiding and positioning off screen is the way to go, particularly since I need this to work on Windows as well as Mac and I think -ui is Mac only (and possibly Linux?) Pete lcSQL Software Home of lcStackBrowser

Re: field losing formatting on copying

On Thu, Jun 5, 2014 at 9:20 AM, Dr. Hawkins wrote: > Err, it's not caseno itself, but the label field next to it that gets the > problem (actually, both label fields) > OK, misunderstood. However, the label field also shows up with margins of 0,2,0,0 on my end. Pete lcSQL Software

Re: field losing formatting on copying

o that though. > > Paul > > On 2014-06-05, at 11:39 AM, Dr. Hawkins wrote: > > > On Thu, Jun 5, 2014 at 10:36 AM, Peter Haworth wrote: > > > >> OK, misunderstood. However, the label field also shows up with margins > of > >> 0,2,0,0 on my end. > &

Re: field losing formatting on copying

On Thu, Jun 5, 2014 at 5:58 PM, Paul Hibbert wrote: > I know this doesn't answer why the problem occurs, but it does workaround > it. I tried setting the textHeight & textSize of the stack "mcp", card > "r_controls", the templateField and the templateGroup, all had no effect on > the copied group

Re: OT: Is there a kind of F5 on Mac?

Take a look at this link: http://hints.macworld.com/article.php?story=2009091413423819 If you create an Automator Service as shown in this article, you can then assign it to F5. Pete lcSQL Software Home of lcStackBrowser and SQLi

Re: revDataFromQuery : size limit of mySQL query ?

I haven't come across a limit and I've certainly created some very large SELECT results but I guess there must be one at some point. If you run into one, you can probably get round it by using revQueryDatabase to create a cursor although that would probably mean rewriting a lot of your code. One o

Re: revDataFromQuery : size limit of mySQL query ?

Ah OK, sorry should have read more closely. Don't know the answer to that one but if there is a limit the NOT IN thing I suggested would cut down on the length of the SELECT statement since there are no "AND" operators in it. Pete lcSQL Software Home of lcStackBrowser

Re: revDataFromQuery : size limit of mySQL query ?

Thanks jbv. Can't think of any better ways to do it so I guess just hope there isn't a size limitation. If you do run into a size limitation, another possibility might be to use a temporary table to hold the names to be excluded then use a SELECT something like: SELECT name FROM Names LEFT JOIN

Open stack problem

Trying to track down a strange problem involving opening a stack. I have a button with a script that issues an answer file statement to get the name of a stack file to open. After getting the file name and doing a couple of checks I open the stack file then do some other stuff. This all works fi

Re: which is faster for searching?

You might want to try the filter command too, especially the new version that has a lot more options including the ability to put the qualifying lines into a different container. Pete lcSQL Software Home of lcStackBrowser and SQLite

Re: which is faster for searching?

SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Tue, Jun 17, 2014 at 11:17 AM, wrote: > Thanks Pete, > Which version exactly is it? > Larry > > ----- Original Message - From: "Peter Haworth" > To: "How to use LiveCode" > Sent: Tuesday

Re: which is faster for searching?

n exactly is it? > Larry > > ----- Original Message - From: "Peter Haworth" > To: "How to use LiveCode" > Sent: Tuesday, June 17, 2014 11:25 AM > Subject: Re: which is faster for searching? > > > You might want to try the filter command too, especially

Nested Repeat loops

Wondering if anyone has an elegant way of exiting all the way out of a set of nested repeat loops., e.g: repeat for... repeat for... repeat for repeat for if . then end repeat end repeat end repeat end repeat Right now,

Re: SQL Join question

SELECT * FROM TableA UNION SELECT * FROM TableB Both tables must have the same number of columns. You'll end up with separate Records from each table so if you need to differentiate between them and there isn't a column that does that, you could do something like SELECT 'A',* FROM tableA UNION SE

Re: SQL Join question

Forget my earlier post, thought you were wanting to select not insert. John's INSERT.. SELECT is the way to do it. Pete lcSQL Software On Jun 21, 2014 7:57 AM, "Mark Smith" wrote: > I have two tables A and B, both with the same structure (about 50 columns > each). I would like to combine the

Re: Nested Repeat loops

Thanks for all the suggestions. I like the idea of putting the whole nest of repeats in a separate handler as far as the current capabilities of the language, but I really like the idea in Richard's email to have the ability tp name each loop then exit out of a named loop. Is there a QCC report o

Re: SQL Join question

<http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Jun 21, 2014 at 9:29 AM, Peter Haworth wrote: > Forget my earlier post, thought you were wanting to select not insert. > John's INSERT.. SELECT is the way to do

specialfolderpath

How do I get the location of the application folder using specialfolderpath? With LC 6.6.2 on a Mac, specialfolderpath("Applications") returns "/Users//Library/Application Support", not the path to the applications folder. Pete lcSQL Software Home of lcStackBrowser

Re: specialfolderpath

Thanks,added it to my useful bookmarks. Seems like the dictionary should include all that info instead of the very short list that's in there right now. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: specialfolderpath

Will report both these. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sat, Jun 21, 2014 at 6:43 PM, Martin Koob wrote: > Yes the docs should have Those listed. You can rep

Re: SQL Join question

value for all three tables. 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 Sun, Jun 22, 2014 at 7:23 AM, Mark Smith wrote: > Peter Haworth wrote >

Re: SQL Join question

On Sun, Jun 22, 2014 at 6:55 AM, Mark Smith wrote: > I never did > resolve how to make the primary keys unique across devices > Assuming you are using SQLite, there are a couple of ways to achieve this, one riskier than the other. The less risky approach is to give up on using an autoincrementi

Re: SQL Join question

is foolproof since > no > manual intervention would be required, and each iPad device would be > guaranteed to have/contribute its own unique id. > > > Peter Haworth wrote > > Assuming you are using SQLite, there are a couple of ways to achieve > this, > >

[ANN] Version 1.3.5 of SQLiteAdmin available

The above version of SQLiteAdmin is now available for download at www.lcsql.com/sqliteadmin.html. This version is free to all existing SQLiteAdmin users. The main focus of this release is bug fixes and the inclusion of version 3.8.3.1 of the SQLite library, with support for new language elements

Re: Nested Repeat loops

Submitted QCC report 12691 for this. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sat, Jun 21, 2014 at 3:00 PM, Alex Tweedly wrote: > On 21/06/2014 15:22, Richard Gaskin

Re: Error handling (was Re: "nan" v. try-catch for arithmetic)

On Thu, Jun 26, 2014 at 8:22 AM, Richard Gaskin wrote: > Is there a simple rule that would allow scripters to understand when > try-catch is necessary and when the result should be checked instead? > > If not, should there be? > > Or perhaps better yet, could error handling be made uniform, maybe

Name shadows another variable

The above error has been flagged intermittently and incorrectly when compiling a script with Strict Compilation Mode turned on for as long as I've been using Livecode. In the last couple of days, the error has been flagged every time I compile a script in one particular application. I restart Liv

Re: Name shadows another variable

the dictionary is to not mess with that one. > > > On Thu, Jun 26, 2014 at 5:54 PM, wrote: > > > Peter, > > > > > > Can you tell me more about what this error is and does? > > > > > > Craig > > > > > > > >

Re: Name shadows another variable

Hi Craig, The error message "name shadows another variable" is shown as when strict compile mode is on. It's supposed to indicate that the name of a declared variable has already been declared somewhere else in the script, perhaps with another local statement in the same script/handler or in a gl

Re: Name shadows another variable

On Fri, Jun 27, 2014 at 7:08 PM, Mark Wieder wrote: > So... ensure that variable preservation is unchecked, change the name > of the variable to something without a conflict, compile the script, > and save the stack. I think that should clear up the problem for this > stack. Since I never use var

Re: Name shadows another variable

On Fri, Jun 27, 2014 at 7:08 PM, Mark Wieder wrote: > If you at some time in the past turned on variable preservation and > had a script variable of the same name you are now using for a handler > variable, then that variable scope is still stored with the stack. > Until you can compile the scrip

Re: Elegant way to express constant UTF8 string in script?

On Mon, Jun 30, 2014 at 7:38 AM, Ben Rubinstein wrote: > So... what's the most elegant way to this (is there one)? Is there any > alternative to just looking up the UTF8 encodings and writing: > > put format("This ice cream is \xC2\xA9 Ben and Jerry\xE2\x80\x99s Inc") > into kMyConstantString

imageData

Wondering if there's a good reason why the imageData property of an image is not included in its properties? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: OT : Advice on SQL database design

Hi Alex, Your situation seems to involve a 1-1 relationship between tables which always feels a little strange for the reasons you mentioned. I'd probably eliminate option A for starters. Following classic database design rules, you should probably have a separate table for each armed forces bran

Re: imageData

SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Mon, Jun 30, 2014 at 9:39 PM, Monte Goulding wrote: > > On 1 Jul 2014, at 2:31 pm, stephen barncard < > stephenrevoluti...@barncard.com> wrote: > > > On Mon, Jun 30, 2014 at 5:15 PM, Peter Haworth wrote: >

Re: Odd Empty behavior

Livecode always returns true if you test an array for empty, although I think that behavior might have changed in a recent release. test["data"] is an array since it has the "a1" subkey. I think this will tell you if test["data"] has any subkeys or not and thus whether it's empty or not: if test[

Re: OT: Collaborative Diagramming Software

The Chrome Web Store has another one named Glifffy Diagrams. Never used it so can't comment on if it's any good or not. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Ju

Re: Inhibit mouse Events possible?

I guess you could lock messages but that would lock all messages not just mouse events. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Thu, Jul 3, 2014 at 10:32 AM, William Pr

Re: OT: Collaborative Diagramming Software

On Thu, Jul 3, 2014 at 12:26 PM, Brahmanathswami wrote: > And we are very close to real-time collaboration which would be way cool. > Check this Jun 13 support doc. > > https://jgraph.freshdesk.com/support/solutions/articles/ > 312533-how-do-i-get-real-time-collaboration-on-draw-io-using-goog

convert

Does the convert command take account of the user's syatem settings when parsing its input? In other words, if I'm in the UK and pass the string "06/07/14" to the following convert command convert "06/07/14" from system date to dateitems ... will I end up with month=07 and day=06 rather than th

Re: convert

wser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Jul 5, 2014 at 11:37 AM, Richmond wrote: > On 05/07/14 20:12, Peter Haworth wrote: > >> Does the convert command take account of the user's syatem settings when >> parsing its input? >> >>

Re: convert

<http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sat, Jul 5, 2014 at 1:20 PM, Richmond wrote: > On 05/07/14 22:45, Peter Haworth wrote: > >> Yes, I read that but it's not clear if that refers to the output format or

Re: OT : Advice on SQL database design

Very good write up. At least form this one particular test, it seems that SQL is faster than any of the other methods, especially MongoDB. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin

Re: convert

ete > 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, Jul 5, 2014 at 1:20 PM, Richmond > wrote: > >> On 05/07/14 22:45

<    4   5   6   7   8   9   10   11   12   13   >