If you're using an sql db:
SELECT thewordnumber, count(*) AS C FROM table 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 johnpat...@me.com wrote:
Thanks Kay!
That’s what
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
On Mon, May 5, 2014 at 2:42 PM, Peter Haworth p...@lcsql.com 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
On Mon, May 5, 2014 at 2:53 PM, Peter Haworth p...@lcsql.com 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
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 http://www.lcsql.com
Home of lcStackBrowser
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin
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
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
of the sending script
“answer it, or answer the result?
Thank you!
John patten
SUSD
On May 8, 2014, at 5:21 PM, Peter Haworth p...@lcsql.com wrote:
Hi John,
What's in the result after calling revExecuteSQL to issue your INSERT
statement? You should get either an integer count
Hengst iowahen...@mac.com wrote:
Hi Peter,
Check out: ResizeGroup by Bernd Niggemann on the LiveCode user samples…
and
And: http://forums.runrev.com/viewtopic.php?f=9t=17614p=102374#p102374
be well,
randy
On May 8, 2014, at 4:30 PM, Peter Haworth p...@lcsql.com wrote:
I have
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 mark@administrivia.solutions wrote:
Hi list,
I was mucking around in the IDE trying
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 capellan2...@gmail.com wrote:
Probably, the point of
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
+1
Pete
lcSQL Software
On May 19, 2014 11:09 PM, Jerry Jensen j...@jhj.com wrote:
On May 19, 2014, at 2:55 PM, Richard Gaskin ambassa...@fourthworld.com
wrote:
Alejandro Tejada wrote:
Richard Gaskin wrote
[snip]
With the field object now supporting independent column alignment, we
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
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 t.heaf...@btinternet.com wrote:
On 23
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
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 jac...@hyperactivesw.com 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
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?
Pete
lcSQL Software
On May 24, 2014 8:20 PM, J. Landman Gay jac
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
On May 29, 2014 7:49 AM, Igor de Oliveira Couto i...@semperuna.com
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
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 would
I think that was directed at me...
Pete
lcSQL Software
On May 30, 2014 7:12 PM, dunb...@aol.com 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
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
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
On Wed, Jun 4, 2014 at 3:37 AM, Skip Kimpel skiplon...@gmail.com 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
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
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
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 http://www.lcsql.com
Home of lcStackBrowser
On Thu, Jun 5, 2014 at 9:20 AM, Dr. Hawkins doch...@gmail.com 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
, at 11:39 AM, Dr. Hawkins doch...@gmail.com wrote:
On Thu, Jun 5, 2014 at 10:36 AM, Peter Haworth p...@lcsql.com wrote:
OK, misunderstood. However, the label field also shows up with margins
of
0,2,0,0 on my end.
So it does . . . but look at it--the text in the original fits
On Thu, Jun 5, 2014 at 5:58 PM, Paul Hibbert paulhibb...@mac.com 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
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
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
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 http://www.lcsql.com
Home of lcStackBrowser
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
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
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
://www.lcsql.com/sqliteadmin.html
On Tue, Jun 17, 2014 at 11:17 AM, la...@significantplanet.org wrote:
Thanks Pete,
Which version exactly is it?
Larry
- Original Message - From: Peter Haworth p...@lcsql.com
To: How to use LiveCode use-livecode@lists.runrev.com
Sent: Tuesday, June 17
is it?
Larry
- Original Message - From: Peter Haworth p...@lcsql.com
To: How to use LiveCode use-livecode@lists.runrev.com
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 the new version
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 I want to exit out of the outermost repeat loop
here
end repeat
do this and
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
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 mark_sm...@cpe.umanitoba.ca wrote:
I have two tables A and B, both with the same structure (about 50 columns
each). I
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
and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
On Sat, Jun 21, 2014 at 9:29 AM, Peter Haworth p...@lcsql.com wrote:
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
How do I get the location of the application folder using specialfolderpath?
With LC 6.6.2 on a Mac, specialfolderpath(Applications) returns
/Users/me/Library/Application Support, not the path to the applications
folder.
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin
Will report both these.
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, Jun 21, 2014 at 6:43 PM, Martin Koob mk...@rogers.com wrote:
Yes the docs should have Those listed.
:
Peter Haworth wrote
SELECT tableA.*,tableB.* FROM tableA JOIN tableB ON
tableB.keycolumn=tableA.keycolumn
Hi Peter. So, do I understand correctly that if table A has fields first,
last and table B has fields age, sex and they both have an id column (key
column) then this code would
On Sun, Jun 22, 2014 at 6:55 AM, Mark Smith mark_sm...@cpe.umanitoba.ca
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
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,
one riskier than the other.
The less risky approach is to give up on using
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
Submitted QCC report 12691 for this.
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, Jun 21, 2014 at 3:00 PM, Alex Tweedly a...@tweedly.org wrote:
On 21/06/2014 15:22,
On Thu, Jun 26, 2014 at 8:22 AM, Richard Gaskin ambassa...@fourthworld.com
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
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
PM, dunb...@aol.com wrote:
Peter,
Can you tell me more about what this error is and does?
Craig
-Original Message-
From: Peter Haworth p...@lcsql.com
To: How to use LiveCode use-livecode@lists.runrev.com
Sent: Thu, Jun 26, 2014 5:12 pm
Subject: Name shadows
On Fri, Jun 27, 2014 at 7:08 PM, Mark Wieder mwie...@ahsoftware.net 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.
On Fri, Jun 27, 2014 at 7:08 PM, Mark Wieder mwie...@ahsoftware.net 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
On Mon, Jun 30, 2014 at 7:38 AM, Ben Rubinstein benr...@cogapp.com 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
Wondering if there's a good reason why the imageData property of an image
is not included in its properties?
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
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
://www.lcsql.com/sqliteadmin.html
On Mon, Jun 30, 2014 at 9:39 PM, Monte Goulding mo...@sweattechnologies.com
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 p...@lcsql.com wrote:
Wondering
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[data]
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
On Wed, Jul 2,
I guess you could lock messages but that would lock all messages not just
mouse events.
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, Jul 3, 2014 at 10:32 AM, William
On Thu, Jul 3, 2014 at 12:26 PM, Brahmanathswami bra...@hindu.org 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/
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 the
http://www.lcsql.com/sqliteadmin.html
On Sat, Jul 5, 2014 at 11:37 AM, Richmond richmondmathew...@gmail.com
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?
In other words, if I'm in the UK and pass
://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
On Sat, Jul 5, 2014 at 1:20 PM, Richmond richmondmathew...@gmail.com
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
the input format. I
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 http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin
this as a user note to the
dictionary but never got past an attempting to log in... message.
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, Jul 5, 2014 at 2:08 PM, Peter Haworth p
Have you checked the contents of tDBID? I don;t see it as a a parameter to
your function.
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, Jul 6, 2014 at 7:46 AM, Klaus major-k
21:26 schrieb Peter Haworth p...@lcsql.com:
Have you checked the contents of tDBID? I don;t see it as a a parameter
to
your function.
you obviously missed my second posting where I embarrassingly had to admit
that i did not check SQLite on the iOS tab of the standalone builder
settings 8
I have a stack with two cards in it each of which is a different size.
I've been trying to adjust the size of each card in preOpenCard handlers
without affecting the card's previous display location.
Feels like I'm making this harder than it needs to be but I've ended up
saving the topLeft of
and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
On Mon, Jul 7, 2014 at 6:03 PM, Trevor DeVore li...@mangomultimedia.com
wrote:
On Monday, July 7, 2014, Peter Haworth p...@lcsql.com wrote:
I have a stack with two cards in it each of which is a different size.
I've been trying to adjust
On Tue, Jul 8, 2014 at 10:31 AM, Robert Brenstein r...@robelko.com wrote:
When you have 2 cards of different sizes, it might be simpler to just have
two stacks (substacks) and switch between them rather than fiddle with
resizing.
That's what I usually do but it makes sense to have multiple
://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin http://www.lcsql.com/sqliteadmin.html
On Tue, Jul 8, 2014 at 2:47 PM, kee nethery k...@kagi.com wrote:
On Jul 8, 2014, at 2:27 PM, Scott Rossi sc...@tactilemedia.com wrote:
On 7/8/14 9:44 AM, Peter Haworth p...@lcsql.com wrote:
I have a stack
...@tactilemedia.com wrote:
On 7/8/14 9:44 AM, Peter Haworth p...@lcsql.com wrote:
I have a stack with two cards in it each of which is a different size.
I've been trying to understand how this is possible. Do you mean you're
adjusting the stack dimensions to accommodate content of different
of tAppRect1 - item 2 of tAppRect2 into tWindowTitle
Peter Haworth wrote
I just remembered that the
formattedHeight does not include the height of the title bar at the top
of
the stack so I'm pretty sure that's what is causing the problem.
Unfortunately, I think the title bar
I recently posted about how to adjust the size of different cards within a
stack and part of the solution I tried was using the formattedWidth and
formattedHeight properties (actually the effective versions of them).
I'm now seeing that the formattedWidth (and probably formattedHeight)
return
I think adding the tab at the end of the pattern will ensure this works, so:
^[a-z]\d+\t
Somewhat depends on exactly what he's looking for with the regex but the
important part is the ^ and the \t with the rest being dependent on the
format of what he's looking for.
Pete
lcSQL Software
Hi Skip,
I just tried your code in a test stack using LC 6.6.2
The data I used was:
AP6003tabxyz
AP6003BFtabReplacement for AP6003
AP6003XYtabdef
Only line 1 was selected.
It's possible I'm misinterpreting the way your data is laid out.
Are you sure that tRegExp has AP6003 in it? And that
You could also do this without using a regexp:
filter tdg2Text with (tRegExp tab *) into field Field2
Just in case there's something weird happening with the regexp
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin
,
Scott Rossi
Creative Director
Tactile Media, UX/UI Design
On 7/10/14 10:07 AM, Peter Haworth p...@lcsql.com wrote:
I recently posted about how to adjust the size of different cards within a
stack and part of the solution I tried was using the formattedWidth and
formattedHeight properties
://www.lcsql.com/sqliteadmin.html
On Thu, Jul 10, 2014 at 11:10 AM, Richmond richmondmathew...@gmail.com
wrote:
On 10/07/14 20:07, Peter Haworth wrote:
snip
Is there some other property that can be used to set the width of a stack
to something that really does include all the objects on it?
snip
Oh yes, plus ignoring hidden controls
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, Jul 10, 2014 at 12:05 PM, Peter Haworth p...@lcsql.com wrote:
Thanks Richmond, that's
to get right/bottom
positions you want without looping through the card objects.
Regards,
Scott Rossi
Creative Director
Tactile Media, UX/UI Design
On 7/10/14 12:02 PM, Peter Haworth p...@lcsql.com wrote:
Hi SCott,
Yes, I'm currently doing what you suggest by looking at all
Yes, I think the problem is with the dictionary entry for formattedWidth
since it claims the formattedWidth of a card is the rectangle that contains
all its visible objects, which is not true.
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html
visible objects, not the rect of the
objects.
Horse = beaten yet? :-)
Regards,
Scott Rossi
Creative Director
Tactile Media, UX/UI Design
On 7/10/14 2:49 PM, Peter Haworth p...@lcsql.com wrote:
Yes, I think the problem is with the dictionary entry for formattedWidth
since it claims
SQLite is case sensitive so bank is not the same as Bank. You can fix
that either by defining the column containing bank to be COLLATE NOCASE
or use the UPPER function around the last concatenation, then LIKE '%BANK%'.
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser
://www.lcsql.com/sqliteadmin.html
On Sat, Jul 12, 2014 at 7:20 PM, Dr. Hawkins doch...@gmail.com wrote:
On Sat, Jul 12, 2014 at 6:11 PM, Peter Haworth p...@lcsql.com wrote:
SQLite is case sensitive so bank is not the same as Bank. You can fix
that either by defining the column containing bank
Thanks, our posts crossed.
Still confused though. There is no $ wildcard available for the LIKE
operator, only % and _
One other possibility. It seems the LIKE operator has problems with
non-ASCII characters - any chance asset includes some, perhaps accented
characters?
Pete
lcSQL Software
://www.lcsql.com/sqliteadmin.html
On Sun, Jul 13, 2014 at 12:05 PM, Dr. Hawkins doch...@gmail.com wrote:
On Sun, Jul 13, 2014 at 10:00 AM, Peter Haworth p...@lcsql.com wrote:
Still confused though. There is no $ wildcard available for the LIKE
operator, only % and _
That came from typing
checking
each column individually.
Pete
lcSQL Software
On Jul 13, 2014 12:05 PM, Dr. Hawkins doch...@gmail.com wrote:
On Sun, Jul 13, 2014 at 10:00 AM, Peter Haworth p...@lcsql.com wrote:
Still confused though. There is no $ wildcard available for the LIKE
operator, only % and _
That came
Yes indeed Skip, regex is the way to go :-)
matchText(theColumn,^(.*?)\s*$,tOutput) should put the text minus
trailing spaces into the tOutput variable.
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser http://www.lcsql.com/lcstackbrowser.html and
SQLiteAdmin
One other thought. Is the data coming for an SQL database? If so then
this will do it for you:
SELECT rtrim(columnname) FROM..
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
I can't decide if this is a problem or not but the revAvailableHandlers
function happily returns information about handlers in a password protected
stack without requiring the password.
I guess it's not actually showing any code but feels like it should act the
same as trying to get the script of
On Mon, Jul 14, 2014 at 8:20 PM, stephen barncard
stephenrevoluti...@barncard.com wrote:
not unless you don't want to run the scripts...
Sorry Stephen, too many negatives in there for me to wrap my brain around
:-)
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser
Hi Terry,
I came up with a technique to right justify columns in a scrolling list
field a while back. It might tide you over until the real thing comes
along. If you're interested, email me off list and I'll dig it out for you.
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser
Maybe the Kickstarter 15% commission? The Kickstarter plus is the larger
audience though. Looking at the current HTML5 campaign, it's a long way
off making its' goal right now so the larger audience may have been needed.
The campaign is about half way though as of today. At the current run
1 - 100 of 2974 matches
Mail list logo