1. Johnny Harris
  2. as SQLite DB Server
  3. Freitag, März 25 2016, 10:49 AM
  4.  Abonnieren via E-Mail
How do I retrieve a list of the SQLite databases that exist on VServer?
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Johnny,

do you mean in Valentina Studio or from Xojo code?
Kommentar
There are no comments made yet.
Johnny Harris Akzeptierte Antwort
Hi Ruslan,

From Xojo code.
Kommentar
There are no comments made yet.
François Van Lerberghe Akzeptierte Antwort
If you are connected to the VServer as admin, you can send the SQL command :
Show Databases

If you are not admin, you can only know the registered databases. You can write :
dim myServer As VServer
dim dbi As DatabaseInfo
dim n As Integer
dim dbListNames As String

myServer = new VServer(app.myConnection)
if myServer <> nil then
// As you don't need to know the first (that is "master.vdb")
// you can start at 2 (n = 2)
For n = 2 To myServer.DatabaseCount
dbi = myServer.DatabaseInfo(n)
if dbi <> nil then
dbListNames = dbListNames + ";" + dbi.Name
end if
next
dbListNames = Mid(dbListNames, 2)
end if
Kommentar
There are no comments made yet.
Johnny Harris Akzeptierte Antwort
I've tried both those methods. I only get the Valentina databases, not the SQLite databases.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Right, it works only for Valentina Databases.
Methods to get the list of SQLite databases are not implemented in V4RB plugin yet.
We'll fix it in the next 6.4.1 release.
Kommentar
There are no comments made yet.
Johnny Harris Akzeptierte Antwort
OK, Thanks Sergey
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Implemented.

6.4.1 archives are online.
Kommentar
There are no comments made yet.
Johnny Harris Akzeptierte Antwort
Great... thanks guys. I'll update to the latest version today.
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