I have approx. 7000 lines of tab delimited data.
When I execute the code snippet below if the sort order is descending it takes
approx 120 milliseconds otherwise it takes 20 milliseconds to process.
Can someone explain why and perhaps come up with a faster solution.
Thanks
Terry
——
re
I believe the reason for the delay comes from the fact that when sorted
descending, you put tRec & CR before tCellData. Tp put something before a
container is slower than putting something after a container.
Regards
Tore Nilsen
> 29. mar. 2020 kl. 13:06 skrev Terence Heaford via use-livecode
>
Is there a key that you can use to sort? May be faster to build it and then
use the sort command at the end.
Thanks,
Brian
On Mar 29, 2020, 7:16 AM -0400, Tore Nilsen via use-livecode
, wrote:
> I believe the reason for the delay comes from the fact that when sorted
> descending, you put tRec
I believe it’s sorted (forgive the pun)
As the data is stored in an SQLite db I have used the db to sum the values then
worked from the top. Like below.
This results in approx. 20ms for each sort direction.
I have looked into a running total calc using SQLite but the solutions I found
seemed r
Hi Terry,
Try having your database retrieval perform the sort and not LiveCode.
Use the SQLite: ORDER BY clause.
See if that gives you a faster result.
Rick
> On Mar 29, 2020, at 7:06 AM, Terence Heaford via use-livecode
> wrote:
>
> I have approx. 7000 lines of tab delimited data.
>
> Whe
You took the SQL right out of my query. :-)
Bob S
On Mar 29, 2020, at 7:32 AM, Rick Harrison via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
Hi Terry,
Try having your database retrieval perform the sort and not LiveCode.
Use the SQLite: ORDER BY clause.
See if that gives you
I haven’t fully followed the queries that led to this, but would something like
SELECT SUM(OLD -NEW) FROM some_table WHERE need_to_calc IS true;
get you anywhere?
I’m also thinking of a lag within the list, to assign them all at once, but the
commands coming to memory are from statistical pack
Not enough info but something like:
SELECT SUM(OLD -NEW) as balance FROM some_table WHERE need_to_calc IS true
order by balance; (or order by whatever column. Not sure balance is what you
are trying to sort by.)
Bob S
> On Mar 29, 2020, at 11:54 AM, doc hawk via use-livecode
> wrote:
>
> I
> How about we all chime in on what we are currently working on?
Like many who have been sick between all the flu and corona going
around, just working on getting well again. Managed to stay out of
hospital, but not much energy. Quiet is good
Best wishes,
Curry Kenworthy
Custom Softwa
Pi:
> The only issue with using a field is you are limited to character
> data presentation only. You can’t put inline images, widgets,
> checkboxes, etc.
Mark:
> Now that's just patently not true. No problem with images:
> Set the imagesource of char x of field y of this card to tImageID
Thank
I have a stack that needs to hide itself so a different window (other
application) is now the frontmost window so my application can use AppleScript
keystroke command to enter information into the other window.
When I issue the command hide this stack my application window disappears but
doesn
Whaaa?? That is what I was seeing! In my case I used go invisible .
The stack I went to got focus, but going back to the calling stack did NOT
return focus. What I ended up doing is using set the defaultStack to
Bob S
On Mar 29, 2020, at 2:17 PM, Bill Vlahos via use-livecode
mailto:use-livec
As more cobwebs and dust fall away . . .
First impose a (temporary?) index column, idx, ordering the transactions, with
a step of 1.
And then you do something like
UPDATE theTable SET tBal=tBal(idx -1) + charge WHERE idx > MIN(idx);
___
use-li
On 3/29/20 2:17 PM, Bill Vlahos via use-livecode wrote:
The documentation in 9.5.1 says that hide stack is not supported in 64bit. What
is the alternative for MacOS X 64bit to temporarily hide my application?
Er... no. The documentation says
Additionally QuickTime does not include 64 bit su
On 3/29/20 4:17 PM, Bill Vlahos via use-livecode wrote:
When I issue the command hide this stack my application window disappears but
doesn’t lose focus. The target application that was behind my floating window
doesn’t become the frontmost application.
Hiding doesn't change anything but the
Bob,
I want my stack to completely hide not make another window of my application
the frontmost. I want the target application (like a web browser page) that was
underneath my app to now have focus.
Thanks,
Bill
> On Mar 29, 2020, at 2:21 PM, Bob Sneidar via use-livecode
> wrote:
>
> Whaaa?
Mark,
OK. That makes sense and matches the behavior as my window does hide.
However, the Mac doesn’t give any window the focus. My application doesn’t
really hide. It just closes the window but staying as the frontmost application.
I need my whole application to hide to give the target window w
This sounds like something AppleScript might be able to solve…
> On Mar 29, 2020, at 3:01 PM, Bill Vlahos via use-livecode
> wrote:
>
> Mark,
>
> OK. That makes sense and matches the behavior as my window does hide.
>
> However, the Mac doesn’t give any window the focus. My application doesn
I was hoping to avoid using AppleScript but I might have to.
The oldest version of LiveCode I have that behaves the way I want is 5.5.5.
LiveCode must have changed this after version 5.
Thank,
Bill Vlahos
> On Mar 29, 2020, at 3:38 PM, scott--- via use-livecode
> wrote:
>
> This sounds like
You can certainly use AS to query the frontmost application but I'm guessing as
soon as you click the button in your app then your app is it. You can also
query the application processes - if they are sorted in order from frontmost to
'rearmost' then maybe you could tell the second process in th
Sorry. That should read the newest version of LiveCode that behaves the way I
want is 5.5.5. I haven’t had to rebuild this application until now due to Apple
removing support for 32bit apps.
Bill
> On Mar 29, 2020, at 3:58 PM, Bill Vlahos wrote:
>
> I was hoping to avoid using AppleScript but
I just read the documentation. It seems to be talking about DontUseQT and
DonUseQTEffects, not hide stack itself.
Bob S
On Mar 29, 2020, at 2:21 PM, Bob Sneidar
mailto:bobsnei...@iotecdigital.com>> wrote:
The documentation in 9.5.1 says that hide stack is not supported in 64bit. What
is the
Fields: Images, yes. Other objects, no. Working out which cell has been
clicked, no.
Is that ‘fake news’? If so, sad face. If not, still sad face.
> Thanks Mark for catching and correcting that. Way too much inaccurate info
> and "fake news" about LiveCode gets propagated, and often picked
I thought you could embed checkboxes in a data grid? Not in a field of course,
but that’s always been the case. When have we ever been able to embed another
object in a field?
Bob S
On Mar 29, 2020, at 4:32 PM, Pi Digital via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
Fields:
Sorry to hear that, Curry. Rest up. Glad it hasn’t been too serious for you.
We’ll try and keep the noise down for you.
Sean Cole
Pi
> On 29 Mar 2020, at 21:40, Curry Kenworthy via use-livecode
> wrote:
>
> Like many who have been sick between all the flu and corona going around,
> just wo
On 3/29/20 1:50 PM, Curry Kenworthy via use-livecode wrote:
Way too much inaccurate info and "fake news" about LiveCode gets propagated
I think that's mischaracterized.
Just passing on some information (I hate it when someone says x can't be
done - that's a real push to do it). I've been emb
I have an app I’m working on right now that has check boxes that the user taps
in a list field. Swapping the imagesource works really well in this particular
case. Not that the dataGrid isn’t the required tool in some cases.
Scott Morrow
Elementary Software
(Now with 20% less chalk dust!)
web
Bob Sneidar wrote:
> I thought you could embed checkboxes in a data grid?
A DG is a collection of groups. Anything that can be put into a group
can be part of the group that defines the row.
> When have we ever been able to embed another object in a field?
"Embed"? Never. But we can displa
Pi:
> Fields: Images, yes. Other objects, no. Working out which cell
> has been clicked, no.
> Is that ‘fake news’? If so, sad face. If not, still sad face.
Well, sorry but I have to say YES it's largely fake news! :D
I'm ill and no strength for an argument (and BTW it has been a fairly
"seri
I'm rebuilding a 1980s era Ampex MM1200 Recording Device. 24/16/8 track.
For archiving.
No Livecode content though, although I will eventually make a remote
control using LiveCode Community ...
--
Stephen Barncard - Sebastopol Ca. USA -
mixstream.org
On Sun, Mar 29, 2020 at 4:36 PM Pi Digital via
>
> Working out which cell has been clicked: Sorry, that's not accurate
> either. Yes, we do have that! Also for a long time.
>
Hi,
As Curry's now unfortunately out of the conversation, can someone else help
me understand how you work out which cell has been clicked? He said it can
be done but ga
>
> Working out which cell has been clicked: Sorry, that's not accurate
> either. Yes, we do have that! Also for a long time.
>
Hi,
As Curry's now unfortunately out of the conversation, can someone else help
me understand how you work out which cell has been clicked? He said it can
be done but ga
The mouseControl.
> On Mar 29, 2020, at 7:06 PM, Sean Cole (Pi) via use-livecode
> wrote:
>
>>
>> Working out which cell has been clicked: Sorry, that's not accurate
>> either. Yes, we do have that! Also for a long time.
>>
>
> Hi,
>
> As Curry's now unfortunately out of the conversation,
On 3/29/20 7:00 PM, Stephen Barncard via use-livecode wrote:
I'm rebuilding a 1980s era Ampex MM1200 Recording Device. 24/16/8 track.
For archiving.
No Livecode content though, although I will eventually make a remote
control using LiveCode Community ...
!!! I thought the MM1200s were only 16 t
Colin,
Sorry I didn't even notice your message til just now.
For persistent data, you're going to need some form of storage. Usually,
websites utilise cookies. This is the more security-conscious way of
handling it, depending on the data of course. w3school.com/js/js_cookies.asp
has good examples
Hi Sean,
Have you seen Bernd Niggemann’s modTableField? It is built on top of the LC
list field, without a lot of the complications of DataGrids if you don’t need
DG’s huge capabilities. It might work well for you.
Regards,
Jerry Jensen
> On Mar 29, 2020, at 7:05 PM, Sean Cole (Pi) via use-livec
Hi Bob
That’ll return the field is I’m over but not the cell of the table field.
Unless, again, I am mistaken. Am I missing something.
Sean Cole
Pi Digital
> On 30 Mar 2020, at 03:09, Bob Sneidar via use-livecode
> wrote:
>
> The mouseControl.
>>> help
>> me understand how you work out
Hi Jerry
Thanks for the heads up about Bernd’s code. But I was interested in learning
how to get the cell index of a table field when clicked as we are told it was
solved a ‘long time’ ago. That makes it seem that it is general knowledge and
I’m a dunce for not being aware of it (which is very
The mouseControl!
Bob S
On Mar 29, 2020, at 8:35 PM, Pi Digital via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
Hi Jerry
Thanks for the heads up about Bernd’s code. But I was interested in learning
how to get the cell index of a table field when clicked as we are told it was
s
on mouseUp
put the mouseControl into tControl
put the long id of tControl into tID
put the short name of tControl into tName
end mouseUp
The short name will reveal the column number. The dgHilitedLine will give you
the line.
> On Mar 29, 2020, at 8:37 PM, Bob Sneidar via use-livecode
Ah Bob. You misunderstand. We are asking in reference to the table field, not
DG. Finding the index in data grid is very easy indeed. In a table field, it
so much as I was to understand. But apparently there is some magic I’ve missed
somewhere and perhaps I’m the only one. Do you know what it i
Hi Sean,
Sorry, I was thinking you might not need a DG at all. My mistake.
Anyway, just to be complete, Bernd’s modTableField API gives you the following:
mtfDataItemClicked pColumnClicked, pLineClicked, pItemContent, pGroupName
mtfDataItemClicked is send when the user clicks into a data cell.
4
OIC. I was struggling with that earlier today. The problem is, there is no
cell. Just a field. You can get the line with the clickLine, but I discovered
that even with cell editing on, the table field acted erratically, adding lines
when I didn’t want them.
Since you know the tabstops, you can
This is rough but sort of works...
on selectionChanged
set the itemDel to tab
put word 2 of the selectedLine into tRow
put word 2 of the selectedChunk into nChar
put length(line 1 to tRow-1 of me) into tStart
put char tStart+2 to nChar of me into tText
put the number of items in
I can't write a test handler right now, but I'm thinking you might be able do
something like this:
repeat for each item i in the tabstops of the field:
if the clickH > i and less than item i+1,
that's your column
The clickline gives you the row.
On 3/29/20 11:04 PM, Terry Judd via use-live
45 matches
Mail list logo
