MDOQuery type Delete with datetime filter

[former_member415443]

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

[abhinaste · Accepted solution]

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

[former_member415443 · Accepted solution]

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