We've implemented devart's solution for declaring SPs for CUD operations (adding a dummy column that will handle the cursor return value of SPs), and we've encountered a problem using except keywords.
When we have an entity with the dummy field, the generated SQL contains a null blob value. When we use an esql statement that uses except, such as :
select value X from entity as X
except
select value T from entity as T where ...
The generated sql is constructed of 2 sql statements with a "Minus" operator, and the sql throws the following error:
"inconsistent datatypes: expected - got BLOB".
We know by now that the problem is having the Blob columns, the question is whether a solution exists for this problem?
Thank in advance,
Ido Flatow.
using cursor solution for SPs and ESQL's except keyword
-
- Posts: 8
- Joined: Tue 21 Apr 2009 07:50
Please refer to the new tutorial here:
http://www.devart.com/blogs/dotconnect/?p=5
http://www.devart.com/blogs/dotconnect/?p=5