On our MSSQL 2000 database we have many computed columns that are then indexed in our schema. A classic example is alter table tableprefix_user add full_name AS (COALESCE(first_name, '') + ' ' + COALESCE(last_name,''))
Since a computed column cannot explicitly allow null reactor records it determines that there is a validation error. The only work-around for this seems to be to override the method for that column and simply return the validationRecord without triggering any method calls to check for errors. This is fine but we specifically try not to include any custom methods in reactor generated code due to the problems it poses in an SVN development environment. Is there another work-around or could this be considered a bug? Thanks, Roy -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
