Subform & hash cookies

Questions related to customising nuBuilder Forte with Javascript or PHP.

Subform & hash cookies

Postby Janusz » Sun Sep 08, 2019 5:46 am

Steven,
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.
Janusz
 
Posts: 260
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Subform & hash cookies

Postby kev1n » Mon Sep 09, 2019 12:27 am

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++) {
  nuAddRow('accform')
}
kev1n
 
Posts: 365
Joined: Mon Oct 15, 2018 2:13 am

Re: Subform & hash cookies

Postby admin » Mon Sep 09, 2019 10:37 am

Guys,

I believe this is fixed now on Sourceforge... https://sourceforge.net/projects/nubuilder/

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.


Steven
admin
Site Admin
 
Posts: 3162
Joined: Mon Jun 15, 2009 9:53 am

Re: Subform & hash cookies

Postby Janusz » Wed Sep 11, 2019 3:23 pm

Steven,
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.
Janusz
 
Posts: 260
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Subform & hash cookies

Postby kev1n » Wed Sep 11, 2019 3:39 pm

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"

https://streamable.com/zuutd
kev1n
 
Posts: 365
Joined: Mon Oct 15, 2018 2:13 am

Re: Subform & hash cookies

Postby Janusz » Wed Sep 11, 2019 6:28 pm

Hi,
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
Janusz
 
Posts: 260
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Subform & hash cookies

Postby Janusz » Sat Sep 14, 2019 4:10 am

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)
Janusz
 
Posts: 260
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Subform & hash cookies

Postby Jannie » Thu Sep 26, 2019 1:05 am

Thank you! I had the same problem.
Jannie
 
Posts: 3
Joined: Sun Jun 10, 2018 12:06 am

Re: Subform & hash cookies

Postby admin » Fri Sep 27, 2019 7:50 am

People,

Are you still having problems?

The max_input_vars problem should be fixed.

Steven
admin
Site Admin
 
Posts: 3162
Joined: Mon Jun 15, 2009 9:53 am

Re: Subform & hash cookies

Postby Jannie » Tue Oct 22, 2019 3:29 am

admin wrote:People,

Are you still having problems?

The max_input_vars problem should be fixed.

Steven


No, after changing max_input_vars it's OK.
Jannie
 
Posts: 3
Joined: Sun Jun 10, 2018 12:06 am


Return to Custom Code