Page 1 of 1

Subform & hash cookies

PostPosted: Sun Sep 08, 2019 5:46 am
by Janusz
I was testing an application with subform with higher number of data and observed some unstable behaviour:
(I have procedure to add data to the subform table so it was quite easy to check with any number of records)

My subform is composed of one Lookup and few display fields (per row).
1. Up to about 50 records in the subform everything works OK

starting with 50 or 60 records in the subform I observe the following:
2. Reading values directly from the edit main form objects with # cookies are not working anymore, when I used the nuSetProperty to transfer object data to php procedure it was ok.
3. Subform checkboxes are not removing lines after saving (you can check, but after save the line is not removed)
4. You can not add manually new records to the subform
5. when the subform has above 1000 records it is not displaying data (records are availabe when checking by phpmyadmin)

Normally in typical application I will be in the safe zone - belowe 50 records - but maybe during the next release you could have a look on it.

Re: Subform & hash cookies

PostPosted: Mon Sep 09, 2019 12:27 am
by kev1n
I'm not even able to add 10 rows in a row. The page then hangs up and turns completely blank after some time. Test done with Access Level - Forms subform:

Code: Select all
for (var i = 0; i < 10; i++) {

Re: Subform & hash cookies

PostPosted: Mon Sep 09, 2019 10:37 am
by admin

I believe this is fixed now on Sourceforge...

Still, don't try it with a Subform of over 999 records though.

You should be able to have ten Subforms with under 1000 in each on a Form but if you click Save on something like this, you've probably got time to go and get a coffee.


Re: Subform & hash cookies

PostPosted: Wed Sep 11, 2019 3:23 pm
by Janusz
Just for info. With the lates version I have the same situation. To the subform I can add max 58 records (in the standard way)
Above that number the delete and adding option is not working in my case.

Re: Subform & hash cookies

PostPosted: Wed Sep 11, 2019 3:39 pm
by kev1n
Janusz: How are you able to add multiple rows at the same time?
There's always just one row added when calling nuAddRow('accform') multiple times.

Does it work for you?

Access Levels -> Subform "Forms"

Re: Subform & hash cookies

PostPosted: Wed Sep 11, 2019 6:28 pm
by Janusz
Besides standard way to add or remove records to the subform I use "drag and drop" to add files to the subform with the drop box outside the subform (on the main form).
Files are stored on the server and links to files are added with php directly to the mysql subform table so after (auto) refresh I have all (multiple) records added to the subform.

Working directly with php I can add or remove any number of records
(above 1000 records there is a problem with display - but it's not real issue - it was just for my curiousity to check the limit - normally max 100 is sufficient for me).
But with standard way of adding the records one by one at c.a. 58 records you can not add anymore additional records or delete records with the checkboxes

Re: Subform & hash cookies

PostPosted: Sat Sep 14, 2019 4:10 am
by Janusz
the problem with limited number of rows in the subform was solved by increasing in the php.ini the following variable:
max_input_vars 2000 (default is 1000)