Re: [sqlite] Issue with Malformed table

2016-11-16 Thread Paul Sanderson
If you are unsucessful dro me an email - I might be able to help (not a commercial proposition - just may help me doing some testing with my code) Cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

Re: [sqlite] Issue with Malformed table

2016-11-16 Thread Simon Slavin
On 16 Nov 2016, at 3:16pm, Andrew Stewart wrote: > Forgot to ask 1 thing. What is a quick way to copy an entire table > from database1 to database2? If they are open in different connections you cannot do it. If they are open in the same connection using

Re: [sqlite] Issue with Malformed table

2016-11-16 Thread Simon Slavin
On 16 Nov 2016, at 3:14pm, Andrew Stewart wrote: > >Thank you for the response. I will give it a try. I can do this with > 2 different database connections and then just transfer all of the tables > from database1 to database2. Close database1.

Re: [sqlite] Issue with Malformed table

2016-11-16 Thread Andrew Stewart
AM To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Issue with Malformed table Simon, Thank you for the response. I will give it a try. I can do this with 2 different database connections and then just transfer all of the tables from dat

Re: [sqlite] Issue with Malformed table

2016-11-16 Thread Andrew Stewart
ubject: Re: [sqlite] Issue with Malformed table On 16 Nov 2016, at 2:52pm, Andrew Stewart <astew...@arguscontrols.com> wrote: >I have a table that is giving me errors. I can recover the > data from another source, but need a way to clear the table. This process is

Re: [sqlite] Issue with Malformed table

2016-11-16 Thread Simon Slavin
On 16 Nov 2016, at 2:52pm, Andrew Stewart wrote: >I have a table that is giving me errors. I can recover the > data from another source, but need a way to clear the table. This process is very fast and easy, but it may not help with your form of

[sqlite] Issue with Malformed table

2016-11-16 Thread Andrew Stewart
Hi, I have a table that is giving me errors. I can recover the data from another source, but need a way to clear the table. The following is my process: Read row from table1 - detect error (SQL logic error or missing database). Have been able to read other rows from same