1. Stephan Fellner
  2. as SQLite DB Server
  3. Saturday, February 25 2017, 01:14 PM
  4.  Subscribe via email
I've tryed to adapt and run the Valentina SQLite Example based on the Xojo SQLite Example. It is hard. In client mode the database is not created (i think it's maybe about the path and the rights?), in local mode the query runs in an error. Summary: Without an current example it is not useable for me. Can anybody help with a Code snippet or with experience?
References
  1. http://www.valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:products:adk:v4rb:start:rbdb_migration_to_vserver_sqlite
Comment
There are no comments made yet.
Stephan Fellner Accepted Answer
Thank you for your great support!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
Ruslan Zasukhin Accepted Answer
Glad to head it works now.

Meanwhile we made improvements

1) WIKI page updated to use App.DB, and visual checkbox ClientMode.
2) V4RB/Examples/RBDB_way/SqliteExampleModified also redesigned to use App.DB property.
will be available in 7.0.2 hotfix.

Thank you, Stephan for finding of out-of-date issues.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
Stephan Fellner Accepted Answer
Ok now it works. With the Plugin from V4RB_6 after click on "Show Sample Data" the Application crashed. With the newer one (V4RB_7) everything works fine... Yes the VServer runs local on macOS. Thank you very much, sometimes the devil is in the details... Wrong Plugin Version, i don't know...

Sun Feb 26 2017 09:18:06.719241 vserver_x64 (Type x64, Server 7.0.1, Kernel 7.0.1 )
vKernel is externally-synched type.
SQLite lib version: 3.14.2
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 3
Ruslan Zasukhin Accepted Answer
Also you can start Vstudio, connect to that VSERVER, and create new SQLite db.

if this works from vstudio, then vserver is okay
and you must be able find your new sqlite db made by vstudio in folder

vserver/databases_sqlite
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 4
Ruslan Zasukhin Accepted Answer
Hi Ruslan,

thank you. Is there a recommendation for this part of the ini file?

[SQLITE]
; The path, where sqlite databases are stored.
SqliteSystemCatalog=databases_sqlite

I think there is a problem with creating the database in the standard path.

Regards
Stephan


Well, you can look inside of your VSERVER folder. BTW it runs in the same machine? localhost?

anyway inside of VSERVER folder you should see folders structure:
licenses
databases
databases_sqlite

VSERVER have access to its own folder, because it write there data.
This should be okay right after installation
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 5
Ruslan Zasukhin Accepted Answer
1) First of all Sergey have checked our ready example, which was described in this tutorial

Examples/RBDB_way/SqliteExampleModified

This example works correctly from the box.
Please try it and confirm that it works for you,


2) Sergey have found at least one mistake in text of tutorial:

mDB = new SQLiteDatabase

must be

App.DB = New SQLiteDatabase
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 6
Stephan Fellner Accepted Answer
Hi Ruslan,

thank you. Is there a recommendation for this part of the ini file?

[SQLITE]
; The path, where sqlite databases are stored.
SqliteSystemCatalog=databases_sqlite

I think there is a problem with creating the database in the standard path.

Regards
Stephan
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 7
Ruslan Zasukhin Accepted Answer
Hi Stephan,

we will check asap this tutorial and check if resulted app works ok.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 8
Stephan Fellner Accepted Answer
VServer is installed on macOS!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 9
  • Page :
  • 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