Sqlite - can't edit data

Note: please leave bug reports and feature requests on

Sqlite - can't edit data

Postby JohnW » Thu Aug 09, 2012 6:53 pm

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
JohnW
 
Posts: 1
Joined: Thu Aug 09, 2012 6:47 pm

Re: Sqlite - can't edit data

Postby codebling » Thu Aug 09, 2012 10:57 pm

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..
codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: Sqlite - can't edit data

Postby Serge » Fri Aug 10, 2012 8:24 am

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
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 30 guests