Hi Peyton: What is the exact data type of the 'AnyJob' Column? If it isn't already, try altering the table to make the data type of that column a VARCHAR(1).
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peyton Todd Sent: Tuesday, April 22, 2008 9:01 PM To: [email protected] Subject: [ACFUG Discuss] Possible bug in CFGRID? Or in SQL Server? Or just maybe a mistake of my own? The CFGRID I wrote to maintain the 'reporters' table mentioned in my notes of yesterday and today has a wierd problem. It turns out that a one-byte column, 'AnyJob' (= 'Y' if the user allowed to see any job), must have data in it for any updates to the row containing it to be saved by CFGRIDUPDATE. The column is set for NULLS allowed in my MSSQL 2005, so it ought to be okay not to specify a value for it. But I have found that, once I have added a record, if I did not specify a value for the AnyJob column, I cannot add a value to that column later, nor make a change to any other column. There are other null-okay columns in the table, and they do not behave this way. Has anyone ever encountered a problem like this? The present situation greatly diminishes the usefulness of CFGRID. It means, for example, that if any reporter without the privilege to view any job is granted that privilege later, the CFGRID cannot be used to specify that to the system. The only way would be to go into Enterprise Manager and do it there. In fact, that's the only way I was able to confirm this description of the problem: for each record, one a time, I would go into Enterprise Manager and enter a space in the AnyJob column, and for all records to which I have done this, it becomes possible to perform updates via CFGRID from then on. Who knows - when I install my latest work (including the CFGRID) on the clients server, maybe it will turn out that his MSSQL 2000 does not have the same problem. Or maybe (probably) MSSQL 2000 lets one specify a default value, which I can decree to be a space? I'll check, but I want to get this message out right away to see if it rings a bell with anyone... Peyton ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
