Deleting Rows when TableView Filter is true

    Deleting Rows when TableView Filter is true

    I want to delete a row from my Normalized TableTransform. Now I can throw a filter on a cell with a TableView, but this clears only the cell. But when the filter is true than is has to delete the whole row (and containing rows on the primary key)

    Example:

    Art number Store Type Value
    1 001 wheel 100
    1 001 muffler 20
    1 001 engine

    Engine is empty.....now it has to delete all the rows in TableTransform with Art number 1 and Store 001

    Looks like I have to do it with my Select Query in Extracts. But then I cannot filter if two elements are empty...

    Example:
    Art number Store Type Value
    1 001 wheel 100
    1 001 muffler 20
    1 001 engine


    2 001 wheel 100
    2 001 muffler
    2 001 engine 300


    Here is muffler empty

    SELECT * FROM "Source" WHERE "muffler"<>'' OR "engine"<>''

    Then I want both rows to dissapear, but only one goes...

    Post was edited 1 time, last by “BMWTouring” ().