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.
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories