1. Beatrix Willius
  2. Valentina Studio
  3. Sonntag, April 19 2020, 10:37 AM
  4.  Abonnieren via E-Mail
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.
Anhänge
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
I forgot the version: using latest Valentina Studio 10.1.2.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Beatrix,

in (1) should work here:

select *, recid from message where recid in (1)
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Oh, man. The brain is going.... Thanks!
Kommentar
There are no comments made yet.
  • Seite :
  • 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