1. Beatrix Willius
  2. Valentina Server
  3. Dienstag, Februar 11 2020, 11:47 AM
  4.  Abonnieren via E-Mail
My Valentina Server Management development is progressing nicely. Got one question: how do I get information about the unregistered databases?


dim theDatabases() as Dictionary

for currentDatabase as Integer = 1 to theServer.DatabaseCount

dim DBInfo as VDataBaseInfo = theServer.DatabaseInfo(currentDatabase)
if DBInfo = Nil then continue

dim theDatabase as new Dictionary
theDatabase.Value("Databasename") = DBInfo.Name
theDatabase.Value("ClientCount") = DBInfo.ClientCount
theDatabase.Value("Path") = DBInfo.Path



I get the registered databases. How do I get the unregistered one or ones?

The screenshot below shows Valentina Studio with all databases at the top. "mail archive" is not registered and "mail archiv" is registered. My app in the lower part only shows the registered "mail archiv".
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort

if myUserIsAdmin then
myVConnection.SqlSelect("SHOW DATABASES")
end if

- if the user connected haven't admin right this is not possible
- don't forget to reset the connection if you allow to shutdown/restart vServer. Not doing that crash the application if you issue these commands.
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Thanks, I'll test that. The Server Management module is meant for admins only. So I'll need to add a check anyways.
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Yes, "SHOW DATABASES" is what we use in the Valentina Studio.
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.


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