Hello,

How do you make a table editable such that you can delete fields and replace with new ones? All tables seem to be read-only non-editable by default.

Thanks

Paul Speed

Step one, upgrade. See my comment on prior thread.

Editing table structure are done through the Edit - Schema, Ctrl-E shortcut when the table is open. Note that there are restrictions as to what can be done. This means that multiple edits may need to be made to facilitate this. Depending on what changes need be made some of the Transform functions may help in preserving or making such changes. Consult the Schema section of the manual. https://manifold.net/doc/mfd9/schema.htm

It is a very long topic with Important notes. Please regard them. Fields can be renamed, deleted, and created by this dialog box. Careful with deletion as it will remove data. It is better to create then use some of the Transform functions to transfer data before deletion. Changes to data type are tricky for the same reason.

upgrade. upgrade. upgrade.

-Oeaulong

I'd add to the above it also depends on where your tables come from. Did you create a new table with File - Create - New table? Did you import a new table? Did you link a table?

If you linked a new table, did you do that from a read-only data source? For example, did you link a new table from your organization's Oracle database server and you don't have read/write access? If so, you're not going to be able to edit either the data in those tables or the schema.

There are also very basic things about tables, like create a table without an index, which means the contents of the table won't be editable. There are useful topics that discuss that in the user manual, like the Edit Tables topic in the Quick Start Guide

Thank you Dimitri - the tables/layers I created myself. Maybe I dont have an INDEX - I shall try and wade my way through the user manual - which I have to say I find hard going.

Speedy