Page 1 of 1
Sqlite - can't edit data

Posted:
Thu Aug 09, 2012 6:53 pm
by JohnW
Just as the title says. All editable options are disabled. Attempted both drivers, and all combinations of Transaction modes. Db is not in read-only mode.
Am I missing something, or should I put this in feature requests? Thanks, looks great otherwise.
OSx 10.7
DBeaver 1.6.1
Re: Sqlite - can't edit data

Posted:
Thu Aug 09, 2012 10:57 pm
by codebling
When you say "Db is not in read-only mode," this mean that "Read-only connection" on page 2 of your connection settings is unchecked, right? Is there at least one unique key or index in the table you are trying to edit? Is the file writable? That's all I've got, probably someone else has more insight..
Re: Sqlite - can't edit data

Posted:
Fri Aug 10, 2012 8:24 am
by Serge
Also please specify what SQLite driver do you use.
There are at least 3 different drivers and they differs in metadata extraction (e.g. one of them doesn't see indexes). Try to use different driver - may be it will solve the problem.
Thanks