Re: [sqlite] Charset-Confusions
Hi Ralf > --- Ursprüngliche Nachricht --- > Von: Ralf Junker <[EMAIL PROTECTED]> > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Charset-Confusions > Datum: Tue, 16 May 2006 11:10:28 +0200 > You have asked "How is it so complicated? *hmmm*" Well, because SQLite > does not have an interface to save values back to the database for any > arbitrary select statement. In order to update a cell, its database, > table,column, and row must be determined, which is unfortunately not > always possible, for example if the query does not contain the RowID > as part of its result set. Then SQLiteSpy would have to modify > the query, and so on. Ooops... i dont have considered this. But the Background as i look at this feature is, i have allways and in every Table a First-Field named "RecID", Autoincremental, Primary Key, not editable. Also I ever have a RowID and never got this problem. But this i even my way... and now I understand the problem that have a public tool. > I wish there was a function like > long long int sqlite3_column_rowid(sqlite3_stmt*, int iCol); Yep. That's it. Best Regards, Anne -- GMX Produkte empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
Re: [sqlite] Charset-Confusions
I use sqlitebrowser and is very happy with it http://sqlitebrowser.sourceforge.net mvh Anders COS skrev: Anne, - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, May 15, 2006 3:44 PM Subject: [sqlite] Charset-Confusions An the 2. question: Is there any Really-Good-Admin-Tool to create DB and Table, to browse and maybe edit Fieldvalues in a grid? I have found 4 Admin-Programms. Some of them cannot open Version 3, some cannot differ Unicode and Multibytecharset, one of them has not a useful gui. Greetings from Germany Anne Try DBTools Manager Professional at http://www.dbtools.com.br/EN/downloads. It is very popular in the Open Sourced databases community (It supports many database engines). Its features can be compared with a mix of MSSQL Server Enterprise Manager and MSAccess. It has a datasheet view to edit table data with the following features: - Capabilities for data paging: very good if your table has millions of data - Capabilities to show images from blob fields as well as import/export binary content - Edit/Save, Filter and Order field capabilities - Can be exported to HTML, XML, CSV and MSAccess PS: For Windows only. Check the page http://www.dbtools.com.br/EN/dbmanagerpro for a full list of features. Best Regards, COS -- GMX Produkte empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
Re: [sqlite] Charset-Confusions
Anne, - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, May 15, 2006 3:44 PM Subject: [sqlite] Charset-Confusions > An the 2. question: Is there any Really-Good-Admin-Tool to create > DB and Table, to browse and maybe edit Fieldvalues in a grid? > I have found 4 Admin-Programms. Some of them cannot open Version 3, > some cannot differ Unicode and Multibytecharset, one of them has > not a useful gui. > > Greetings from Germany > Anne Try DBTools Manager Professional at http://www.dbtools.com.br/EN/downloads. It is very popular in the Open Sourced databases community (It supports many database engines). Its features can be compared with a mix of MSSQL Server Enterprise Manager and MSAccess. It has a datasheet view to edit table data with the following features: - Capabilities for data paging: very good if your table has millions of data - Capabilities to show images from blob fields as well as import/export binary content - Edit/Save, Filter and Order field capabilities - Can be exported to HTML, XML, CSV and MSAccess PS: For Windows only. Check the page http://www.dbtools.com.br/EN/dbmanagerpro for a full list of features. Best Regards, COS > > -- > GMX Produkte empfehlen und ganz einfach Geld verdienen! > Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner >
Re: [sqlite] Charset-Confusions
I am writing as the author of SQLiteSpy: SQLiteSpy does not currently does not allow editing field values in the display grid. However, this is planned for a future version. You have asked "How is it so complicated? *hmmm*" Well, because SQLite does not have an interface to save values back to the database for any arbitrary select statement. In order to update a cell, its database, table, column, and row must be determined, which is unfortunately not always possible, for example if the query does not contain the RowID as part of its result set. Then SQLiteSpy would have to modify the query, and so on. I wish there was a function like long long int sqlite3_column_rowid(sqlite3_stmt*, int iCol); which returns the RowID for the field. This could then be used to build reliable update statements (see my other post to this list). Regards, Ralf >> You should try Ralf Junker's SQLiteSpy (see >> http://www.zeitungsjunge.de/delphi/sqlitespy/index.htm). I use it, and >> it works very well. The current version doesn't allow editing the field >> values in the display grid, but I think he has said that he is working >> on that feature. > >Thanks for your answer. I found SQLiteSpy in Web and first time >it seems to works very well. But I cannot edit Cells in Grid. >And the Edit-Area below is editable, but dont save the changes >to cell. I dont found some references how to do. >Indeed, thats curious. No one of the found Admintools can edit a > >Cell-Value directly in the Cell. I think, edit directly in Cell and >dont ask "Do you want to save the changes?" is simplest way to do this. >Most time, i know exactly, what I want to edit and save. >How is it so complicated? *hmmm*
Re: [sqlite] Charset-Confusions
Hi Dennis > --- Ursprüngliche Nachricht --- > Von: Dennis Cote <[EMAIL PROTECTED]> > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Charset-Confusions > Datum: Mon, 15 May 2006 14:55:19 -0600 > > You should try Ralf Junker's SQLiteSpy (see > http://www.zeitungsjunge.de/delphi/sqlitespy/index.htm). I use it, and > it works very well. The current version doesn't allow editing the field > values in the display grid, but I think he has said that he is working > on that feature. Thanks for your answer. I found SQLiteSpy in Web and first time it seems to works very well. But I cannot edit Cells in Grid. And the Edit-Area below is editable, but dont save the changes to cell. I dont found some references how to do. Indeed, thats curious. No one of the found Admintools can edit a Cell-Value directly in the Cell. I think, edit directly in Cell and dont ask "Do you want to save the changes?" is simplest way to do this. Most time, i know exactly, what I want to edit and save. How is it so complicated? *hmmm* Best regards, Anne -- GMX Produkte empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
Re: [sqlite] Charset-Confusions
[EMAIL PROTECTED] wrote: An the 2. question: Is there any Really-Good-Admin-Tool to create DB and Table, to browse and maybe edit Fieldvalues in a grid? I have found 4 Admin-Programms. Some of them cannot open Version 3, some cannot differ Unicode and Multibytecharset, one of them has not a useful gui. Anne, You should try Ralf Junker's SQLiteSpy (see http://www.zeitungsjunge.de/delphi/sqlitespy/index.htm). I use it, and it works very well. The current version doesn't allow editing the field values in the display grid, but I think he has said that he is working on that feature. HTH Dennis Cote
RE: [sqlite] Charset-Confusions
I can't comment on Anne's situation, but I too think there is something funny going on with charsets because of one small data point: I open and use a database using the '16' APIs (ie sqlite3_open16, sqlite3_prepare16, etc). When I tried to run an EXPLAIN QUERY PLAN statement (like "EXPLAIN QUERY PLAN SELECT id FROM LIST WHERE test=1" just as an example) using my typical prepare16, step16, etc code, I'd always get back an empty result. However, if I run the identical statement with sqlite3_exec (NOT the 16 version) the results came back as expected. After figuring this out I just worked around the problem, but it makes me think there might be something there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 15, 2006 1:45 PM To: sqlite-users@sqlite.org Subject: [sqlite] Charset-Confusions Hi I have some confusion again. I have create the same Database 4 times and after that perform Insert some records. I dont change the SQL-Commands. 1. Compiler-Option Unicode and run "sqlite3_exec()" 2. Compiler-Option Multibyte and run "sqlite3_exec()" 3. Compiler-Option Unicode and run "sqlite3_prepare()" 4. Compiler-Option Multibyte and run "sqlite3_prepare()" Create Table and Insert Records works fine with sqlite3_prepare() on both charsets. I got no problems with write and followed read the written records and there field-values. Create Table first, Insert and followed Select to fetch Data works also fine with sqlite3_exec() if i define Multibyte. But the results are unusable, if i define Unicode (only German Umlauts). I have a look in SQLite-Source and found, that sqlite3_exec() after some lines self perform a Call to sqlite3_prepare(). If i dont need the Callback-Funtionality, can i start in my App directly sqlite3_prepare() instead sqlite3_exec() and get the same Result for "Inserts" and "Updates" (only)? An the 2. question: Is there any Really-Good-Admin-Tool to create DB and Table, to browse and maybe edit Fieldvalues in a grid? I have found 4 Admin-Programms. Some of them cannot open Version 3, some cannot differ Unicode and Multibytecharset, one of them has not a useful gui. Greetings from Germany Anne -- GMX Produkte empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
[sqlite] Charset-Confusions
Hi I have some confusion again. I have create the same Database 4 times and after that perform Insert some records. I dont change the SQL-Commands. 1. Compiler-Option Unicode and run "sqlite3_exec()" 2. Compiler-Option Multibyte and run "sqlite3_exec()" 3. Compiler-Option Unicode and run "sqlite3_prepare()" 4. Compiler-Option Multibyte and run "sqlite3_prepare()" Create Table and Insert Records works fine with sqlite3_prepare() on both charsets. I got no problems with write and followed read the written records and there field-values. Create Table first, Insert and followed Select to fetch Data works also fine with sqlite3_exec() if i define Multibyte. But the results are unusable, if i define Unicode (only German Umlauts). I have a look in SQLite-Source and found, that sqlite3_exec() after some lines self perform a Call to sqlite3_prepare(). If i dont need the Callback-Funtionality, can i start in my App directly sqlite3_prepare() instead sqlite3_exec() and get the same Result for "Inserts" and "Updates" (only)? An the 2. question: Is there any Really-Good-Admin-Tool to create DB and Table, to browse and maybe edit Fieldvalues in a grid? I have found 4 Admin-Programms. Some of them cannot open Version 3, some cannot differ Unicode and Multibytecharset, one of them has not a useful gui. Greetings from Germany Anne -- GMX Produkte empfehlen und ganz einfach Geld verdienen! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner