The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
new field
Posted: 20 May 09 4:32 PM
|
| Added a new currency field to the Account table and that field to the account detail form. Admin can edit it but a user can't. I've changed that to an existing userfield and works ok. Seems to be only with the users. What am I missing? |
|
|
|
Re: new field
Posted: 21 May 09 4:12 AM
|
This is field level security in action - you need to go to tools | manage in Admin and you'll find that this is off (r/o). When you change it - it will work for about a day or so and then come back. If you add a new field to the same table - it will then change *your* field to be r/w and so, you can just add a dummy field to get around it fully.
|
|
|
|
Re: new field
Posted: 22 May 09 1:08 PM
|
thanks that was it. strange problem. is this a bug in Architect?
dave |
|
|
|
Re: new field
Posted: 22 May 09 1:34 PM
|
| It's a long standing issue - that's as much as I know ! |
|
|
|
Re: new field
Posted: 27 May 09 12:04 PM
|
have posted several times on this in several forums....
a dummy table of of account with a field on it will 'reset' the field security blob.....
basically the SECTABLEDEFS FIELDINDEX is either duplicated or skips sequential numbers.... RJ Ledger has a reindexer program that runs in BasicRunner that renumbers FIELDINDEX (and another program that renumbers FIELDOFFSET, which is the secprofiles blob 'key')
So a field got dropped or added outside of SLX and the SECTABLEDEFS didn't get renumbered properly, and SECRIGHTS profiles didn't get rebuilt.....
It's not enough to go into the SecRights profiles and change them from RW to RO....you MUST add a field/ table and field.....and/or renumber sectabledefs.fieldindex.
PERIOD. and your mileage will not vary.
Upgrading from 6.10 to 7.22 this was a challenge, but has now been 'fixed'.
|
|
|
|
Re: new field
Posted: 27 May 09 12:04 PM
|
have posted several times on this in several forums....
a dummy table of of account with a field on it will 'reset' the field security blob.....
basically the SECTABLEDEFS FIELDINDEX is either duplicated or skips sequential numbers.... RJ Ledger has a reindexer program that runs in BasicRunner that renumbers FIELDINDEX (and another program that renumbers FIELDOFFSET, which is the secprofiles blob 'key')
So a field got dropped or added outside of SLX and the SECTABLEDEFS didn't get renumbered properly, and SECRIGHTS profiles didn't get rebuilt.....
It's not enough to go into the SecRights profiles and change them from RW to RO....you MUST add a field/ table and field.....and/or renumber sectabledefs.fieldindex.
PERIOD. and your mileage will not vary.
Upgrading from 6.10 to 7.22 this was a challenge, but has now been 'fixed'.
|
|
|
|