1. Crescenzio Gallo
  2. Valentina Studio
  3. Среда, Ноябрь 21 2018, 09:55 AM
  4.  Подписаться через email
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.
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.

Crescenzio
Комментарий
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