1. Beatrix Willius
  2. as Valentina DB Server
  3. Tuesday, October 10 2017, 06:07 AM
  4.  Subscribe via email
Yesterday I asked a question about GetDatabaseFormatVersion and GetSchemaVersion for server. This only gave me a nice error without error error message. Turned out that I had asked the question a while ago and then someone deleted the post from yesterday. Unfortunately, I wasn't able to solve the problem.

Original question was how to adapt the code for local


currentVersion = Valentina.GetDatabaseFormatVersion(theFolderitem)
oldSchemaVersion = Valentina.GetSchemaVersion(theFolderitem)


to the server. Changing the code to


currentVersion = Valentina.GetDatabaseFormatVersion(GetFolderItem(DatabaseName))
oldSchemaVersion = Valentina.GetSchemaVersion(GetFolderItem(DatabaseName))


only gave a VException 365826 without error message.

Ivan gave me the tip to do a Valentina.init after Valentina.InitClient which fixed the empty error message. I thought that only one Valentina init method is to be used but whatever.

In my original question 6 months ago Ivan said to use


SELECT schemaversion;
SELECT databaseversion;


This has 2 problems. For this I would have to open the database first but I can work around this issue. However, when trying the SQL in ValentinaStudio latest version I only get errors:

Kernel error: 0x51500. Identifier "schemaversion" is not found.
Kernel error: 0x51500. Identifier "databaseversion" is not found.

What do I do now?

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer

select schemaversion();
select databaseversion();
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Beatrix Willius Accepted Answer
ARRGGGGHHH. Of course, it's a function.

Thanks!

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
  • Page :
  • 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