SQL Field greys out after it is initially populated with data

I am doing some development with the NCR counterpoint POS system.  I have the SA password and have access to the SQL database and tables.

My question is:  on the main form, a cost field initially allows for null values.  So, there can be no data entered in the field, and the record can be saved.  However, after this field becomes populated and the record is saved , the field greys out, and becomes uneditable on that form.  If a user makes a mistake and wants to correct it, or if the user wants to update the field he/she has to go thru a cumbersome process into the "purchasing" portion of the program, create a false PO, and also "receive" the item in the system to update the cost.  

I realize this is the way the software is designed to work, however, I am currently  in the setup process of this system, so I was wondering if I could make that field not grey out after it has initially been populated with data.  After the data is populated, I will switch back the field before the system goes live.  This would be extremely helpfull with the setup process.
tike55Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
if it's not null, then can you could change it afterwords?

if so a Quick fix might be redesigning a table to use '' (single ' and no space and a ' again) instead of null. I e defaults ''   instead of defaults null.

BUT this might have serious implications on your queryplans, indexes and so forth. So this is NOT a fix to be thrown into production, rather on a test Environment, and then you can ask the vendor if they can support such a change.

regards Marten
0
 
DcpKingConnect With a Mentor Commented:
If the "system" is NCR POS system, and this is the way it's supposed to work, you'll have to talk to NCR.

You could always consider populating data directly into SQL Server and not through the POS terminal, but then you'll also need to be sure that you're not misleading the NCR software in any way.
0
 
hnasrConnect With a Mentor Commented:
In POS software, the field can be edited through a super user.
This process is a weakness in the software and should be communicated with the supplier to implement in future releases.
Remember the higher release numbers of available software. Every release they used to say great, easier simpler. Their skills simply could not manage it earlier. Also customer ideas ignite developers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.