Hi all
FB2.1 and FB.Net provider 2.5.
I'm porting a web app to win app and I found a difference between readable
id of user from membership and readable id of user from users table.
I have this code:
Variables.UserId =
Membership.GetUser(Variables.UserName).ProviderUserKey.ToString();
That return this code: d1f5d194-5fa8-4ba1-bcf5-a4a788b58c1a.
This "id" is used for further query's.
If i try any query like :
SELECT BROKER, COMMODITY
FROM ORDERS
WHERE (IDTRADER) = @IDTRADER)
Is not working !!!!
The following query is working with correct values:
SELECT BROKER, COMMODITY
FROM ORDERS
WHERE (uuid_to_char(IDTRADER) = @IDTRADER)
But from database if I run:
select uuid_to_char(pkid),username from users
this "id" return D194D1F5-5FA8-4BA1-F5BC-A7A4B5881A8C
this is different string .and is for same user :
String from Membership: d1f5d194-5fa8-4ba1-bcf5-a4a788b58c1a
String from database: D194D1F5-5FA8-4BA1-F5BC-A7A4B5881A8C
This is a bug ????
Regards,
Paul
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
