Solved

SQL Field greys out after it is initially populated with data

Posted on 2013-11-06
3
445 Views
Last Modified: 2013-11-08
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.
0
Comment
Question by:tike55
3 Comments
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 167 total points
Comment Utility
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
 
LVL 30

Assisted Solution

by:hnasr
hnasr earned 166 total points
Comment Utility
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
 
LVL 20

Accepted Solution

by:
Marten Rune earned 167 total points
Comment Utility
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

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now