logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: FirebirdMemberShipProvider bug: msg#00204

Subject: Re: FirebirdMemberShipProvider bug
Hello:
I've found the bug in %subj%. There's a sample implementation and there's a sample DDL for table creation. But there are some fields (in DDL) with boolean data type, which is not in FB.

Well, and because the GetBoolean method is implemented like (in DbValue.cs if I'm right)

return Convert.ToBoolean(this.value, CultureInfo.InvariantCulture);

it can be useful to add the domain definition to the DDL. And because Convert.ToBoolean is true when int as param is 1, the 0/1 smallint domain in suitable. :)

What do you think?

Sure.

CREATE DOMAIN BOOLEAN AS
SMALLINT
NOT NULL
CHECK (value = 1 or value = 0)

or

CREATE DOMAIN BOOLEAN AS
SMALLINT



What will be better ?? ;)


--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642


<Prev in Thread] Current Thread [Next in Thread>