1. Crescenzio Gallo
  2. Valentina Studio
  3. 水, 11月 21 2018, 09:55 AM
  4.  メールで購読
I have downloaded VStudioPro 8.6 and tried to use the new useful Parameters feature in the SQL Editor window. But unfortunately I always get from MySql a syntax error just around the parameter (see screenshot). My query looks like:

SELECT * FROM table WHERE field = :1;

and the value for parameter :1 has been filled in the right side list of parameter:value pairs.

Can someone suggest something to check?

There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Crescenzio,

For MySQL another markers are used: $1
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
Perfect! I must have missed it or it was not written in the documentation...

Thank you very much, Sergey.

There are no comments made yet.
  • ページ :
  • 1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.