Announcement

Collapse
No announcement yet.

Filtering

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Filtering

    When I right-click on a table column (or column header) and select Filter > Filter from the context menu, it would be useful to have the Filter wizard automatically add an item initialized to the Column corresponding to the right-click location (and possibly with the type auto-set to equals).

    Additionally, when using the 'Copy as Insert Statement' with Oracle, the generated insert statement includes the Oracle ROWID Pseudocolumn which I would suggest should not be included as you then have to strip it off to avoid a 'Virtual column not allowed here' exception when running the insert.

    INSERT INTO "A"."ABC" (........ "ROWID") VALUES (...... 'AAASD0AAXAAABJRAAJ');


  • #2
    Hi alanhay,

    Thanks for your suggestion.

    For the filter request, I have forwarded it to our development team. We will keep imrpoving Navicat in future.

    For the Copy As issue, we will try to fix it in the next version. I will contect you if there is any news.

    Comment

    Working...
    X