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?

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".
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Yes, "SHOW DATABASES" is what we use in the Valentina Studio.
Kommentar
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.
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort

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.
Kommentar
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.

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