zzzzsys_setup.set_denied set to 1 on Update

[apmuthu]

1. When a fresh install is done and a couple o tables are added and their forms created, logout, and a sql backup of the DB is done.
2. Then login in afresh and navigate to Setup => Builder => Update. Logout and a fresh sql backup of the DB is done.

When we compare the two backups, we find that the field zzzzsys_setup.set_denied is set from 0 to 1.

What does this connote and when does it get reset to 0 if at all?

Also, on a fresh login, the cursor does not blink in the Username field though the focus is there and entry can be done.

[kev1n]

Hi,

zzzzsys_setup.set_denied should probably be set to 1 initially.

If it is set to 0,

You can access all the Form Properties and code used behind the system Forms like the Objects Form.

Source:

https://forums.nubuilder.cloud/viewtopic. ... 171#p15140

[kev1n]

Also, on a fresh login, the cursor does not blink in the Username field though the focus is there and entry can be done.

I don't see this behaviour here (tested with chrome, firefox, edge)

[apmuthu]

The login behaviour is not visible in FireFox ESR 52.9 - tested on XP sP3. However, it is present in Basilisk of the same FF build.

[kev1n]

I downloaded this build, run basilisk.exe and opened nuBuilder. I don't see a focus issue either.
https://o.rthost.win/basilisk/basilisk5 ... 7-xpmod.7z

[apmuthu]

I used the 32bit version on WinXP SP3 and it does not work.
https://o.rthost.win/basilisk/basilisk5 ... 7-xpmod.7z

[apmuthu]

Any mod to set the "set_denied" to 1 from the GUI? A nice feature indeed instead of tinkering with the DB Client each time.

[kev1n]

You could create a (PHP) Procedure to do that.

[kev1n]

Like this:
(or even specify a Launch from Form where you can set it to either 0 or 1)

[apmuthu]

It would be nice to read the current status and have a button to state it and on clicking to change the button to toggled status:

Code: Select all

read set_denied
show denied status on button
on clicking it, toggle status and display it.
This button can be on the setup tab itself

Also we can make this code as part of the main nubuilder4.sql itself.