Re: Polygrid sorting (problems)

2022-08-15 Thread Mark Wieder via use-livecode

On 8/15/22 16:43, Mark Wieder via use-livecode wrote:

On 8/15/22 16:22, Alex Tweedly via use-livecode wrote:

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


I do see tsvData in the dictionary, but I'm getting weird errors thrown 
from the widget when I try to use it. May still be experimental. There 
aren't any examples and the source isn't available.


Correcting myself, I do see examples in the enhancements folder, they 
just aren't installed. There's also a Plugins/Templates/Default folder 
for various things, but I'm not sure what I'm supposed to do with those, 
if anything. If I use just the examples in the folder then the I can 
manipulate the tsvData and it works. But if I try to generate my own I 
end up throwing weird errors.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting (problems)

2022-08-15 Thread Paul Dupuis via use-livecode

On 8/15/2022 7:51 PM, Paul Dupuis via use-livecode wrote:

On 8/15/2022 7:22 PM, Alex Tweedly via use-livecode wrote:


On 15/08/2022 20:34, Paul Dupuis via use-livecode wrote:
So there is an example of sorting in the PolyGrid documentation 
under the entry for the MESSAGE "headerClick" and under the entry to 
the PROPERTY "text" (and in 'the text of me')


The example code only sort the visible rows as "the text of widget 
X" returns the data of PolyGrid X as tab delimited, WITHOUT the 
column headers, but ONLY the visible rows.


I'm using (I think) the latest version 
(com.livecode.widget.polygrid.1.1.1) and I don't see that problem at 
all.




Okay, a widget ignorant question: How do you tell what version of a 
widget you have installed? (i.e where/how do you see 
com.livecode.widget.polygrid.1.1.1)


Never mind. It is in the file name, com.livecode.widget.polygrid.1.1.1.lce

Also, FYI, regarding you note that:

Both "the text and "the pgtext" return the entire grid (without headers).

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


Under the dictionary entry for "polygrid", I see the csvData and tsvData 
properties listed. The "text" property and the pgData property, but NO 
entry for pgText. It would appear, if the .lce file name is correct, 
that I am at the same version, 1.1.1. I am on Windows 10, under LC 9.6.8


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting (problems)

2022-08-15 Thread Paul Dupuis via use-livecode

On 8/15/2022 7:22 PM, Alex Tweedly via use-livecode wrote:


On 15/08/2022 20:34, Paul Dupuis via use-livecode wrote:
So there is an example of sorting in the PolyGrid documentation under 
the entry for the MESSAGE "headerClick" and under the entry to the 
PROPERTY "text" (and in 'the text of me')


The example code only sort the visible rows as "the text of widget X" 
returns the data of PolyGrid X as tab delimited, WITHOUT the column 
headers, but ONLY the visible rows.


I'm using (I think) the latest version 
(com.livecode.widget.polygrid.1.1.1) and I don't see that problem at all.




Okay, a widget ignorant question: How do you tell what version of a 
widget you have installed? (i.e where/how do you see 
com.livecode.widget.polygrid.1.1.1)


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Sorting [was: Polygrid sorting]

