Skip to Content

MDOQuery type Delete with datetime filter

Feb 21 at 06:11 PM


avatar image

Hi, experts!

I created MDOQuery of mode "Delete" with Filter Expression like

[Field1] BETWEEN [Param.1] AND [Param.2]

It causes error

This kind of expression works fine for "Select" mode and I guess it's because of corresponding values "Timestamp" in Parameter Type column in Parameters section. But there is no such column in "Delete" mode. So, the question is how to construct dynamic filter expretion to delete records from MDO applying datetime filter?

MII, DB Oracle 12c, Open SQL 7.10



oym0b.png (8.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers