1. Johnny Harris
  2. as SQLite DB Server
  3. Пятница, Март 25 2016, 10:49 AM
  4.  Подписаться через email
How do I retrieve a list of the SQLite databases that exist on VServer?
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Johnny,

do you mean in Valentina Studio or from Xojo code?
Комментарий
There are no comments made yet.
Johnny Harris Ответ принят
Hi Ruslan,

From Xojo code.
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
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
Комментарий
There are no comments made yet.
Johnny Harris Ответ принят
I've tried both those methods. I only get the Valentina databases, not the SQLite databases.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Johnny Harris Ответ принят
OK, Thanks Sergey
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Implemented.

6.4.1 archives are online.
Комментарий
There are no comments made yet.
Johnny Harris Ответ принят
Great... thanks guys. I'll update to the latest version today.
Комментарий
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.