1. Beatrix Willius
  2. Valentina Studio
  3. Воскресенье, Апрель 19 2020, 10:37 AM
  4.  Подписаться через 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.
Вложения
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
I forgot the version: using latest Valentina Studio 10.1.2.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Beatrix,

in (1) should work here:

select *, recid from message where recid in (1)
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
Oh, man. The brain is going.... Thanks!
Комментарий
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