1. Stephan Fellner
  2. as SQLite DB Server
  3. Суббота, Февраль 25 2017, 01:14 PM
  4.  Подписаться через 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?
Ссылки
  1. http://www.valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:products:adk:v4rb:start:rbdb_migration_to_vserver_sqlite
Комментарий
There are no comments made yet.
Stephan Fellner Ответ принят
VServer is installed on macOS!
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Stephan,

we will check asap this tutorial and check if resulted app works ok.
Комментарий
There are no comments made yet.
Stephan Fellner Ответ принят
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
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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
Комментарий
There are no comments made yet.
Stephan Fellner Ответ принят
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
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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.
Комментарий
There are no comments made yet.
Stephan Fellner Ответ принят
Thank you for your great support!
Комментарий
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