1. Beatrix Willius
  2. Valentina Server
  3. 火, 2月 11 2020, 11:47 AM
  4.  メールで購読
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