1. David Richardson
  2. as SQLite DB Server
  3. Пятница, Июнь 16 2017, 01:44 PM
  4.  Подписаться через email
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories