Hello, there are a problem with the case sensitive because when you do :
select * from users where username = 'toto' and select * from users where username = 'TOTO' the result is diferent because the column username is case sensitive so you can insert user TOTO and toto but it's not possible because the membershipcollection is case sensitive so when you do GetAllUsers there is a exception "duplicate key". So they are two solutions : 1 - Modify the provider : Add Upper in the select command (i can do) 2 - Modify the struct of the users table for that the select is case insentive (I don't know how to do that) it's possible ? maybe with collate ? I think the second solution is the best but i don't know if it's possible. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
