Devart Forums

Posted: **Thu 30 Jul 2009 07:29**

Good morning:

At first, sorry for my English

Yesterday I´ve updated Devart DotConnect for Oracle Pro to version 5.25 from 5.20. Before our applications run perfectly, but now we´ve detect a problem with next code that before run well:

Code: Select all

string keyOrder ="it.numAtes DESC";

return cons.Skip(keyOrder, "@skip", new ObjectParameter("skip", pageIndex* pageCount))
                .Take(PageCount).ToList();

In runtime, above code throws an inner expception:

{"ORA-00936: falta una expresión"}

using the function toTraceString() I obtain the sql statment that seems to have problem with "skip" parameter. I don´t understant because now isn´t work. In previous version worked fine.

Thanks

Posted: **Thu 30 Jul 2009 08:26**

Thank you for your inquiry, we have already found and fixed the problem.
The fix will be included in the next build, we plan to release it in a week or so.

Posted: **Thu 30 Jul 2009 08:52**

Thank you for your rapid response. It will wait impatiently for the new version since it is essential for the correct functioning of our applications

Greetings

Devart Forums

Skip() with parameters problem

Skip() with parameters problem