1. Tim Crouse
  2. Valentina Studio
  3. Sunday, October 29 2017, 07:02 PM
  4.  Subscribe via 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?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Tim,

No, currently it is not possible
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Tim Crouse Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Ruslan Zasukhin Accepted Answer
Hi Tim,

actually, this also depends on DB you are using
which one you use?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Tim Crouse Accepted Answer
These questions are related to SQLite type db
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Sergey Pashkov Accepted Answer
We have this request in the bug tracker http://valentina-db.com/bt/view.php?id=7787
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
Ruslan Zasukhin Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 6
Tim Crouse Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 7
Ruslan Zasukhin Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 8
Sergey Pashkov Accepted Answer
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
References
  1. http://www.valentina-db.com/download/beta/night_build/7.5.3_(2017_11_03)/
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.