1. Tim Crouse
  2. Valentina Studio
  3. 日, 10月 29 2017, 07:02 PM
  4.  メールで購読
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