Null and concat (Solved)

[Ivan Smahin]

Hello Bart,

Friday, October 5, 2007, 9:19:05 PM, you wrote:

> Now it accepts both procedures and the method field shows <null>.

> OK now this brings the question why did it accept (before it was  
> nullable) the first procedure. Why did it not complain about a null  
> value not being acceptable for the method field?
> I believe the error reporting on this case is not what it should be.  
> The only error that came was when the second procedure created a  
> second record then Valentina complained about duplicate key in method
> unique.

> The only answer I see is that the result of the concat (which ought  
> to be <null>) was not acceptable to the method and converted somehow  
> to "something" else. Again I think it should have errored out on  
> "null value not acceptable for field x"

Yes it should be exception. We will check and fix it.

> Bart Pietercil
> PS: don't forget on the little error in the WIKI page on concat  
> missing ' in the second example

Fixed. Thanks.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com