Skip to Content
0

MDOQuery type Delete with datetime filter

Feb 21 at 06:11 PM

37

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 15.1.2.12, DB Oracle 12c, Open SQL 7.10

Regards,

Petr

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

1 Answer

Best Answer
Abhijeet Naste Apr 09 at 03:59 PM
0

In the SQL query go to parameters tab. then tick the the use Typed Parameters. Then set the one of the parameter as type "TimeStamp" then use that parameter in the where clause for dates.


Regards,

Abhijeet

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Abhijeet, thanks! I've forgot about this option on Parameters tab. It was enabled in another MDOQuery, but it was off in this one.

Regards,

Petr

1