I don't know a whole lot about the inner workings of something like KEXI, but I know the basics of it. I have a few tables that I use for things, but recently when editing one I accidentally added a new field to it. Upon doing so I realized there was no way to simply delete it. Right-clicking on the row itself doesn't do anything. And I found out the hard way that you can't simply delete it, because of the primary key. I tried to edit the design settings so it wasn't the primary key anymore and accidentally ended up deleting the whole table in doing so. I'm very annoyed there isn't a simple way to delete something from KEXI, at least not one that's plainly visible. For the future, so I don't do something like this again, HOW DO YOU REMOVE A FIELD/ROW FROM A TABLE IN KEXI?

Hello

I have already had similar problems when trying to modify a table which generally results in the loss of all the records of the table...

the only solution that I could use is to use an external tool for example: sqlitebrowser and to make modifications directly in the structure but I admit that it is a bit complicated and that you have to understand the mechanism well.

The basic rule is to before modifying the structure of your database, either by Kexi or an external tool, and to always make a complete backup of your database (i.e. tables, forms, queries, etc. )

Hope you get more specific answers.

Cordially

ptijoz wrote:Hello

I have already had similar problems when trying to modify a table which generally results in the loss of all the records of the table...

the only solution that I could use is to use an external tool for example: sqlitebrowser and to make modifications directly in the structure but I admit that it is a bit complicated and that you have to understand the mechanism well.

The basic rule is to before modifying the structure of your database, either by Kexi or an external tool, and to always make a complete backup of your database (i.e. tables, forms, queries, etc. )

Hope you get more specific answers.

Cordially

Kind of a relief to know I'm not the only one who has had this issue. XD I appreciate the input though, thanks.

Deleting a row (record): right click, pick Delete row.

Deleting a column: still no GUI for that, frequent topic, e.g. at viewtopic.php?f=221&t=132264

People sometimes export to CSV, edit in a **** and import the CSV back. Needs attention. We also had scripts perform the table altering but these were not too easy to use.

Best regards
Jarek

jstaniek wrote:Deleting a row (record): right click, pick Delete row.

Deleting a column: still no GUI for that, frequent topic, e.g. at viewtopic.php?f=221&t=132264

People sometimes export to CSV, edit in a **** and import the CSV back. Needs attention. We also had scripts perform the table altering but these were not too easy to use.

Best regards
Jarek

The thing is, from what I could see I didn't see an option to delete row. I would right click on the row itself but no option would come up.

I have two ideas why:
1. You're viewing a query. Queries are read-only in KEXI at least for now. (In MS Access some oft them are read-write, that depends on some strict rules)
2. You've opened the database read-only.