1. Beatrix Willius
  2. Valentina Server
  3. Tuesday, February 11 2020, 11:47 AM
  4.  Subscribe via email
My Valentina Server Management development is progressing nicely. Got one question: how do I get information about the unregistered databases?

With


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

theDatabases.Append(theDatabase)

next


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".
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Yes, "SHOW DATABASES" is what we use in the Valentina Studio.
Comment
There are no comments made yet.
Beatrix Willius Accepted Answer
Thanks, I'll test that. The Server Management module is meant for admins only. So I'll need to add a check anyways.
Comment
There are no comments made yet.

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

Burt,
- 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.
Comment
There are no comments made yet.
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories