1. Johnny Harris
  2. as SQLite DB Server
  3. 金, 3月 25 2016, 10:49 AM
  4.  メールで購読
How do I retrieve a list of the SQLite databases that exist on VServer?
コメント
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.
Ruslan Zasukhin 承諾済みの回答
Implemented.

6.4.1 archives are online.
コメント
There are no comments made yet.
Johnny Harris 承諾済みの回答
OK, Thanks Sergey
コメント
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 承諾済みの回答
I've tried both those methods. I only get the Valentina databases, not the SQLite databases.
コメント
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 承諾済みの回答
Hi Ruslan,

From Xojo code.
コメント
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.
  • ページ :
  • 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