1. David Richardson
  2. as SQLite DB Server
  3. Freitag, Juni 16 2017, 01:44 PM
  4.  Abonnieren via E-Mail
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?
Kommentar
There are no comments made yet.
David Richardson Akzeptierte Antwort
Thank you Sergey:D Guess I am too new to this!
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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
Anhänge
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