1. David Richardson
  2. as SQLite DB Server
  3. Friday, June 16 2017, 01:44 PM
  4.  Subscribe via 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?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
David Richardson Accepted Answer
Thank you Sergey:D Guess I am too new to this!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.