Hi all
I have few propositions about SP for web provider
1. In ROLES_ISUSERINROLE and ROLES_ISEXISTS is :
SELECT first(1) 1 FROM table .... INTO :RES;
I propose to change this to :
IF (EXISTS(SELECT 1 FROM table....)) then RES=1;
2 SQL Statement like :
select first(1) PropertyNames, PropertyValuesString,
PropertyValuesBinary from profiles
where pkid = :userid into
:propertynames,:propertyvaluesstring,:propertyvaluesbinary;
shouldn't have an order by?or should not be into a FOR statement?like
for select PropertyNames, PropertyValuesString,
PropertyValuesBinary...
3. In PROFILES_DELETEPROFILE is this:
if (userid is null) then
userid = :username;
delete from profiles where pkid = :userid;
Why is set the userid to user name???
4.If I configure my membership to allow multiple account with same e-mail, I
could find all users by e-mail with MEMBERSHIP_FINDUSERSBYEMAIL but what
user name I'll get from MEMBERSHIP_GETUSERBYEMAIL ?The first one from table?
5. Shouldn't be used FK for PKID from USERS table?
Best regards,
Paul
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
