Re: [sqlite] new uploads
- Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 02, 2004 5:25 PM Subject: Re: [sqlite] new uploads ok, Denis I have fixed the bug and uploaded the new version of sqlite3Explorer. thanks for pointing it out. BTW, I have some comments on your database sample: 1. the bug was triggered by the definition of foreign keys. you use the syntax: create table x( device_id integer references Device it would be more appropriate to do this: create table x( device_id integer references Device(Device_ID) this gives more complete information for the schema. also, I noticed that you use mixed semantics in your column typing: Integer Integer(5) Varchar varchar(32) If you plan to use the strong typing of SqliteExplorer, you should be more consistent, and use : integer varchar(32) what is the meaning of varchar without a size ? did you mean a text blob ? if so, use the definition CLOB, which will give your column text affinity, which is something you want in order to avoid unnecessary attempts to convert to numeric values. true, the "varchar" definition also gives you TEXT affinity, but, since there IS a "preferred" type to declare text blobs, (CLOB), why not use it ? Sqlite3Explorer will recognize it, and give you a multi-line editor to edit/display this field.
Re: [sqlite] new uploads
Dennis Cote wrote: I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error from Hurricane Electric. Please use http://www.sqlite.org/contrib instead. That particular link should not be mirrored on www.hwaci.com. I'll investigate and fix the problem. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Re: [sqlite] new uploads
Dennis Cote wrote: Richard, I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error from Hurricane Electric. may is that the link you're looking for: http://www.sqlite.org/contrib Ciao Massimiliano
Re: [sqlite] new uploads
CARIOTOGLOU MIKE wrote: > I have uploaded the new version of sqlite3Explorer, which fixes a bug > with the schema treeview. Richard, I think there is a problem with the SQLite web site. The contrib link (http://www.hwaci.com/sw/sqlite/contrib) on the main page is giving me a file not found error from Hurricane Electric.
RE: [sqlite] new uploads
I believe I know what is wrong, it has to do with tables that have implicit indexes. I will upload a new version in an hour. pls give it a try, and let me know. if it does not work, send me your database (zipped). regards. > -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 1:08 AM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] new uploads > > > mike cariotoglou wrote: > > I have uploaded the current version of sqlite3Explorer (a GUI to > > manage sqlite3 databases) to http://www.sqlite.org/contrib. also, I > > Hi Mike, > > I was trying to use your sqlite3Explorer program to look at > my database, but > it won't open it. I get a dialog with the following error when I use > File/Open Database... > > --- > sqlite3explorer > --- > Could not convert variant of type (Null) into type (String) > --- > OK > --- > > After this I am left with schema tree with only one table, > the first one > listed by the .schema command in sqlite3.exe. Using > sqlite3.exe to dump the > database shows all the tables actually exist (ther are 38) as > well as their > associated indexes and triggers. > > I'm using sqlite3.dll version 3.08 built from CVS source, and > the version of > sqlite3Explorer on the SQLite website. > > Any ideas? > > If you want I can send you a copy of the problematic database file. > > P.S. A little further digging shows that it is reading the > database, only > the schema tree view is not working. I can see all the tables with > reasonable counts using the View/Show Tables with Counts > command. Without > the schema tree view working, I can't seem to display the contents of > anything other than the master table, and this first table > (which is empty). >
Re: [sqlite] new uploads
mike cariotoglou wrote: > I have uploaded the current version of sqlite3Explorer (a GUI to > manage sqlite3 databases) to http://www.sqlite.org/contrib. also, I Hi Mike, I was trying to use your sqlite3Explorer program to look at my database, but it won't open it. I get a dialog with the following error when I use File/Open Database... --- sqlite3explorer --- Could not convert variant of type (Null) into type (String) --- OK --- After this I am left with schema tree with only one table, the first one listed by the .schema command in sqlite3.exe. Using sqlite3.exe to dump the database shows all the tables actually exist (ther are 38) as well as their associated indexes and triggers. I'm using sqlite3.dll version 3.08 built from CVS source, and the version of sqlite3Explorer on the SQLite website. Any ideas? If you want I can send you a copy of the problematic database file. P.S. A little further digging shows that it is reading the database, only the schema tree view is not working. I can see all the tables with reasonable counts using the View/Show Tables with Counts command. Without the schema tree view working, I can't seem to display the contents of anything other than the master table, and this first table (which is empty).