1. Hakim Boyles
  2. Valentina Studio
  3. Среда, Июль 29 2015, 04:31 AM
  4.  Подписаться через email
Does Valentina Studio support in-place editing of the returned data from queries? In other words, can data fields only be edited in the edit view of the table?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello, Hakim

Currently it is supported only for Valentina database with RW cursor,
for all others databases Data Editor is the only option.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Hakim and Sergey,

may be Hakim asks about Data Editor actually? It is not very clear what means "edit view of the table".

Hakim, please note, that Valentina Studio have 2 powerful tools:
1) Data Editor - where you can do a lots of things with records
2) SQL Editor - where you see selected records as result of SELECT query.
Комментарий
There are no comments made yet.
Hakim Boyles Ответ принят
Sergey Pashkov wrote:

Hello, Hakim

Currently it is supported only for Valentina database with RW cursor,
for all others databases Data Editor is the only option.

I confirm this, however, i don't want to migrate to a Valentina database. Hopefully this gets implemented someday as I know of another database manager that does this perfectly.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Hakim,

1) so you mean SQL Editor and panel with records from SELECT?

2) it is okay on our forum to name other tools and where they can be better. We like to hear any such things to be able improve Valentina Studio

3) I guess such editing of records in OTHER tool have many enough limits. Something as
* must be PK selected
* must be single table SELECTed?

because I doubt they can edit fields of join records for ONE table, for example.


4) And for single-table case we have powerful Data Editor, where exists FILTER (CMD + F)... you can easy specify the same WHERE filter to see only some records. Try this way and let me know if it is not so comfortable as SQL Editor of other tool. ;)

Also please note that our Data Editor can work with 2 related tables. Again this can be quite powerful feature in your hands.
Комментарий
There are no comments made yet.
Hakim Boyles Ответ принят
I meant the panel with records from SELECT. Navicat and DBeaver can easily edit the records without having to switch back to data editor or issuing another SQL statement. Valentina Studio can do this but it seems only with Valentina Database (*.vdb) files.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Well, they do issue hidden SQL UPDATE command.
We also can do this of course, we will put this on TODO list.
Комментарий
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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories