1. Shanon Hart
  2. Valentina Studio
  3. Sunday, June 30 2019, 03:25 PM
  4.  Subscribe via email
I'm confused on how to work with the visual query editor. If I choose to "save" a query that i've built where does it get saved? It doesn't seem that I can edit the name of it ( I can edit the tab name, but not the saved query name), and can't seem to delete them either. I can "open" it again using the "open" command, but again, can't figure out where these are actually being stored and can't find a reference to it in the documentation.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello,

In order to delete a query, you should select it in the "Queries" list and use context menu - action Delete.
To rename it, you can select it and type a new name in the property inspector on the right.

Currently, query data is saved in the user preferences on disk (or in the registry).
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Shanon Hart Accepted Answer
Thank you so much Sergey!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Kevin Accepted Answer


Currently, query data is saved in the user preferences on disk (or in the registry).



Hi,

In Windows, is this an option / preference?

I had to move to another computer. When I opened my database on the new computer, I saw it didn't contain any of the queries I had created with the Visual Query Editor. (Oh no.) (I come from Access, where they are stored in the database.) I hadn't copied and saved them. I had uninstalled Studio on the old computer. If the uninstall didn't delete them and they are on disk, where should I look? I looked in AppData and didn't see anything. If the uninstall didn't delete them and they are in the registry, is there a way to save/export them? If I reinstall Studio on the old computer will I be able to access the queries?

Thanks,

Kevin
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
Hello Kevin,

Sorry, the settings are stored in the registry, the queries are stored on the disk.

I rechecked an actual place:
C:\Users\username\AppData\Local\Paradigma Software\Valentina Studio\LocalData\Foreign\

Each database' data in separate folder, for example:
C:\Users\username\AppData\Local\Paradigma Software\Valentina Studio\LocalData\Foreign\10.0.2.2%2Fuser%2F3306%2F%2F%2F%2F0%2Fsakila

So if the location of the database was changed, it is necessary to adjust the folder name.

Originally the queries were stored in the database, but sometimes there is no permissions to write into it. We plan to do it adjustable
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Kevin Accepted Answer
Hi Sergey,

Thank you! Found the folder on the old computer (I had seen it when I was looking, but concluded I do not know what that is so I moved on). One of the queries took forever to write in Access and it took forever to translate to SQLite (I am sure many could have written it in a few minutes; it is just one of those things).

I will get in the habit of exporting and saving. Is there a built-in way to export / save all the queries at once as sql or text files?

FYI - I had seen this in the Wiki before posting (based on your response it may (or may not) need updating):

refs_find&" target="_blank" rel="nofollow">https://www.valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:tips:vstudio:prefs_find&;s[]=appdata

Again thank you,

Kevin
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories