1. David Richardson
  2. as SQLite DB Server
  3. 金, 6月 16 2017, 01:44 PM
  4.  メールで購読
I am new to Valentina Server and am trying to execute some SQL for a SQLite database on the server. It seems that any SQL having to do with date functions is throwing kernel errors. For example: 08:28:55 Kernel error: 0x9050e. Error in function name "julianday". I am running this SQL elsewhere with no issue. I guess it may also be the Valentina Studio throwing these errors.

SQL - SELECT Date('now');
returns 08:39:29 Kernel error: 0x71000. line 2:12: expecting STRING_LITERAL, found '('

This SQL works fine in Studio when running against SQLite file.

Any ideas?
コメント
There are no comments made yet.
David Richardson 承諾済みの回答
Thank you Sergey:D Guess I am too new to this!
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello David,

Looks like you're executing queries in the Valentina Database (not SQLite) on the Valentina Server.

You should select SQLite Server connection target in the Connect Dialog
添付ファイル
コメント
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