1. Tim Crouse
  2. Valentina Studio
  3. Воскресенье, Октябрь 29 2017, 07:02 PM
  4.  Подписаться через email
When creating fields is it possible to insert a new filed between existing fields?

Is is possible to move fields up or down in the field design view?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Tim,

No, currently it is not possible
Комментарий
There are no comments made yet.
Tim Crouse Ответ принят
I triple clicked the field design table "NAME" column header and it sorted the fields alphabetically.

How do I undo the sort so the fields appear in the sequential filed order?
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Tim,

actually, this also depends on DB you are using
which one you use?
Комментарий
There are no comments made yet.
Tim Crouse Ответ принят
These questions are related to SQLite type db
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
We have this request in the bug tracker http://valentina-db.com/bt/view.php?id=7787
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Tim,

let's discuss this more deeply.

1) Do you want to be able to do this action (change physical order of fields in table)
a) on the step of dB Design?
b) or when db exists on disk already?

If we talk mainly about 1a case, then the best step I think is to use our Diagrams. Although we need to add change order of fields to diagrams also, this is easy enough step.

Change physical order of fields in an existed table with records, is a more hard task which takes longer time. And for each DB it takes own efforts.


2) Are you going to use this SQLite DB later from some app code OR you going to use Vstudio itself?
In the second case - Layout can have any order.
Комментарий
There are no comments made yet.
Tim Crouse Ответ принят
1) Do you want to be able to do this action (change physical order of fields in table)
a) on the step of dB Design? >> At DB Design Time as I frequently am adding, deleting or inserting new fields into a table as I work through the initial DB Schema
b) or when db exists on disk already? >> It would be nice to be able to do this operation on an active DB >> perhaps an operator could select the columns through a wizard that merely runs an SQL script.



If we talk mainly about 1a case, then the best step I think is to use our Diagrams. Although we need to add change order of fields to diagrams also, this is easy enough step.

Change physical order of fields in an existed table with records, is a more hard task which takes longer time. And for each DB it takes own efforts.


2) Are you going to use this SQLite DB later from some app code OR you going to use Vstudio itself?
In the second case - Layout can have any order.

I am looking more into diagrams now

Thanks
Tim
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Tim,

as far as I see, our devs already commit into hotfix branch implementation of this.

Diagrams and CreateSomething dialogs will allow change order of children objects IF object does not exists yet,

User should see arrows UP and DOWN.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hi Tim,

A test build was uploaded


  • UP/DOWN buttons were added to Design Table dialog for the new tables
  • Fixed creation of the second foreign key link
  • Foreign key link appear in the table structure after creation
Ссылки
  1. http://www.valentina-db.com/download/beta/night_build/7.5.3_(2017_11_03)/
Комментарий
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