I'm now running into an issue where I check to see if a table I need
exists, and create it if it doesn't.
However, this creates an error when it tries to create an existing table.
When I look at the results from revDataBaseTableNames(), it is missing
large numbers of fields.
Do I need to query
On Sat, Aug 10, 2013 at 5:58 PM, Richard Gaskin
ambassa...@fourthworld.comwrote:
Now that LC is open source, what would it take to update the SQLite
version and expose these newer optional features?
Would be great if someone would take that on. Quite a few more new SQLite
features have been
Hi Scott,
on Sat, 10 Aug 2013 13:17:14 -0700
Scott Rossi wrote:
in my experience, all of the options you cite
will usually work only if the colors of your source image
can comfortably fit within a range of 256 colors.
Images that are primarily solid colors or have
very complex patterns
On 8/10/13 3:27 PM, Joe Hamburger wrote:
The corrupted stack I'm
talking about appears fine. I can open any card in it and do whatever
I want within the stack. The problem arises when I use a script in
another stack to alter the contents of fields in this stack.
I don't know if it's a specific
Hi Al:
I often use a stress test image that contains a color wheel and varying
levels of transparency. I tried a couple of the sites and the outcomes were
pretty similar. For myself, I'd rather use a tool that will batch process
files locally and produce decent results, which ImageOptim
For my database transactions, the lag time is the expensive part; the
transactions themselves are blindingly fast.
I can bundle hundreds of UPDATE statements together without a problem.
On some of them, though, I'm setting a column to NOW()--which works.
I have another table in the same
On Sat, Aug 10, 2013 at 4:32 PM, Dr. Hawkins doch...@gmail.com wrote:
I'm only getting the results from the second query. If done separately,
I get multiple rows from the first query.
That's what I'd expect, the results of the second query ovewrite the
results of the first SELECT. What you
On 8/11/13 2:11 PM, Scott Rossi wrote:
For myself, I'd rather use a tool
that will batch process files locally and produce decent results,
which ImageOptim seems to do.
The same author has made a Mac GUI for imageAlpha, which is based on the
same source code as the tinyPng web site. I've been
On 8/11/13 4:30 PM, Kay C Lan wrote:
On Fri, Aug 9, 2013 at 3:34 AM, J. Landman Gay jac...@hyperactivesw.comwrote:
When you think of it that way, it all falls into place.
Not really. In the Message Box:
put 1,1,3,2,1,4 into tStore
put tStore into msg
put empty into item -1 of tStore
put cr
On Sun, Aug 11, 2013 at 2:47 PM, J. Landman Gay jac...@hyperactivesw.comwrote:
Lines are easier to grok:
This is line 1 cr -- cr is part of line 1
This is line 2 cr -- cr is part of line 2
This is line 3 cr -- cr is part of line 3
Yeah but if you put that text into a scrolling field then
On Sun, Aug 11, 2013 at 1:16 PM, Dr. Hawkins doch...@gmail.com wrote:
UPDATE myindex SET tmstmp=NOW() RETURNING tmstmp;
Just do SELECT tmstmp FROM myIndedx right after the UPDATE and before the
END.and get rid of the RETURNING clause
Pete
lcSQL Software http://www.lcsql.com
From: Peter Haworth
On Sun, Aug 11, 2013 at 2:47 PM, J. Landman Gay
jac...@hyperactivesw.comwrote:
Lines are easier to grok:
This is line 1 cr -- cr is part of line 1
This is line 2 cr -- cr is part of line 2
This is line 3 cr -- cr is part of line 3
Yeah but if you put that
On 12/08/2013, at 12:19 AM, Geoff Canyon wrote:
Has anyone looked at syncing a git repository through LC? Not LC projects --
I'm planning an app that has distributed data, and git seems like a
reasonable way to manage that if I can reasonably control clone, pull, and
push, and present the
On Sun, Aug 11, 2013 at 3:50 PM, Peter Haworth p...@lcsql.com wrote:
On Sun, Aug 11, 2013 at 1:16 PM, Dr. Hawkins doch...@gmail.com wrote:
UPDATE myindex SET tmstmp=NOW() RETURNING tmstmp;
Just do SELECT tmstmp FROM myIndedx right after the UPDATE and before the
END.and get rid of the
Before the big field rewrite a couple versions back, any Vertical Tab
(VT, ASCII 11) characters in a field just rendered as a non-printable
character.
But after the big field rewrite, VTs are now used as a way to provide
return-like appearance within a field table, so now VTs have more or
Paul-
Sunday, August 11, 2013, 4:20:35 PM, you wrote:
I wonder if anyone actually relies on that ability. If not, perhaps THAT
should be changed, since it appears to be the one glaring inconsistency that
can't be resolved by looking at things differently.
Jacque has pointed out on the web
Jacque-
Sunday, August 11, 2013, 2:47:18 PM, you wrote:
This is line 1 cr -- cr is part of line 1
This is line 2 cr -- cr is part of line 2
Here are three items:
item 1,
item 2,
item 3,
They work the same way.
Yes, and with the same problems. The problems occur when you have a
I still like Mark's idea of having a global property. There are a lot of
us that started using HC wy back before v. 2.1 came
along. Some have legacy stacks that we don't want to change (See Jacque)
and some of us have no qualms fixing any lingering issues that might come
up
Mike-
Sunday, August 11, 2013, 5:57:12 PM, you wrote:
I still like Mark's idea of having a global property.
I think Monte's right in that it makes more sense to make this a stack
property rather than a global property. That way existing stacks don't
have to be changed but you can make new
I mean set up a project on GitHub (not sure if that can be done from LC), then
use LC to:
-- clone the repo
-- make changes to the files locally
-- pull and push to sync
Sent from my iPad
On Aug 11, 2013, at 7:05 PM, Monte Goulding mo...@sweattechnologies.com wrote:
On 12/08/2013, at
On 12/08/2013, at 10:57 AM, Mike Kerner wrote:
A global property lets everyone do it their own way.
No it doesn't. What if you want to use one of Jacque's plugins? That's why I
suggested a stack property just like HCAddressing... HCChunkBehavior or
HCDelimiterCounting are my favourite
Mark Wieder wrote:
1,2,3 -- this contains three items
1,2,3, -- this contains three items
1,2,3, -- this contains four items
Let's look at those strings from the point of view of what we might
presume was that of the HyperTalk design team, but besting them by using
Jacque's suggestion of
OK, well if that's really a problem, the only other way I can think of is
calculate the timestamp in your LC script and hand it off to the update
statement as a literal value instead of using NOW()
Pete
lcSQL Software http://www.lcsql.com
On Sun, Aug 11, 2013 at 4:57 PM, Dr. Hawkins
Richard-
Sunday, August 11, 2013, 6:22:47 PM, you wrote:
x|x|x -- this contains three items
x|x|x| -- this contains three items
unless, of course, the trailing space is considered part of the
string, in which case that last line has four items.
x|x|x|x -- this contains four items
The
Mark Wieder wrote:
Richard-
Sunday, August 11, 2013, 6:22:47 PM, you wrote:
x|x|x -- this contains three items
x|x|x| -- this contains three items
unless, of course, the trailing space is considered part of the
string, in which case that last line has four items.
x|x|x|x -- this
On 8/11/13 7:35 PM, Mark Wieder wrote:
Yes, and with the same problems. The problems occur when you have a
situation like
This is line 1 cr
This is line 2 crcr -- there are still only two lines
The engine says that's 3 lines, which is consistent with final terminators.
1,2,3 -- this
On 8/11/13 8:22 PM, Richard Gaskin wrote:
One simple solution would be to add lineTerminator and
itemTerminator as synonyms for lineDelimiter and itemDelimiter
respectively, and then the conceptual model fits what the engine does.
We leave the *delimter tokens in place for us ol' timers, but
Earlier I wrote:
Before the big field rewrite a couple versions back, any Vertical
Tab (VT, ASCII 11) characters in a field just rendered as a
non-printable character.
But after the big field rewrite, VTs are now used as a way to provide
return-like appearance within a field table, so now
On 8/11/13 7:02 PM, Richard Gaskin wrote:
So in short: Anyone here know how to turn off the rendering of VTs as
returns so I can see only true ASCII 10s as the line breaks, like I've
enjoyed for the last 25 years?
I don't think there's a way to do it outside of a bulk replace with some
Monte, Mark,
Yes, I think I like a stack/script property better, too. Great idea.
Jacque and Richard...
So you're basically thinking we should change words, not the behavior? Why
not just change the documentation, then? In the meantime, if the behavior
is to be left alone, there are a variety
J. Landman Gay wrote:
On 8/11/13 7:02 PM, Richard Gaskin wrote:
So in short: Anyone here know how to turn off the rendering of VTs as
returns so I can see only true ASCII 10s as the line breaks, like I've
enjoyed for the last 25 years?
I don't think there's a way to do it outside of a bulk
I've been playing around with pngquant to optimize some pngs. It uses
this syntax:
usage: pngquant [options] [ncolors] [pngfile [pngfile ...]]
I'm able to use it both in Terminal and with LiveCode's shell command. I
pass it some options and a file name, and it makes a new optimized png
Jacque-
Sunday, August 11, 2013, 7:25:47 PM, you wrote:
put this is line 1 cr into field 1
put this is line 2 cr cr after field 1
put the number of lines in field 1
-- but there are actually four lines in field 1.
--
-Mark Wieder
mwie...@ahsoftware.net
Mike Kerner wrote:
Jacque and Richard...
So you're basically thinking we should change words, not the behavior? Why
not just change the documentation, then? In the meantime, if the behavior
is to be left alone, there are a variety of functions (especially the
database functions) that have to
On 8/11/13 9:55 PM, Mike Kerner wrote:
Also remember that text editors don't behave this way, either. Empty
CR's at the end of a line still trigger a page break. That seems far
more correct than having to figure out of a delimiter/terminator should be
significant or not.
Empty crs in
Jacque-
Sunday, August 11, 2013, 8:07:23 PM, you wrote:
The it variable is empty, and the new file appears on disk. I want to
do this:
put pathToPngquant 16 (the text of img 1) into tCmd
get shell(tCmd) -- get binary data back
Or, if not the text of img 1, using the binary data
Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 7:25:47 PM, you wrote:
put this is line 1 cr into field 1
put this is line 2 cr cr after field 1
put the number of lines in field 1
-- but there are actually four lines in field 1.
With x as data and | as the terminator, the above gives
On 8/11/13 10:10 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 7:25:47 PM, you wrote:
put this is line 1 cr into field 1
put this is line 2 cr cr after field 1
put the number of lines in field 1
-- but there are actually four lines in field 1.
No, there's only three lines, but
On 8/11/13 10:33 PM, J. Landman Gay wrote:
On 8/11/13 10:10 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 7:25:47 PM, you wrote:
put this is line 1 cr into field 1
put this is line 2 cr cr after field 1
put the number of lines in field 1
-- but there are actually four lines in
Jacque-
Sunday, August 11, 2013, 8:33:19 PM, you wrote:
No, there's only three lines, but the insertion point is placed after
the text, where the next potential line will start.
OK. Got it.
--
-Mark Wieder
mwie...@ahsoftware.net
___
On 8/11/13 10:28 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 8:07:23 PM, you wrote:
The it variable is empty, and the new file appears on disk. I want to
do this:
put pathToPngquant 16 (the text of img 1) into tCmd
get shell(tCmd) -- get binary data back
Or, if
On 8/11/13 10:43 PM, J. Landman Gay wrote:
On 8/11/13 10:28 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 8:07:23 PM, you wrote:
The it variable is empty, and the new file appears on disk. I want to
do this:
put pathToPngquant 16 (the text of img 1) into tCmd
get
On 8/11/13 10:43 PM, J. Landman Gay wrote:
On 8/11/13 10:28 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 8:07:23 PM, you wrote:
The it variable is empty, and the new file appears on disk. I want to
do this:
put pathToPngquant 16 (the text of img 1) into tCmd
get
On 12/08/2013, at 01:33 PM, J. Landman Gay wrote:
On 8/11/13 10:10 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 7:25:47 PM, you wrote:
put this is line 1 cr into field 1
put this is line 2 cr cr after field 1
put the number of lines in field 1
-- but there are actually
Jacque-
Sunday, August 11, 2013, 8:51:20 PM, you wrote:
But wait! There's more! If I do this, it does work:
put pathToPngquant 16pathToImg into tCmd
I get binary back. :) Thank you, thank you.
Another way to do it:
put cat pathToImg | pngquant 16 into tCmd
--
-Mark Wieder
Richard-
Sunday, August 11, 2013, 7:19:23 PM, you wrote:
Exactly. I was just being kind to the ol' timers. :)
LOL.
--
-Mark Wieder
mwie...@ahsoftware.net
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to
On Sun, Aug 11, 2013 at 8:22 PM, Mark Wieder mwie...@ahsoftware.net wrote:
All those operations can be shelled out easily
Ah, but if you want to be able to do this from an iPad? Possible, or pipe
dream?
On Sun, Aug 11, 2013 at 8:52 PM, Monte Goulding mo...@sweattechnologies.com
wrote:
On 8/11/13 11:12 PM, Mark Wieder wrote:
Jacque-
Sunday, August 11, 2013, 8:51:20 PM, you wrote:
But wait! There's more! If I do this, it does work:
put pathToPngquant 16pathToImg into tCmd
I get binary back. :) Thank you, thank you.
Another way to do it:
put cat pathToImg |
Jacque-
Sunday, August 11, 2013, 9:33:09 PM, you wrote:
put cat pathToImg | pngquant 16 into tCmd
Cool. What's the pipe do? Is that like ?
Yeah, sort of. It takes the output of the first command (cat) that
normally would go to stdout and redirects it (pipes it) into the stdin
input of the
Geoff-
Sunday, August 11, 2013, 9:32:26 PM, you wrote:
Ah, but if you want to be able to do this from an iPad? Possible, or pipe
dream?
You keep adding more aspects to this proposal. I normally run away
from projects like that. Next you'll want to add tail fins.
--
-Mark Wieder
Anything is possible (you would definitely need an external) but your starting
to talk about doing a lot of work to hack a distributed database out of a
source code management system. I would definitely look at other options.
Does your data really need to be local?
Cheers
--
M E R Goulding
Terry-
Sunday, August 11, 2013, 8:54:28 PM, you wrote:
I agree with Mark that there are four lines there. The last one just happens
to be empty.
Terry...
I do think that's a matter of semantics of the visual display, though,
and that's a different thing from the mechanics of how items,
52 matches
Mail list logo
