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?

Thanks,
Crescenzio
添付ファイル
コメント
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.

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

For MySQL another markers are used: $1
コメント
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.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories