bugtracker or projecttracker? documentation/help?
Posted: 09.05.2010, 11:41
Hi.
SqliteAdmin looks useful for me. So thanks to the author(s).
However I have some troubles concerning handling but I have to admit I am not a well experienced sql/sqlite user.
I will ask my question concerning usage of the program later.
First I'd like to know if there is a documentation somewhere like a wiki or a help file. Moreover to keep track of the project's progress a project tracker, at least a bug tracker, would be helpful. I guess there is not but if so please tell me. I would suggest "trac": http://trac.edgewall.org/
Ok, now my questions concerning usage of SqliteAdmin:
--What I liked to do:--
Delete a row of data from a table
--How I tried it:--
1) On the tree view on the left I selected an item under "Tables" which represents the table I'd like to work with.
2) Clicked on tab "Edit Data"
3) Select the row I like to delete by clicking on it
4) Click on "-" button to delete the row
==> The row disappears and it looks like it has been deleted BUT...
--What I found:--
When I close the data base and open it again and navigate to "Edit Data" the row I expected to be removed appears again.
--Ideas:--
Maybe some actions are not committed immediately. But I would expect at least a prompt asking the user if the modified set of data should be stored or discarded upon closing.
The table I used has only 4 columns and there are just 4 rows in it. However I inserted data using my java application and it might be that it corrupted the table because I noticed that I could make it write a string like "abc" to a column of data type "TIMESTAMP".
Any comments/help appreciated.
Regards,
Mark
SqliteAdmin looks useful for me. So thanks to the author(s).
However I have some troubles concerning handling but I have to admit I am not a well experienced sql/sqlite user.
I will ask my question concerning usage of the program later.
First I'd like to know if there is a documentation somewhere like a wiki or a help file. Moreover to keep track of the project's progress a project tracker, at least a bug tracker, would be helpful. I guess there is not but if so please tell me. I would suggest "trac": http://trac.edgewall.org/
Ok, now my questions concerning usage of SqliteAdmin:
--What I liked to do:--
Delete a row of data from a table
--How I tried it:--
1) On the tree view on the left I selected an item under "Tables" which represents the table I'd like to work with.
2) Clicked on tab "Edit Data"
3) Select the row I like to delete by clicking on it
4) Click on "-" button to delete the row
==> The row disappears and it looks like it has been deleted BUT...
--What I found:--
When I close the data base and open it again and navigate to "Edit Data" the row I expected to be removed appears again.
--Ideas:--
Maybe some actions are not committed immediately. But I would expect at least a prompt asking the user if the modified set of data should be stored or discarded upon closing.
The table I used has only 4 columns and there are just 4 rows in it. However I inserted data using my java application and it might be that it corrupted the table because I noticed that I could make it write a string like "abc" to a column of data type "TIMESTAMP".
Any comments/help appreciated.
Regards,
Mark