Re: Datagrid internal error

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

On 8/10/2022 5:02 PM, Trevor DeVore via use-livecode wrote:

32,767 is the max for width as well. If there are enough columns it is
possible that the DataGrid is rendering a group that exceeds this limit and
hence the error. The DataGrid works around the limit when rendering rows,
but not when rendering columns.

I suppose a quick test would be to create a DataGrid with 330 columns that
are at least 100 pixels wide and see if you get the same error.



So I created 2 test stacks with a Datagrid and a button to set the 
number of columns and populate a row of data. One stack I did in 
Livecode 4.6.4 (the oldest I have) and one I built in Livecode 9.6.8 to 
see if there were differences in the handling of the error condition 
between versions of the Datagrid object.


[Note: Some of the Datagrids in our app are from LC 4.6.4 and we've 
never removed them and replaced them with newer versions and I don't 
believe Livecode does anything to automatically update the Datagrid 
objects in an old stack when opened in a new version of Livecode]


Under LC464, trying to create a number of columns with default widths 
that would exceed the 32,767 pixel width limit of the group object 
(using 330 columns with a default width of 100px or 33,000 pixels) produces:


1) A blank header (no columns)
2) Visible column for data, where only the visible columns of the first 
row (8 columns) are populated with data and when you scroll to the 
right, all remaining column of the 1st row of data are empty. The grid 
is scrollable horizontally to what looks to be around 320-330 columns.


Using 320 columns, works as expected. 325 works; 327 works. 328 only 
produces 327 columns in the header with 327 values for data in the first 
row. 329 produces a header with 329 columns and no data is rendered in 
the 1st row.


Under LC968, the LC968 test version of this with 330 columns produces:

1) Columns headers 1 to 8 (the header that are the visible width of the 
Datagrid)

2) No data is rendered and the grid is not scrollable.

Using 320 columns, works as expected. 325 works. 327 works. 328 produces 
327 columns in the header and no data in the first row. 329 is the same 
as 330 (only 8 visible column headers and no data and no scrolling).


So, the results are subtly different from Datagrids from LC4.6.4 and 
Datagrids from LC9.6.8, but both fail to do what a user would expect 
without any visible errors.


However, having the number of columns exceed the width of a Livecode 
group object in pixels does not seem to be the source of the error I am 
trying to track down which was:


Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to 
tColumnNames


tColumnNames is a variable containing a list of text lines that are 
customer entered column names, so they could be ANYTHING (up to 255 
chars, no control characters, including DEL (127)) that a user could 
type or paste into a field, including words in any language using Unicode.


As the executionContexts data does not contain the actual values of the 
variable tColumnNames when the error occurs AND (for reasons) I can not 
get the data from the customer, does ANYONE have any idea what 
tColumnNames might contain that could produce the error(s) show below?


