On 10 Apr 2015, at 12:33pm, Gabriel Tiste <Gabriel.Tiste at hiq.se> wrote:
> We can do a select on columns but not select * on affected table except the > last column. Including that in the select cause the client to say that table > is missing or logic is not correct. > > Are there any known issues with sqlite2 Are you absolutely positively sure you're using SQLite2 and not SQLite3 ? I'm going to assume you actually mean you're using SQLite3 which was released in 2004. > and windows 7? How can I investigate whats causing this error when I try to > select * from the affected table? Please execute the following: PRAGMA database.integrity_check and give us some idea about what it returns. You can run the command using your own program, or make a copy of the database (on another computer ?) and use the SQLite shell tool. Simon.
