1. Beatrix Willius
  2. Valentina Studio
  3. Sunday, April 19 2020, 10:37 AM
  4.  Subscribe via email
Why do I get an error "unexpected token recid" in the SQL editor of Valentina Studio when doing a dead simple query like


select *, recid from message where recid in [1]


I've also tried my other table attachment with the same result. Also


select *, recid from message where message.recid in [1]


gives an error "unexpected token in". The same queries work fine in my Xojo code, by the way.
Attachments (1)
Comment
There are no comments made yet.
Beatrix Willius Accepted Answer
I forgot the version: using latest Valentina Studio 10.1.2.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
Hello Beatrix,

in (1) should work here:

select *, recid from message where recid in (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Beatrix Willius Accepted Answer
Oh, man. The brain is going.... Thanks!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories