joe g wrote:
Hi
Trying to insert a new field row in database design view and it is inserted
at the end of the fields already done. How can I insert a new field row
second place?
Thanks so much
Howdy joe,
I'll assume you are using the embedded database.
Yes - but not using the GUI, you will need to use an SQL
statement in the SQL Command Window.
The syntax for the SQL command is:
ALTER TABLE "table_name" ADD COLUMN "new_column_name" <column type>
[column options] BEFORE "existing_column_name"
OK - so you open the SQL command window with
Tools>SQL menu
Full documentation for the ALTER TABLE command can be found at the
HSQLdb website:
http://hsqldb.org
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
