From: Vsevolod (S. I. <si...@cs...> - 2003-12-10 21:38:21
|
Chris, I may have gotten lazy, but here is a feature that could be useful. If a certain field is not set in the object, the SQL statements that are generated to insert or update values do not contain *any* value for that field. Thus, they are syntactically invalid: update table set field1 = value1, field2 = , field3 = value3, ... Obviously, I can work around this in the application code, but it would be really cool if for fields that can be NULL SPOPS would automatically put NULL into the SQL code if the value is not defined. Thanks, Simon -- Simon (Vsevolod ILyushchenko) si...@cs... http://www.simonf.com America's business leaders simply don't want to think about complex technology issues - they want to think about golf. Microsoft promises them that. Andrew Grygus, www.aaxnet.com |