1. Crescenzio Gallo
  2. Valentina Studio
  3. Wednesday, November 21 2018, 09:55 AM
  4.  Subscribe via 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
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Crescenzio,

For MySQL another markers are used: $1
Comment
There are no comments made yet.
Crescenzio Gallo Accepted Answer
Perfect! I must have missed it or it was not written in the documentation...

Thank you very much, Sergey.

Crescenzio
Comment
There are no comments made yet.
  • Page :
  • 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