Re: DataGrid question...

2020-03-29 Thread Terry Judd via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Bob Sneidar via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Jerry Jensen via use-livecode
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.

Re: DataGrid question...

2020-03-29 Thread Pi Digital 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

Re: DataGrid question...

2020-03-29 Thread Bob Sneidar via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Bob Sneidar via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Pi Digital via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Pi Digital via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Jerry Jensen via use-livecode
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

Re: Save stack in HTML5

2020-03-29 Thread Sean Cole (Pi) via use-livecode
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

Re: Its very quiet

2020-03-29 Thread Mark Wieder via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Bob Sneidar via use-livecode
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,

Re: DataGrid question...

2020-03-29 Thread Sean Cole (Pi) via use-livecode
> > 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

Re: DataGrid question...

2020-03-29 Thread Sean Cole (Pi) via use-livecode
> > 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

Re: Its very quiet

2020-03-29 Thread Stephen Barncard via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Curry Kenworthy via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Richard Gaskin via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread scott--- via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Mark Wieder via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Bob Sneidar via use-livecode
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:

Re: Its very quiet

2020-03-29 Thread Pi Digital via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Pi Digital via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Bob Sneidar via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Bill Vlahos via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Terry Judd via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Bill Vlahos via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread scott--- via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Bill Vlahos via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Bill Vlahos via use-livecode
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: > >

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread J. Landman Gay via use-livecode
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

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Mark Wieder via use-livecode
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

Re: Ordering text

2020-03-29 Thread doc hawk via use-livecode
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); ___

Re: Hide stack change focus not supported 64bit

2020-03-29 Thread Bob Sneidar via use-livecode
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

Hide stack change focus not supported 64bit

2020-03-29 Thread Bill Vlahos via use-livecode
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

Re: DataGrid question...

2020-03-29 Thread Curry Kenworthy via use-livecode
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

Re: Its very quiet

2020-03-29 Thread Curry Kenworthy via use-livecode
> 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

Re: Ordering text

2020-03-29 Thread Bob Sneidar via use-livecode
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: > >

Re: Ordering text

2020-03-29 Thread doc hawk via use-livecode
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

Re: Ordering text

2020-03-29 Thread Bob Sneidar via use-livecode
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

Re: Ordering text

2020-03-29 Thread Rick Harrison via use-livecode
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. > >

Re: Ordering text

2020-03-29 Thread Terence Heaford via use-livecode
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

Re: Ordering text

2020-03-29 Thread Brian Milby 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

Re: Ordering text

2020-03-29 Thread Tore Nilsen via use-livecode
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

Ordering text

2020-03-29 Thread Terence Heaford via use-livecode
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 ——