1. Beatrix Willius
  2. Valentina Server
  3. Samstag, November 03 2018, 12:14 PM
  4.  Abonnieren via E-Mail
I want to partially duplicate the user information screen from Valentina Studio. With my app and with Valentina Studio I'm logged in as "sa" and as "trixi" (both admins):

https://imgur.com/lxnhp78.png

There is an example called "ValentinaServerUtility". It has code to get the user info:


dim dbName as string
dim ci as VClientInfo
dim dbi as VDataBaseInfo
dim i, j as integer

if ListBoxDatabaseInfo.SelCount = 1 then
dbName = ListBoxDatabaseInfo.cell(ListBoxDatabaseInfo.ListIndex, 0)
for i = 1 to mValentinaServer.DatabaseCount
dbi = mValentinaServer.DatabaseInfo(i)
if dbi<>nil then
if dbi.Name = dbName then
ListBoxClients.deleteAllRows
for j = 1 to dbi.ClientCount
ci = dbi.ClientInfo(j)
if ci<>nil then
ListBoxClients.addRow ci.Address
ListBoxClients.cell(ListBoxClients.Listcount-1, 1) = str(ci.ConnectionID)
ListBoxClients.cell(ListBoxClients.Listcount-1, 2) = ci.Login
ListBoxClients.cell(ListBoxClients.Listcount-1, 3) = str(ci.Port)
end if
next
exit
end if
end if
next
end if


Not pretty, but not complicated. But the result is odd:

https://imgur.com/oXUlIRZ.png

Note the information for user with the connection ID 32. The user name is "sa". However, according to Valentina Studio this should be "trixi". Bug or feature? Did I misunderstand something?
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
Indeed, for all connections, you get the current login, not the login for the chosen connection
Very old behavior that, for sure, I consider as a bug.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Okay, I made a Mantis issue at: http://www.valentina-db.com/bt/view.php?id=8396

The question is then: how does Valentina Studio get the correct information?
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Got it working with SQL "show connections".
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
Extra. Thank you sharing this.
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories