RE: [sqlite] ANN: Sqlite3Explorer.exe version 1.6

2005-06-22 Thread Hugh Gibson 
Mike, 

> which version of the dll are you using ? 

I was using 3.2.1. I upgraded to 3.2.2 and got:

---
sqlite3explorer
---
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'. 
Write of address 0133CA7D.
---
OK   
---

> do you have REFERENCES declarations ? 

No, it's nothing that we use. I'm not even sure what it does! I see it's a 
keyword in the SQLite list but a full search for it doesn't show it 
anywhere else in the SQLite pages.

> can you send me a sample of the data ? 

Well, I can get SQLite3Explorer to crash by creating a new database:

CREATE TABLE t (sValue TEXT);
INSERT INTO T (sValue) VALUES ('HELLO');
// Note: VALUES isn't highlighted as a keyword; VALUE is (bug)
SELECT * FROM T;
INSERT INTO T (sValue) VALUES 
('012345678901234567890123456789012345678901234567890123456789012345678901
2345678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789');

That's 1000 characters (plus odd CRLF) and is OK when doing another 
SELECT, but note that the saved query can't be recalled from history.
Now continue in that way, creating 10,000+ characters in the insert. The 
insert runs OK, but you get crashes when selecting the table and doing 
Show Data. There are also problems when you close the program.

At one point I got problems in the query editor creating a big query. I 
wasn't able to repeat that, with a query up to 1 MB big.

Hugh
 
> > -Original Message-
> > From: Hugh Gibson [mailto:[EMAIL PROTECTED] 
> > Sent: Wednesday, June 22, 2005 4:22 PM
> > To: sqlite-users@sqlite.org
> > Subject: Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6
> > 
> > Just got a crash when viewing table data using SQLite3Explorer version
> > 1.6:
> >  
> > The only thing that could affect this is that I had some 
> > fields with lots of data, probably around 100k.

RE: [sqlite] ANN: Sqlite3Explorer.exe version 1.6

2005-06-22 Thread Cariotoglou Mike 
which version of the dll are you using ? do you have REFERENCES
declarations ? can you send me a sample of the data ? 

> -Original Message-
> From: Hugh Gibson [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, June 22, 2005 4:22 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6
> 
> Just got a crash when viewing table data using SQLite3Explorer version
> 1.6:
> 
> ---
> sqlite3explorer
> ---
> Access violation at address 00402E29 in module 'sqlite3Explorer.exe'. 
> Write of address 01357AAE.
> ---
> OK   
> ---
> 
> Pressing OK enabled me to scroll the data, but when reaching 
> near the bottom I got:
> 
> ---
> sqlite3explorer
> ---
> RecordIndex out of range.
> ---
> OK   
> ---
> 
> Integrity check on the database gave:
> 
> ---
> sqlite3explorer
> ---
> Database seems ok
> ---
> OK   
> ---
> 
> Scrolling up and down gave more errors, and eventually I had 
> to kill the app.
> 
> The only thing that could affect this is that I had some 
> fields with lots of data, probably around 100k.
> 
> Hugh
> 
> 
>

Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6

2005-06-22 Thread Hugh Gibson 
Just got a crash when viewing table data using SQLite3Explorer version 
1.6:

---
sqlite3explorer
---
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'. 
Write of address 01357AAE.
---
OK   
---

Pressing OK enabled me to scroll the data, but when reaching near the 
bottom I got:

---
sqlite3explorer
---
RecordIndex out of range.
---
OK   
---

Integrity check on the database gave:

---
sqlite3explorer
---
Database seems ok
---
OK   
---

Scrolling up and down gave more errors, and eventually I had to kill the 
app.

The only thing that could affect this is that I had some fields with lots 
of data, probably around 100k.

Hugh

Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6

2005-06-16 Thread Hugh Gibson 
> I have uploaded v 1.6 of sqlite3Explorer (www.singular.gr/sqlite).

Thanks!

The download page has 16/03/2005 against version 1.6 - should be 
16/6/2005.

Hugh