Base should allow fields to be reordered.
This property isn't provided by the internal HSQLDB database. It will only allow to position a new field by SQL: ALTER TABLE "Person" ADD "Forename" VARCHAR(25) BEFORE "Surname"; Internal Firebird (which is experimental at this moment) will allow to position a field after it has been inserted: ALTER TABLE "Person" ALTER "Forename" POSITION 2; But there are also bugs while people are trying to copy and paste with the table editor. Only fieldname and fieldtype where moved, but content will be at the same position of the table … DoN#t know the bug number.
Am I correct to think that Firebird allows this, and HSQLDB is (potentially) unable to provide this? If all of that is true, I suppose that my request is already being completed by the developers of the Experimental Features.
(In reply to BEEDELL ROKE JULIAN LOCKHART from comment #2) > Am I correct to think that Firebird allows this, and HSQLDB is (potentially) > unable to provide this? Firebird allows this in direct SQL, not through the GUI. And Firebird is experimental. HSQLDB only allows to add a new field as a special position in direct SQL, not though GUI. > If all of that is true, I suppose that my request is > already being completed by the developers of the Experimental Features. No, it isn't. Everybody, who tries to get this by GUI with any database (internal Firebird, HSQKDB external databases) by copy and paste of fields or cut and past of fields will see its doesn't work. Use forms for input data. Base is made for this. You could sort fields there independent of sorting in the table.
(In reply to Robert Großkopf from comment #3) > (In reply to BEEDELL ROKE JULIAN LOCKHART from comment #2) > > Am I correct to think that Firebird allows this, and HSQLDB is (potentially) > > unable to provide this? > > Firebird allows this in direct SQL, not through the GUI. And Firebird is > experimental. > HSQLDB only allows to add a new field as a special position in direct SQL, > not though GUI. > > > If all of that is true, I suppose that my request is > > already being completed by the developers of the Experimental Features. > > No, it isn't. Everybody, who tries to get this by GUI with any database > (internal Firebird, HSQKDB external databases) by copy and paste of fields > or cut and past of fields will see its doesn't work. > > Use forms for input data. Base is made for this. You could sort fields there > independent of sorting in the table. Understood. I am new to database-management. You appear to have stated that I should use the form-feature to present the data as I desire, which might well remediate this problem for me. However, does no rationale exist for being able to reorder the fields of the database? Even if this is not useful for me, I do not want to close this report unless this is confirmed to be undesirable. I am thankful for your assistance.