MichaelSp / Langunator

Language and Vocabulary trainer
0 stars 1 forks source link

Table to display whole voc of one category #23

Open Petebox opened 11 years ago

Petebox commented 11 years ago

Unfortunately it does not work anymore ;-)

MichaelSp commented 11 years ago

I can not reproduce this. What version are you testing with?

MichaelSp commented 11 years ago

Maybe your data base is rather old. I recently renamed the column lektion to lesson. If your data base table has a column lektion, the display table will remain empty. Can you check that and if it's the case rename the column to lesson?

Petebox commented 11 years ago

:-D wenn ich die spalte umbenennen will, stürzt der database browser ab

MichaelSp commented 11 years ago

Hm... Could you try to rename the column using SQL-Statements?

Here is how it works: http://stackoverflow.com/questions/805363/how-do-i-rename-a-column-in-a-sqlite-database-table

Petebox commented 11 years ago

Yep, that is how I tried it. It just seems that the SQLite Browser is crap. ;-) It even shuts down when I type in the command: UPDATE table sqlite_sequence SET (seq = 0) WHERE (name = 'category') or (name = 'vocable');

Petebox commented 11 years ago

Ok, I made it. It works with the different options of the program. But SQL commands seems to be too much for it.

MichaelSp commented 11 years ago

Actually it's true: SQLite Browser is crap ;) But I'm glad you nailed it.

Did this fix your original issue?