1. Johnny Harris
  2. as SQLite DB Server
  3. Friday, March 25 2016, 10:49 AM
  4.  Subscribe via email
How do I retrieve a list of the SQLite databases that exist on VServer?
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Johnny,

do you mean in Valentina Studio or from Xojo code?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
Johnny Harris Accepted Answer
Hi Ruslan,

From Xojo code.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 3
Johnny Harris Accepted Answer
I've tried both those methods. I only get the Valentina databases, not the SQLite databases.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 4
Sergey Pashkov Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 5
Johnny Harris Accepted Answer
OK, Thanks Sergey
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 6
Ruslan Zasukhin Accepted Answer
Implemented.

6.4.1 archives are online.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 7
Johnny Harris Accepted Answer
Great... thanks guys. I'll update to the latest version today.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.