Skip to content
  • Sqlite nested select

    Unsolved General and Desktop
    4
    0 Votes
    4 Posts
    194 Views
    JonBJ

    @GeorgiosKoropoulis
    If you want to use whatever SQLite constructs in queries you have, like INSERT OR IGNORE INTO ... or SELECT ... FROM/VALUES (SELECT ... FROM), you can but you have to build the text of the query yourself. In this case you may find that binding does not work (that is supported by the driver, so depends what that allows for binding), but you can build that yourself into the text of the query without using binding. Just beware of correct syntax (e.g. quoting) and SQL injection.