Announcement

Collapse
No announcement yet.

Bind variables in the query editor

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

  • Bind variables in the query editor

    It would be nice if Navicat asks for user input when it encounters queries like this:
    SELECT * FROM sometable WHERE somecolumn = :foobar

  • #2
    Please note that Navicat supports parameters in query. You can input parameters to a query each time you run it. The parameter should appear as an identifier with $ at its beginning, quote with [ ], e.g. [$any_name].

    Example:
    SELECT * FROM table_name WHERE id = [$id]

    Comment

    Working...
    X