1. Beatrix Willius
  2. Valentina Server
  3. Вторник, Февраль 11 2020, 11:47 AM
  4.  Подписаться через 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".
Вложения
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят

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.
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
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 Ответ принят
Yes, "SHOW DATABASES" is what we use in the Valentina Studio.
Комментарий
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