Simple question, likely to have a simple answer.
I have tables in SQLite using GUID primary key columns. I am attempting to
select a row based on its literal guid value in C#.Net.
Here's a sample query:
SELECT Role.Id, Role.Name, Role.Description, Role.Active, Role.BitMask
FROM UserRole INNER JOIN
Role ON UserRole.RoleId = Role.Id
WHERE (UserRole.UserId = '{29831334-a434-4c06-a297-b58889f4d3c6}')
I know the literal GUID value shown is correct, as I copied it directly from
the results pane when I do a SELECT * FROM UserRole, however, as soon as I add
the WHERE clause, I get no results.
I know there is an option to set BinaryGuid=True/False, at the connection
level, and I have done this both ways with the same results.
Is there some other way to declare the literal guid value so that it will
match? (I have tried without the { } pair as well, BTW).
Thanks!
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
