Joint in Filter

[RootGrapefruit]

Hi,
I want to make a Filter that Looks something like this:
dw_1.SetFilter("cunr IN (SELECT cunr FROM customers WHERE cuAttr = 'test')")
I always get an "Expression ist not valid" Exception.
What am I doing wrong?
Thanks

 

[mbalent]

Filters are not sent to the database, they are applied by the datawindow engine after the data is retrieved.

Regards,

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com