2022-08-15 Thread Paul Dupuis via use-livecode
Perhaps some expansion of the column "pgContentTypeofColumn" property? 
The current possible values are: 
text|svg-lcname|imagedata|imagefile|color|boolean|autoincrement
Allowing the addition of 'numeric' and 'datetime' would at least allow a 
mapping to sorts although sort support 'international' (perhaps should 
be the default for a polygrid column of type "text" and "binary". I am 
also not sure how svg-iconname, imagedata, imagefile, and color should 
sort. Perhaps svg-iconname should sort as "text". Bolean can sort as 
"text" since ascending puts "false" first and descending puts "true" first.



On 8/15/2022 7:25 PM, Alex Tweedly via use-livecode wrote:
So it occurred to me, while playing with sorting by columns, that it 
might be nice to have an additional "sortType" available.


I'd like to be able to say

 - if all the 'things' being sorted on are numbers, then sort numeric, 
otherwise sort alphabetical.


Would that be a reasonable enhancement request ?

Would "natural" be a reasonable suggested name ?

Alex.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting (problems)

2022-08-15 Thread Mark Wieder via use-livecode

On 8/15/22 16:22, Alex Tweedly via use-livecode wrote:

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


I do see tsvData in the dictionary, but I'm getting weird errors thrown 
from the widget when I try to use it. May still be experimental. There 
aren't any examples and the source isn't available.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Sorting [was: Polygrid sorting]

2022-08-15 Thread Bob Sneidar via use-livecode
Datagrids have this feature, so yes, I would expect there to be some way to 
specify what kind of sort you want to do. But it would have to be on a per 
column basis. 

But if you are sorting the text yourself, you can use the syntax: sort lines of 
tText by item n of each.

I don't think any assumptions should be made by the engine as to what kind of 
data each column contains. I worked with an accounting system many years ago 
which had numeric invoice numbers, or so it seemed. Once you created a credit 
memo, it prepended R to the invoice number. 

Bob S


> On Aug 15, 2022, at 16:25 , Alex Tweedly via use-livecode 
>  wrote:
> 
> So it occurred to me, while playing with sorting by columns, that it might be 
> nice to have an additional "sortType" available.
> 
> I'd like to be able to say
> 
>  - if all the 'things' being sorted on are numbers, then sort numeric, 
> otherwise sort alphabetical.
> 
> Would that be a reasonable enhancement request ?
> 
> Would "natural" be a reasonable suggested name ?
> 
> Alex.
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting (problems)

2022-08-15 Thread Bob Sneidar via use-livecode
I think they are trying to be consistent with datagrid terminology, perhaps 
thinking that a tabular data object has become a new class of objects. 

Bob S


> On Aug 15, 2022, at 16:22 , Alex Tweedly via use-livecode 
>  wrote:
> 
> 
> On 15/08/2022 20:34, Paul Dupuis via use-livecode wrote:
>> So there is an example of sorting in the PolyGrid documentation under the 
>> entry for the MESSAGE "headerClick" and under the entry to the PROPERTY 
>> "text" (and in 'the text of me')
>> 
>> The example code only sort the visible rows as "the text of widget X" 
>> returns the data of PolyGrid X as tab delimited, WITHOUT the column headers, 
>> but ONLY the visible rows.
>> 
> I'm using (I think) the latest version (com.livecode.widget.polygrid.1.1.1) 
> and I don't see that problem at all.
> 
> Both "the text and "the pgtext" return the entire grid (without headers).
> 
> I haven't tried csvdata or tsvdata (they're not listed in the dictionary, so 
> I'd tend to avoid them if possible.
> 
> And come to think of it - why did they need to invent a new property name 
> "pgText" ?  It seems to be a synonym for "the text", so would it not have 
> been better to just use that ?  Full consistency with many other controls, no 
> added "mental clutter", and "the text" colours nicely in the script editor, 
> so more obvious if you mistype it.
> 
> Alex.
> 
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Sorting [was: Polygrid sorting]

2022-08-15 Thread Alex Tweedly via use-livecode
So it occurred to me, while playing with sorting by columns, that it 
might be nice to have an additional "sortType" available.


I'd like to be able to say

 - if all the 'things' being sorted on are numbers, then sort numeric, 
otherwise sort alphabetical.


Would that be a reasonable enhancement request ?

Would "natural" be a reasonable suggested name ?

Alex.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting (problems)

2022-08-15 Thread Alex Tweedly via use-livecode


On 15/08/2022 20:34, Paul Dupuis via use-livecode wrote:
So there is an example of sorting in the PolyGrid documentation under 
the entry for the MESSAGE "headerClick" and under the entry to the 
PROPERTY "text" (and in 'the text of me')


The example code only sort the visible rows as "the text of widget X" 
returns the data of PolyGrid X as tab delimited, WITHOUT the column 
headers, but ONLY the visible rows.


I'm using (I think) the latest version 
(com.livecode.widget.polygrid.1.1.1) and I don't see that problem at all.


Both "the text and "the pgtext" return the entire grid (without headers).

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


And come to think of it - why did they need to invent a new property 
name "pgText" ?  It seems to be a synonym for "the text", so would it 
not have been better to just use that ?  Full consistency with many 
other controls, no added "mental clutter", and "the text" colours nicely 
in the script editor, so more obvious if you mistype it.


Alex.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Shouldn't space or enter in a menu select the hilited item?

2022-08-15 Thread Bob Sneidar via use-livecode
I should also mention that menuPick IS getting triggered, but if I use spacebar 
or return to select, the parameter for which item got picked is empty. If I 
click then the parameter is NOT empty it's the item I clicked. 

Bob S


> On Aug 15, 2022, at 15:03 , Bob Sneidar via use-livecode 
>  wrote:
> 
> Hi Craig. It's not a popup menu it's a combo box. I do use popup menus and 
> those work as advertized. 
> 
> When I click to expand a combo box menu, it I get the list of items, and if I 
> click an item, it correctly selects that item. If however I use the arrow 
> keys to hilite an item then use the space bar or return to select the hilited 
> item, the hilited item is NOT selected, it retains it's previous label. 
> 
> Bob S
> 
> 
>> On Aug 15, 2022, at 11:03 , Craig Newman via use-livecode 
>>  wrote:
>> 
>> Hi, I was not complete. Once the arrow keys have found the menuItem of 
>> interest, clicking Enter or Return executes the menuPick handler.
>> 
>> Craig
>> 
>>> On Aug 12, 2022, at 7:37 PM, Bob Sneidar via use-livecode 
>>>  wrote:
>>> 
>>> Hi all. Very odd, I thought this worked. 
>>> 
>>> I am programmatically popping up a menu, then I want to be able to jse the 
>>> arrow keys to traverse the selections available. If I click any of the 
>>> choices, the menuPick handler gets the choice as the first parameter. If 
>>> however I use the spacebar or the enterKey to select a choice, the 
>>> parameter is empty in menuPick! That isn't right, is it??
>>> 
>>> MacOS 10.15.7 LC 9.6.9 rc1
>>> 
>>> Bob S
>>> 
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Shouldn't space or enter in a menu select the hilited item?

2022-08-15 Thread Bob Sneidar via use-livecode
Hi Craig. It's not a popup menu it's a combo box. I do use popup menus and 
those work as advertized. 

When I click to expand a combo box menu, it I get the list of items, and if I 
click an item, it correctly selects that item. If however I use the arrow keys 
to hilite an item then use the space bar or return to select the hilited item, 
the hilited item is NOT selected, it retains it's previous label. 

Bob S


> On Aug 15, 2022, at 11:03 , Craig Newman via use-livecode 
>  wrote:
> 
> Hi, I was not complete. Once the arrow keys have found the menuItem of 
> interest, clicking Enter or Return executes the menuPick handler.
> 
> Craig
> 
>> On Aug 12, 2022, at 7:37 PM, Bob Sneidar via use-livecode 
>>  wrote:
>> 
>> Hi all. Very odd, I thought this worked. 
>> 
>> I am programmatically popping up a menu, then I want to be able to jse the 
>> arrow keys to traverse the selections available. If I click any of the 
>> choices, the menuPick handler gets the choice as the first parameter. If 
>> however I use the spacebar or the enterKey to select a choice, the parameter 
>> is empty in menuPick! That isn't right, is it??
>> 
>> MacOS 10.15.7 LC 9.6.9 rc1
>> 
>> Bob S
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode

On 8/15/2022 4:55 PM, Mark Wieder via use-livecode wrote:

On 8/15/22 13:12, Paul Dupuis via use-livecode wrote:
So I see that the Summer Bundle of widgets in the store has a note 
that says "Latest update 1.0.19: 11 August 2022"


However, the Download button says "Version 1.0.0". Does anyone know 
how to update the widget set to 1.0.19 or how to update a single widget?


Yeah. The versioning is wonky and annoying. Apparently the 1.0.0 
version is always the most recent.


From a July 27 comment from Steven Crighton on 
https://livecode.com/polylist-widget-in-the-spotlight/#comment-129572


For the moment you have to update the new widgets manually. To do 
this, first log in to your LiveCode account. In the left hand 
navigation make your way to Products > thirdparty. Scroll down this 
list to find LiveCode Enhancements and download that bundle. Inside 
the bundle folder there is a widgetpackinstaller.livecode file – If 
you want to update everything in your bundle in one go I recommend 
using that. Simply open that stack and click the install button. Note 
– DataView will now be PolyList after you have updated.


I updated once and looks like I'll have to again.



Thank you Mark! (and Steven)

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Mark Wieder via use-livecode

On 8/15/22 13:12, Paul Dupuis via use-livecode wrote:
So I see that the Summer Bundle of widgets in the store has a note that 
says "Latest update 1.0.19: 11 August 2022"


However, the Download button says "Version 1.0.0". Does anyone know how 
to update the widget set to 1.0.19 or how to update a single widget?


Yeah. The versioning is wonky and annoying. Apparently the 1.0.0 version 
is always the most recent.


From a July 27 comment from Steven Crighton on 
https://livecode.com/polylist-widget-in-the-spotlight/#comment-129572


For the moment you have to update the new widgets manually. To do this, 
first log in to your LiveCode account. In the left hand navigation make 
your way to Products > thirdparty. Scroll down this list to find 
LiveCode Enhancements and download that bundle. Inside the bundle folder 
there is a widgetpackinstaller.livecode file – If you want to update 
everything in your bundle in one go I recommend using that. Simply open 
that stack and click the install button. Note – DataView will now be 
PolyList after you have updated.


I updated once and looks like I'll have to again.

--
--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode

FYI,

I also just tested on a MacBook Air, M1, running Monterey with LC9.6.8 
and the version 1.0.0 of the Summer Bundle widget packs and the PolyGrid 
and my sample stack displayed for me at 10, 100, and 500 columns and rows.



On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result.

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
I just tested on macOS Mojave (10.14) on an Intel MacBook Pro and the 
PolyGrid and my sample stack work as expected. Tried 10, 100, and 500 
columns/rows.


Now I have to find the MacBook Air with Monterey and see...


8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result.

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
So I see that the Summer Bundle of widgets in the store has a note that 
says "Latest update 1.0.19: 11 August 2022"


However, the Download button says "Version 1.0.0". Does anyone know how 
to update the widget set to 1.0.19 or how to update a single widget?




On 8/15/2022 2:29 PM, Paul Dupuis via use-livecode wrote:

So, I bought the Summer Bundle. Yes, it is a good deal.

In my case it was primarily for the Polygrid widget. Our application 
uses a Datagrid to display customer research data. The columns headers 
are text and the left most column ROWs are test and all other cells 
are numbers. Some customers can have quite large data sets and I have 
been running into the number of columns (ad a default width of 100px 
per column) exceeding a GROUPs 32,767px width maximum (about 327-328 
columns). At this point the Datagrid just fails - no data is displayed.


I can now attest that a Polygrid (under LC 9.6.8) does not have this 
limit. I have a "test" stack (for Datagrid testing) I converted to the 
Polygrid and can easily generate 1000 columns x 1000 rows of data and 
it works.


So I guess the answer to bug 
https://quality.livecode.com/show_bug.cgi?id=23875 is "Use the PolyGrid"


On that note, the Datagrid has 2 features I use in this specific case, 
user column resizing (built into the Polygrid - Yea!) and column 
sorting (NOT built into the Polygrid - Boo!). So, does anyone have 
some column sort code for the Polygrid they have written that they 
might be willing to share?


Also, I have filled a Polygrid enhancement request to allow the left 
column (or the left N columns) to be locked/frozen, so they remain 
visible when the Polygrid is scrolled horizontally. See 
https://quality.livecode.com/show_bug.cgi?id=23880. If you might 
benefit from this enhancement, please follow the bug or add a comment 
to that effect.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
Okay, I built the stack and tested it under Windows 10. The 3 beeps are 
intentional. It is to let me know when it is done as some test with 500+ 
columns/rows takes a while. It does display under LC9.6.8 (64 bit) on 
Windows 10.


Now I have to go try it on macOS?



On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result.

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark


On 15 Aug 2022, at 7:29 pm, Paul Dupuis via use-livecode 
 wrote:

So, I bought the Summer Bundle. Yes, it is a good deal.

In my case it was primarily for the Polygrid widget. Our application uses a 
Datagrid to display customer research data. The columns headers are text and 
the left most column ROWs are test and all other cells are numbers. Some 
customers can have quite large data sets and I have been running into the 
number of columns (ad a default width of 100px per column) exceeding a GROUPs 
32,767px width maximum (about 327-328 columns). At this point the Datagrid just 
fails - no data is displayed.

I can now attest that a Polygrid (under LC 9.6.8) does not have this limit. I have a 
"test" stack (for Datagrid testing) I converted to the Polygrid and can easily 
generate 1000 columns x 1000 rows of data and it works.

So I guess the answer to bug https://quality.livecode.com/show_bug.cgi?id=23875 is 
"Use the PolyGrid"

On that note, the Datagrid has 2 features I use in this specific case, user 
column resizing (built into the Polygrid - Yea!) and column sorting (NOT built 
into the Polygrid - Boo!). So, does anyone have some column sort code for the 
Polygrid they have written that they might be willing to share?

Also, I have filled a Polygrid enhancement request to allow the left column (or 
the left N columns) to be locked/frozen, so they remain visible when the 
Polygrid is scrolled horizontally. See 
https://quality.livecode.com/show_bug.cgi?id=23880. If you might benefit from 
this enhancement, please follow the bug or add a comment to that effect.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting

2022-08-15 Thread Mark Smith via use-livecode
Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result. 

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark

> On 15 Aug 2022, at 7:29 pm, Paul Dupuis via use-livecode 
>  wrote:
> 
> So, I bought the Summer Bundle. Yes, it is a good deal.
> 
> In my case it was primarily for the Polygrid widget. Our application uses a 
> Datagrid to display customer research data. The columns headers are text and 
> the left most column ROWs are test and all other cells are numbers. Some 
> customers can have quite large data sets and I have been running into the 
> number of columns (ad a default width of 100px per column) exceeding a GROUPs 
> 32,767px width maximum (about 327-328 columns). At this point the Datagrid 
> just fails - no data is displayed.
> 
> I can now attest that a Polygrid (under LC 9.6.8) does not have this limit. I 
> have a "test" stack (for Datagrid testing) I converted to the Polygrid and 
> can easily generate 1000 columns x 1000 rows of data and it works.
> 
> So I guess the answer to bug 
> https://quality.livecode.com/show_bug.cgi?id=23875 is "Use the PolyGrid"
> 
> On that note, the Datagrid has 2 features I use in this specific case, user 
> column resizing (built into the Polygrid - Yea!) and column sorting (NOT 
> built into the Polygrid - Boo!). So, does anyone have some column sort code 
> for the Polygrid they have written that they might be willing to share?
> 
> Also, I have filled a Polygrid enhancement request to allow the left column 
> (or the left N columns) to be locked/frozen, so they remain visible when the 
> Polygrid is scrolled horizontally. See 
> https://quality.livecode.com/show_bug.cgi?id=23880. If you might benefit from 
> this enhancement, please follow the bug or add a comment to that effect.
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Polygrid sorting (problems)

2022-08-15 Thread Paul Dupuis via use-livecode
So there is an example of sorting in the PolyGrid documentation under 
the entry for the MESSAGE "headerClick" and under the entry to the 
PROPERTY "text" (and in 'the text of me')


The example code only sort the visible rows as "the text of widget X" 
returns the data of PolyGrid X as tab delimited, WITHOUT the column 
headers, but ONLY the visible rows.


So, what to use for sorting all the data in a PolyGrid by a particular 
column?


The tsvData of widget X (and csvData, and Text) doesn't seem to work. 
The all seems to only get the visible data (rows). Only the pgData of 
widget return the whole dataset of the PolyGrid. Is this the way these 
properties are supposed to work?


If that is how text, csvData, and tsvData are supposed to work 
(returning only the visible rows), then the sort example in the PolyGrid 
documentation require updating otherwise these properties require updating!




On 8/15/2022 2:29 PM, Paul Dupuis via use-livecode wrote:

So, I bought the Summer Bundle. Yes, it is a good deal.

In my case it was primarily for the Polygrid widget. Our application 
uses a Datagrid to display customer research data. The columns headers 
are text and the left most column ROWs are test and all other cells 
are numbers. Some customers can have quite large data sets and I have 
been running into the number of columns (ad a default width of 100px 
per column) exceeding a GROUPs 32,767px width maximum (about 327-328 
columns). At this point the Datagrid just fails - no data is displayed.


I can now attest that a Polygrid (under LC 9.6.8) does not have this 
limit. I have a "test" stack (for Datagrid testing) I converted to the 
Polygrid and can easily generate 1000 columns x 1000 rows of data and 
it works.


So I guess the answer to bug 
https://quality.livecode.com/show_bug.cgi?id=23875 is "Use the PolyGrid"


On that note, the Datagrid has 2 features I use in this specific case, 
user column resizing (built into the Polygrid - Yea!) and column 
sorting (NOT built into the Polygrid - Boo!). So, does anyone have 
some column sort code for the Polygrid they have written that they 
might be willing to share?


Also, I have filled a Polygrid enhancement request to allow the left 
column (or the left N columns) to be locked/frozen, so they remain 
visible when the Polygrid is scrolled horizontally. See 
https://quality.livecode.com/show_bug.cgi?id=23880. If you might 
benefit from this enhancement, please follow the bug or add a comment 
to that effect.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode

So, I bought the Summer Bundle. Yes, it is a good deal.

In my case it was primarily for the Polygrid widget. Our application 
uses a Datagrid to display customer research data. The columns headers 
are text and the left most column ROWs are test and all other cells are 
numbers. Some customers can have quite large data sets and I have been 
running into the number of columns (ad a default width of 100px per 
column) exceeding a GROUPs 32,767px width maximum (about 327-328 
columns). At this point the Datagrid just fails - no data is displayed.


I can now attest that a Polygrid (under LC 9.6.8) does not have this 
limit. I have a "test" stack (for Datagrid testing) I converted to the 
Polygrid and can easily generate 1000 columns x 1000 rows of data and it 
works.


So I guess the answer to bug 
https://quality.livecode.com/show_bug.cgi?id=23875 is "Use the PolyGrid"


On that note, the Datagrid has 2 features I use in this specific case, 
user column resizing (built into the Polygrid - Yea!) and column sorting 
(NOT built into the Polygrid - Boo!). So, does anyone have some column 
sort code for the Polygrid they have written that they might be willing 
to share?


Also, I have filled a Polygrid enhancement request to allow the left 
column (or the left N columns) to be locked/frozen, so they remain 
visible when the Polygrid is scrolled horizontally. See 
https://quality.livecode.com/show_bug.cgi?id=23880. If you might benefit 
from this enhancement, please follow the bug or add a comment to that 
effect.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Shouldn't space or enter in a menu select the hilited item?

2022-08-15 Thread Craig Newman via use-livecode
Hi, I was not complete. Once the arrow keys have found the menuItem of 
interest, clicking Enter or Return executes the menuPick handler.

Craig

> On Aug 12, 2022, at 7:37 PM, Bob Sneidar via use-livecode 
>  wrote:
> 
> Hi all. Very odd, I thought this worked. 
> 
> I am programmatically popping up a menu, then I want to be able to jse the 
> arrow keys to traverse the selections available. If I click any of the 
> choices, the menuPick handler gets the choice as the first parameter. If 
> however I use the spacebar or the enterKey to select a choice, the parameter 
> is empty in menuPick! That isn't right, is it??
> 
> MacOS 10.15.7 LC 9.6.9 rc1
> 
> Bob S
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Shouldn't space or enter in a menu select the hilited item?

2022-08-15 Thread Craig Newman via use-livecode
Hi.

I am missing something. Make a popup menu button. Ina mouseUp handler in 
another button:

on mouseUp
  click at the loc of btn 1
end mouseUp

Once the menu is open, the up and down arrow keys navigate among the menuItems.

Craig

> On Aug 12, 2022, at 7:37 PM, Bob Sneidar via use-livecode 
>  wrote:
> 
> Hi all. Very odd, I thought this worked. 
> 
> I am programmatically popping up a menu, then I want to be able to jse the 
> arrow keys to traverse the selections available. If I click any of the 
> choices, the menuPick handler gets the choice as the first parameter. If 
> however I use the spacebar or the enterKey to select a choice, the parameter 
> is empty in menuPick! That isn't right, is it??
> 
> MacOS 10.15.7 LC 9.6.9 rc1
> 
> Bob S
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: More Server Silliness -- Nevermind

2022-08-15 Thread Tim Selander via use-livecode
Using Firefox developer tools, found out jquery was not loading 
property.

Hangs head in shame at rookie mistake...

Still not working properly, but continue to poke at it.

Tim Selander

On 2022.08.15 21:58, Tim Selander via use-livecode wrote:
With Alex and everyone's help, I got the global vs cookies, etc., 
sorted out and am happily paginating away with my little 
membership web site.


With Kenji's help, I got automatic address fill-in from Japanese 
zip codes.


However, I was looking at LiveCode's server samples 
(serversamples.livecode.com/index.lc) and thought, gee, the Ajax 
filtering looks pretty neat.


So I set off to make that work, and failed. I'd give up on it, 
but after wasting THIS much time on it, I gotta bring it to you 
all for a little input and hopefully another bail-out.


Just for testing, I made two new files. The first with the code 
LC provides at 
https://serversamples.livecode.com/display-file.lc?filename=ajax-simple.lc 
and the second from step 3 of the ajax sample page, 
https://serversamples.livecode.com/ajax.lc.


Changed only the bits needed to pull data from my database. File 
one, ajax-simple.lc, lists my data and an input box just like the 
sample page. But it sends no info via GET to the second file, 
filter.lc. If I manually put the GET info in the 
URL,(filter.lc?search_term=John, I get the filtered data I 
expect, but in the filter.lc window -- the data is not returned 
to File 1, ajax-simple.lc.


Has anyone using LC Server gotten that ajax sample to work??

Many thanks,

Tim Selander







___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


[blog] Power Tools

2022-08-15 Thread Heather Laine via use-livecode
Dear List Folks,

Just dropping a note to draw your attention to a fine blog post by Mr Mark 
Wieder:

https://livecode.com/power-tools/

Enjoy!

Warm Regards,

Heather

Heather Laine
Customer Services Manager
LiveCode Ltd
www.livecode.com




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


More Server Silliness

2022-08-15 Thread Tim Selander via use-livecode
With Alex and everyone's help, I got the global vs cookies, etc., 
sorted out and am happily paginating away with my little 
membership web site.


With Kenji's help, I got automatic address fill-in from Japanese 
zip codes.


However, I was looking at LiveCode's server samples 
(serversamples.livecode.com/index.lc) and thought, gee, the Ajax 
filtering looks pretty neat.


So I set off to make that work, and failed. I'd give up on it, 
but after wasting THIS much time on it, I gotta bring it to you 
all for a little input and hopefully another bail-out.


Just for testing, I made two new files. The first with the code 
LC provides at 
https://serversamples.livecode.com/display-file.lc?filename=ajax-simple.lc 
and the second from step 3 of the ajax sample page, 
https://serversamples.livecode.com/ajax.lc.


Changed only the bits needed to pull data from my database. File 
one, ajax-simple.lc, lists my data and an input box just like the 
sample page. But it sends no info via GET to the second file, 
filter.lc. If I manually put the GET info in the 
URL,(filter.lc?search_term=John, I get the filtered data I 
expect, but in the filter.lc window -- the data is not returned 
to File 1, ajax-simple.lc.


Has anyone using LC Server gotten that ajax sample to work??

Many thanks,

Tim Selander







___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode