Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support numbered bind params #3549

Open
chriszrc opened this issue Jul 28, 2019 · 0 comments

Comments

@chriszrc
Copy link

commented Jul 28, 2019

Details

Hi, thanks for adding bind param support! I'm looking at the official docs here:

https://www.sqlite.org/lang_expr.html#varparam

And it indicates that params in the format of "?1" or "?2" should work, but I get this in sqlite studio (v3.2.1)

[15:13:44] Error while executing SQL query on database 'client_sqlite': Error while preparing statement: could not bind parameter :arg01
Using just a "?" works, and per our discussion here:

#3268 (comment)

It looks like this format should be supported.

Steps to reproduce

Open a sql editor, enter a query like the following and execute:

select * from foo f where f.bar = ?1

Operating system

MacOS

SQLiteStudio version

v3.2.1

@pawelsalawa pawelsalawa added the bug label Jul 28, 2019

@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Jul 28, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.