Source language: Translate to:

Protecting field from accidental change

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Protecting field from accidental change

Postby BRobinsonS » Mon Jan 09, 2017 6:42 pm

I have a membership database application with MemNo (member number) field string(12).
The Only Text Entry Field is Disabled (not Enabled) which uses MemNo of database field.
In theory the only way to changed the MemNo value is through a routine which I developed to Change from a Temporary member number to permanent member number.
Which updates the dues payment table as well.

However, every once and a while I see the MemNo value is blank or altered from what it should be.
Somehow the MemNo value is changed accidentally when entering another value for different field possibly on another screen.

Is there a way to test that the MemNo field is being altered and alert the user that this is happening?
Other displays of the MemNo is in a simple text label.
Doesn't happen all the time but once in a while.

Thoughts? Solutions?
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 323
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Protecting field from accidental change

Postby virger » Tue Jan 10, 2017 8:17 am

Try yjis:
Code: Select all
dbpSetFieldProperties "Base" "Table" "Field" "ReadOnly=Yes"


dbpSetFieldProperties "Base" "Table" "Field" "ReadOnly=Yes"
COSTA RICA
PURA VIDA
User avatar
virger
 
Posts: 418
Joined: Mon Sep 18, 2006 12:21 pm
Location: Costa Rica, America Central

Re: Protecting field from accidental change

Postby BRobinsonS » Tue Jan 10, 2017 8:37 am

ReadOnly seems to refer to Grid. Would it apply to a Text Field too?

Also, to make a change from Temp MemNo to Permanent MemNo, would I have to use dbpSetFieldProperties "Base" "Table" "Field" "ReadOnly=No"
Then back to dbpSetFieldProperties "Base" "Table" "Field" "ReadOnly=Yes" after the edit?
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 323
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest