1. Beatrix Willius
  2. Valentina Studio
  3. 日, 4月 19 2020, 10:37 AM
  4.  メールで購読
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