User can change dates in Locked table view

Classic Servoy
1

I was under the impression that a table view - locked did not allow any changes to the underlying database. If the user clicks on part of a DATE field (M, D or Year) then uses the UP or DOWN arrows the date will change and the change is stored in the DB. What am I doing wrong?

bruce

2

Hi Bruce,

You can still interact with the data unless you change the properties of the fields in design mode to not be editable.

Table view is just a list view with a few added bells and whistles - you still have to protect your fields !!

Cheers
Harry

3

blomasky:
I was under the impression that a table view - locked

‘Locked’ means that the user can’t change form view to record or list view using the menu items, it doesn’t mean that the user can’t modify fileds content.

4

Thanks, now I understand.

any fast way in the onShow to make SURE all fields are READONLY? (I just KNOW I will place a field and forget to turn off the EDITABLE flag

thanks
bruce

5

Providing you have named your fields can use the ‘enabled’ function to show fields but not allow Users to click into them.

elements.elementName.enabled = false/true

From F1/Help

A disabled element cannot be selected by clicking the form

REgards

Graham Greensall
Worxinfo Ltd

6

Quicker way is to consider using form controller property of ‘readonly’ as follows:

//gets the editable/read-only state of the form
var currentState = controller.readOnly;

//sets the editable/read-only state of the form
controller.readOnly = ! currentState;

Above method is a toggle which sets and unsets readonly property of a form without having to scroll through by element

This may suit your purpose

Cheers
Harry