Technical information:
Property: value is not a number: (Line 11, column 1)
Object: can't set object property: (Line 11, column 5)
set: can't set property: (Line 11, column 1)
Handler: error in statement: LayoutControl (Line 11, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDefaultHeaderButtonBehavior"
-
repeat: error in statement: (Line 5066, column 1)
Handler: error in statement: _table.ResizeHeaders (Line 5052, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
Handler: error in statement: _table.ResizeColumns (Line 4967, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
Handler: error in statement: _table.CreateColumns (Line 4737, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
Handler: error in statement: _table.RegenerateColumns (Line 4538, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
switch: error in statement: (Line 6150, column 1)
Handler: error in statement: dgProps (Line 5553, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
set: can't set property: (Line 5529, column 1)
Handler: error in statement: dgProp (Line 5529, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
set: can't set property: (Line 139, column 1)
if-then: error in statement: (Line 139, column 1)
Handler: error in statement: populateMe (Line 138, column 1)
Object: group "Table" of card "FrequencyReport" of stack "FreqReport.rwtl"
Object ID: group id 1162 of card id 1002 of stack 
"/Applications/HyperRESEARCH 4.5.4/Components/Tools/FreqReport.rwtl"


___
use-livecode mailing list

Re: Datagrid internal error

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

On 8/10/2022 5:02 PM, Trevor DeVore via use-livecode wrote:

32,767 is the max for width as well. If there are enough columns it is
possible that the DataGrid is rendering a group that exceeds this limit and
hence the error. The DataGrid works around the limit when rendering rows,
but not when rendering columns.

I suppose a quick test would be to create a DataGrid with 330 columns that
are at least 100 pixels wide and see if you get the same error.



Thank you!


___
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: Datagrid internal error

2022-08-10 Thread Paul Dupuis via use-livecode
I do appreciate the responses. My question was not about the number of 
records, but about the number of COLUMNS and whether there is any 
practical or known limit.


When my code is setting the column names, that list comes from customer 
entered data. I know that each name is less than 255 characters and 
restricts entry of certain characters (previously listed) such as comma, 
[ ], etc. How many names is unknown.


In this specific case of the error I reported, the customer is not in a 
position to be able to help much (if at all). Since it is customer data 
dependent, we are not able to reproduce the error in the IDE. SO my very 
specific questions was: Has any one seen an error like the one I 
reported (copied again below) OR know of any issues/limits when setting 
the dgProp["columns"] property of a Datagrid?


A customer encountered the following execution error (below) in our app 
(built on Livecode 9.6.7, MacOS 12.5). This error is occurring in the 
scripts for the Datagrid itself, rather than our code. At the end, it is 
one of our handler, "populateMe", where line 139 is where the error starts.


Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to 
tColumnNames


tColumnNames is a variable containing a list of text lines that are 
customer entered column names, so they could be ANYTHING (up to 255 
chars, no control characters, including DEL (127)) that a user could 
type or paste into a field, including words in any language using Unicode.


As the executionContexts data does not contain the actual values of the 
variable tColumnNames when the error occurs, does ANYONE have any idea 
what tColumnNames might contain that could produce the error(s) show below?


Technical information:
Property: value is not a number: (Line 11, column 1)
Object: can't set object property: (Line 11, column 5)
set: can't set property: (Line 11, column 1)
Handler: error in statement: LayoutControl (Line 11, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDefaultHeaderButtonBehavior"
-
repeat: error in statement: (Line 5066, column 1)
Handler: error in statement: _table.ResizeHeaders (Line 5052, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
Handler: error in statement: _table.ResizeColumns (Line 4967, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
Handler: error in statement: _table.CreateColumns (Line 4737, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
Handler: error in statement: _table.RegenerateColumns (Line 4538, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
switch: error in statement: (Line 6150, column 1)
Handler: error in statement: dgProps (Line 5553, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
set: can't set property: (Line 5529, column 1)
Handler: error in statement: dgProp (Line 5529, column 1)
Object ID: stack "RevDataGridLibraryBehaviorsDataGridButtonBehavior"
-
set: can't set property: (Line 139, column 1)
if-then: error in statement: (Line 139, column 1)
Handler: error in statement: populateMe (Line 138, column 1)
Object: group "Table" of card "FrequencyReport" of stack "FreqReport.rwtl"
Object ID: group id 1162 of card id 1002 of stack 
"/Applications/HyperRESEARCH 4.5.4/Components/Tools/FreqReport.rwtl"



___
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: Datagrid internal error

2022-08-10 Thread Trevor DeVore via use-livecode
32,767 is the max for width as well. If there are enough columns it is
possible that the DataGrid is rendering a group that exceeds this limit and
hence the error. The DataGrid works around the limit when rendering rows,
but not when rendering columns.

I suppose a quick test would be to create a DataGrid with 330 columns that
are at least 100 pixels wide and see if you get the same error.

-- 
Trevor DeVore
ScreenSteps

On Mon, Aug 8, 2022 at 12:36 PM Ralph DiMola via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Paul,
>
> The max height of a field is 32,767 pixels. This can be hard to quantify
> especially on mobile with the cornucopia of screen resolutions. I would
> imagine that this limit also applies to groups as well. I got bit on this
> when the app worked in the IDE but failed on some devices.
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdim...@evergreeninfo.net
>
>
> -Original Message-
> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On
> Behalf
> Of Paul Dupuis via use-livecode
> Sent: Monday, August 08, 2022 12:39 PM
> To: use-livecode@lists.runrev.com
> Cc: Paul Dupuis
> Subject: Re: Datagrid internal error
>
> On 8/8/2022 12:26 PM, Paul Dupuis via use-livecode wrote:
> > A customer encountered the following execution error (below) in our
> > app (built on Livecode 9.6.7, MacOS 12.5). This error is occurring in
> > the scrips for the Datagrid itself, rather than our code. At the end,
> > it is one of our handler, "populateMe", where line 139 is where the
> > error starts.
> > Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to
> > tColumnNames
> >
>
> For example, some information from the customer suggest they are working
> with a VERY large dataset, so the length of the list in TColumnNames could
> be quit long - perhaps hundreds of lines. Is there a practical limit on the
> number of columns a Datagrid can be set to?
>
>
> ___
> 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: Datagrid internal error

2022-08-10 Thread Craig Newman via use-livecode
Paul.

All I saw was this:

"I believe there is a property you set, after which you programmatically 
control the population of the datagrid. I am in a hurry so I can't look it up 
right now, but it is in the datagrid API in livecode lessons. 

Which is why I mentioned that the bulk of the thread must not have come to me.

Craig
___
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: Datagrid internal error

2022-08-10 Thread Bob Sneidar via use-livecode
Well the question came up if there was some limit on the number of records, and 
controlling the population of the datagrid would solve that. As far as the 
number of columns, I suspect there may be a limit on the number of *displayed* 
columns, and probably an issue with what characters are allowed for column 
names. Those things I am unsure of. 

Is it necessary to display *all* the data in the array, or can you use the 
datagrid as a sort of index to an array that is in memory, only populating the 
columns you need? 

The datagrid library is not protected, so if your app in the IDE throws an 
error and drops you into the datagrid library script in the debugger (mine 
does), then you can poke around in the debugger to see where things are going 
awry. 

Bob S


> On Aug 10, 2022, at 13:27 , Paul Dupuis via use-livecode 
>  wrote:
> 
> I'm sorry, I don;t see what setting the dgData or dgText or dgNuberofRecords 
> has to do with my original post - I get an internal Datagird script error 
> when setting the names of the columns (see original post)


___
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: Datagrid internal error

2022-08-10 Thread Paul Dupuis via use-livecode
I'm sorry, I don;t see what setting the dgData or dgText or 
dgNuberofRecords has to do with my original post - I get an internal 
Datagird script error when setting the names of the columns (see 
original post)


On 8/10/2022 11:11 AM, Bob Sneidar via use-livecode wrote:

I was referring to dgNumberOfRecords

• get the dgNumberOfRecords
• set the dgNumberOfRecords of group "DataGrid" to 20
• Getting the dgNumberOfRecords is the same as getting the 
dgNumberOfLines. Setting the dgNumberOfRecords has a special significance 
however. If you set the dgNumberOfRecords then you are telling the data grid 
that you know how many total records there are and you are going to supply the 
data for each record on an as-needed basis. This is useful when you have data 
in a database cursor that you would like to feed into the data grid.
After setting this property the data grid will send the GetDataForLine message 
to the data grid whenever it needs to display data for a particular line. You 
can define this command in the data grid script or elsewhere in the hierarchy. 
The definition is as follows:

command GetDataForLine pLine, @pDataA
   
end GetDataForLine


You should fill pDataA with the appropriate data based on the line of data 
being requested. pDataA should not have a numeric index. It is the array that 
would be assigned to one of the numeric indexes if you were assigning the 
dgData property.

Bob S



On Aug 10, 2022, at 06:51 , Craig Newman via use-livecode 
 wrote:

This seems like a fragment of a longer thread, but the “dgText” and the 
“dgData” are the two methods I use to extract, process and reload the content 
of a data grid.

Craig


On Aug 9, 2022, at 11:09 AM, Bob Sneidar via use-livecode 
 wrote:

I believe there is a property you set, after which you programmatically control 
the population of the datagrid. I am in a hurry so I can't look it up right 
now, but it is in the datagrid API in livecode lessons.

Bob S



On Aug 9, 2022, at 05:09 , Paul Dupuis via use-livecode 
 wrote:

I can only image that the customer entered a name with some characters that 
Datagrid has a problem with as a column name OR that the shear number of 
columns (as the customer is working with a very large dataset) exceeds some 
practical Datagrid limit, but what would that be?


___
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: Datagrid internal error

2022-08-10 Thread Bob Sneidar via use-livecode
I was referring to dgNumberOfRecords

• get the dgNumberOfRecords
• set the dgNumberOfRecords of group "DataGrid" to 20
• Getting the dgNumberOfRecords is the same as getting the 
dgNumberOfLines. Setting the dgNumberOfRecords has a special significance 
however. If you set the dgNumberOfRecords then you are telling the data grid 
that you know how many total records there are and you are going to supply the 
data for each record on an as-needed basis. This is useful when you have data 
in a database cursor that you would like to feed into the data grid.
After setting this property the data grid will send the GetDataForLine message 
to the data grid whenever it needs to display data for a particular line. You 
can define this command in the data grid script or elsewhere in the hierarchy. 
The definition is as follows:

command GetDataForLine pLine, @pDataA
  
end GetDataForLine

You should fill pDataA with the appropriate data based on the line of data 
being requested. pDataA should not have a numeric index. It is the array that 
would be assigned to one of the numeric indexes if you were assigning the 
dgData property.

Bob S


> On Aug 10, 2022, at 06:51 , Craig Newman via use-livecode 
>  wrote:
> 
> This seems like a fragment of a longer thread, but the “dgText” and the 
> “dgData” are the two methods I use to extract, process and reload the content 
> of a data grid.
> 
> Craig
> 
>> On Aug 9, 2022, at 11:09 AM, Bob Sneidar via use-livecode 
>>  wrote:
>> 
>> I believe there is a property you set, after which you programmatically 
>> control the population of the datagrid. I am in a hurry so I can't look it 
>> up right now, but it is in the datagrid API in livecode lessons. 
>> 
>> Bob S
>> 
>> 
>>> On Aug 9, 2022, at 05:09 , Paul Dupuis via use-livecode 
>>>  wrote:
>>> 
>>> I can only image that the customer entered a name with some characters that 
>>> Datagrid has a problem with as a column name OR that the shear number of 
>>> columns (as the customer is working with a very large dataset) exceeds some 
>>> practical Datagrid limit, but what would that be?
>> 
>> 
>> ___
>> 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: Datagrid internal error

2022-08-10 Thread Craig Newman via use-livecode
This seems like a fragment of a longer thread, but the “dgText” and the 
“dgData” are the two methods I use to extract, process and reload the content 
of a data grid.

Craig

> On Aug 9, 2022, at 11:09 AM, Bob Sneidar via use-livecode 
>  wrote:
> 
> I believe there is a property you set, after which you programmatically 
> control the population of the datagrid. I am in a hurry so I can't look it up 
> right now, but it is in the datagrid API in livecode lessons. 
> 
> Bob S
> 
> 
>> On Aug 9, 2022, at 05:09 , Paul Dupuis via use-livecode 
>>  wrote:
>> 
>> I can only image that the customer entered a name with some characters that 
>> Datagrid has a problem with as a column name OR that the shear number of 
>> columns (as the customer is working with a very large dataset) exceeds some 
>> practical Datagrid limit, but what would that be?
> 
> 
> ___
> 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: Datagrid internal error

2022-08-09 Thread Bob Sneidar via use-livecode
I believe there is a property you set, after which you programmatically control 
the population of the datagrid. I am in a hurry so I can't look it up right 
now, but it is in the datagrid API in livecode lessons. 

Bob S


> On Aug 9, 2022, at 05:09 , Paul Dupuis via use-livecode 
>  wrote:
> 
> I can only image that the customer entered a name with some characters that 
> Datagrid has a problem with as a column name OR that the shear number of 
> columns (as the customer is working with a very large dataset) exceeds some 
> practical Datagrid limit, but what would that be?


___
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: Datagrid internal error

2022-08-09 Thread Paul Dupuis via use-livecode
comma delimited or cr delimited, without looking it up, I am sure it is 
in the right format since it work 99.99% of the time.


The names that would be in the column list all go through a name check 
function. That function prevents names that are all spaces, longer than 
255 characters, or are a handful of "reserved words" and checks that 
each name does not contain the following characters


    if (it < 32)  then return false -- all control characters (0x 
to 0x0031)
    if (it = 34)  then return false -- "    quote (0x0034) 
-- LC string encapsulator
    if (it = 40)  then return false -- ( left parenthesis (0x0040) 
-- used in filter and theory criteria
    if (it = 41)  then return false -- )    right parenthesis (0x0041) 
-- used in filter and theory criteria
    if (it = 44)  then return false -- ,    comma (0x0044) 
-- LC item delimiter
    if (it = 60)  then return false -- <   less than sign (0x0060) 
-- htmlText tag delimiter
    if (it = 62)  then return false -- >    greater than sign (0x0062) 
-- htmlText tag delimiter
    if (it = 91)  then return false -- [  left square bracket (0x0091) 
-- LC merge delimiter
    if (it = 92)  then return false -- \    backslash (0x0092) 
-- regex string escape character
    if (it = 93)  then return false -- ] right square bracket (0x0093) 
-- LC merge delimiter
    if (it = 124) then return false -- | vertical bar (0x0124) 
-- used in code

    if (it = 127) then return false -- DEL delete (0x0127)

So, comma's are excluded, as are [ and ], and control characters, etc.. 
However all Unicode characters, codepoints 128 and up are allowed. 
Testing shows you can have a Datagrid where you can set the columns to 
empty, so that is not the cause of the error.


I can only image that the customer entered a name with some characters 
that Datagrid has a problem with as a column name OR that the shear 
number of columns (as the customer is working with a very large dataset) 
exceeds some practical Datagrid limit, but what would that be?


I don't really want to have to carve out time to build test stacks to 
try names with every possible characters or ever increasing numbers of 
column names until the error occurs or those possibilities are ruled 
out. I was hoping there might be someone on the list who was familiar 
enough with the internals of the Datagrid to have some idea what might 
have caused the error.


Unfortunately, the customer's data is confidential, so they do not want 
to provide the data to us to use for testing. And the customer is either 
not technically savvy or does not have time (they have said they are 
under a deadline) to help much in troubleshooting. They can get the 
analysis this Datagrid provides by exporting some data to Excel and 
doing the analysis in Excel, so the error is not a show-stopper for them 
as well. Definitely not as convenient as the report in our app, but a 
viable work-around.


See my original post for the executionContexts and the specific error.


On 8/8/2022 7:56 PM, Bob Sneidar via use-livecode wrote:

Nope I take that back it's lines. I remember now wondering why that was.

Bob S



On Aug 8, 2022, at 16:53 , Bob Sneidar  wrote:

I believe dgProp ["columns"] is a comma delimited list.

Bob S



On Aug 8, 2022, at 09:26 , Paul Dupuis via use-livecode 
 wrote:

A customer encountered the following execution error (below) in our app (built on 
Livecode 9.6.7, MacOS 12.5). This error is occurring in the scrips for the Datagrid 
itself, rather than our code. At the end, it is one of our handler, 
"populateMe", where line 139 is where the error starts.
Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to tColumnNames


___
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: Datagrid internal error

2022-08-08 Thread Bob Sneidar via use-livecode
Nope I take that back it's lines. I remember now wondering why that was. 

Bob S


> On Aug 8, 2022, at 16:53 , Bob Sneidar  wrote:
> 
> I believe dgProp ["columns"] is a comma delimited list. 
> 
> Bob S
> 
> 
>> On Aug 8, 2022, at 09:26 , Paul Dupuis via use-livecode 
>>  wrote:
>> 
>> A customer encountered the following execution error (below) in our app 
>> (built on Livecode 9.6.7, MacOS 12.5). This error is occurring in the scrips 
>> for the Datagrid itself, rather than our code. At the end, it is one of our 
>> handler, "populateMe", where line 139 is where the error starts.
>> Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to 
>> tColumnNames
> 


___
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: Datagrid internal error

2022-08-08 Thread Bob Sneidar via use-livecode
I believe dgProp ["columns"] is a comma delimited list. 

Bob S


> On Aug 8, 2022, at 09:26 , Paul Dupuis via use-livecode 
>  wrote:
> 
> A customer encountered the following execution error (below) in our app 
> (built on Livecode 9.6.7, MacOS 12.5). This error is occurring in the scrips 
> for the Datagrid itself, rather than our code. At the end, it is one of our 
> handler, "populateMe", where line 139 is where the error starts.
> Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to 
> tColumnNames


___
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: Datagrid internal error

2022-08-08 Thread Ralph DiMola via use-livecode
Paul,

The max height of a field is 32,767 pixels. This can be hard to quantify
especially on mobile with the cornucopia of screen resolutions. I would
imagine that this limit also applies to groups as well. I got bit on this
when the app worked in the IDE but failed on some devices.

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net


-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Paul Dupuis via use-livecode
Sent: Monday, August 08, 2022 12:39 PM
To: use-livecode@lists.runrev.com
Cc: Paul Dupuis
Subject: Re: Datagrid internal error

On 8/8/2022 12:26 PM, Paul Dupuis via use-livecode wrote:
> A customer encountered the following execution error (below) in our 
> app (built on Livecode 9.6.7, MacOS 12.5). This error is occurring in 
> the scrips for the Datagrid itself, rather than our code. At the end, 
> it is one of our handler, "populateMe", where line 139 is where the 
> error starts.
> Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to 
> tColumnNames
>

For example, some information from the customer suggest they are working
with a VERY large dataset, so the length of the list in TColumnNames could
be quit long - perhaps hundreds of lines. Is there a practical limit on the
number of columns a Datagrid can be set to?


___
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: Datagrid internal error

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

On 8/8/2022 12:26 PM, Paul Dupuis via use-livecode wrote:
A customer encountered the following execution error (below) in our 
app (built on Livecode 9.6.7, MacOS 12.5). This error is occurring in 
the scrips for the Datagrid itself, rather than our code. At the end, 
it is one of our handler, "populateMe", where line 139 is where the 
error starts.
Line 139 set the dgProp["columns"] of grp "rwMatrixObj_DataGrid" to 
tColumnNames




For example, some information from the customer suggest they are working 
with a VERY large dataset, so the length of the list in TColumnNames 
could be quit long - perhaps hundreds of lines. Is there a practical 
limit on the number of columns a Datagrid can be set to?



___
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