[nhusers] Re: Exception with BinaryBlob and SQLCompactEdition

2016-10-13 Thread Ricardo Peres
This property seems to be using optimistic concurrency.

RP


On Thursday, October 13, 2016 at 3:08:31 PM UTC+1, Dehlinger Hervé wrote:
>
> Hi
>
> I have a problem with one fields of type BinaryBlob (Database type: 
> SQLCompactEdition.)
>
> The exception:
>
> The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, 
> or IN clauses, except when these data types are used with the LIKE or IS NULL 
> predicates.
>
> When i want to update the record i see this query:
>
> UPDATE User SET EncryptedPassword = @p0 WHERE UserID = @p1 AND 
> EncryptedPassword = @p2
>
> But i don t need the second where condition.
>
> What can i do ?
>
> Thank you
>
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nhusers+unsubscr...@googlegroups.com.
To post to this group, send email to nhusers@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.


[nhusers] Exception with BinaryBlob and SQLCompactEdition

2016-10-13 Thread Dehlinger Hervé
Hi

I have a problem with one fields of type BinaryBlob (Database type: 
SQLCompactEdition.)

The exception:

The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, 
or IN clauses, except when these data types are used with the LIKE or IS NULL 
predicates.

When i want to update the record i see this query:

UPDATE User SET EncryptedPassword = @p0 WHERE UserID = @p1 AND 
EncryptedPassword = @p2

But i don t need the second where condition.

What can i do ?

Thank you



-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nhusers+unsubscr...@googlegroups.com.
To post to this group, send email to nhusers@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.