RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread epankoke
mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 07, 2007 12:26 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Is there a SQLiteSpy-like thing that will let me > change data from a grid? > > Hi Rob, > > You can try DBManager Standard or Enterprise Edit

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Ralf Junker
Hello Nemanja Corlija, >>PS: For anyone interested: The new SQLiteSpy with table cell editing is now >>available at http://www.yunqa.de/delphi/sqlitespy/ >Ralf, thanks SQLiteSpy. Download link is not working though. Thanks for reporting the problem. The link is now fixed and working all right.

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Kees Nuyt
On Wed, 7 Feb 2007 13:03:09 -0500, you wrote: >I can't get SQLiteExplorer to work with my databases. It always gives >me an "unknown file format" error. I believe it's been quite a while >since it was updated. > >RobR Did you download sqlite3explorer or sqliteexplorer? The latter is meant for

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Nemanja Corlija
On 2/7/07, Ralf Junker <[EMAIL PROTECTED]> wrote: PS: For anyone interested: The new SQLiteSpy with table cell editing is now available at http://www.yunqa.de/delphi/sqlitespy/ Ralf, thanks SQLiteSpy. Download link is not working though. -- Nemanja Corlija <[EMAIL PROTECTED]> ---

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Ralf Junker
Hello Robert Simpson, >For the SQLite ADO.NET wrapper, I actually wrote two functions into the core >engine to help me retrieve key information. My requirements were a little >more complex than just getting rowid, but here's what I did to get me that >far at least: > >Given a sqlite_stmt pointer

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Rob Richardson
ssage- From: COS [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 12:26 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid? Hi Rob, You can try DBManager Standard or Enterprise Editions. The first one is fr

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Rob Richardson
06, 2007 3:14 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid? Regarding: "If I want to change data ." Sqlite3Explorer is free software, and works as you describe. I imagine there are several others.

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread COS
more details see http://www.dbtools.com.br/EN/queryit. Best Regards, COS - Original Message - From: "Rob Richardson" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 06, 2007 4:49 PM Subject: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a g

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Robert Simpson
> -Original Message- > From: Robert Simpson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 07, 2007 8:25 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Is there a SQLiteSpy-like thing that will let me > change data from a grid? > > __declsp

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Robert Simpson
} else { if (pC->pCursor == NULL) return SQLITE_ERROR; sqlite3BtreeKeySize(pC->pCursor, prowid); *prowid = keyToInt(*prowid); } return 0; } > -Original Message- > From: Ralf Junker [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 07, 2007 4:23 AM &g

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Ralf Junker
>> The SQLite library lacks certain API required to implement cell >> editing: Most notably, there is no functionality to retrieve >> the exact origin (table, row and column) of a cell, which must >> be known to store back the modified value. > >See: > > http://www.sqlite.org/capi3ref.html#sqli

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread drh
Ralf Junker <[EMAIL PROTECTED]> wrote: > > The SQLite library lacks certain API required to implement cell > editing: Most notably, there is no functionality to retrieve > the exact origin (table, row and column) of a cell, which must > be known to store back the modified value. See: http://

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread Ralf Junker
Hello Rob Richardson, >The only tool I have for examining and manipulating SQLite databases is >SQLiteSpy. If I want to change data in that program, I have to write an >SQL statement. Every other database editor I've seen lets a use do >simple things from a grid. As the author of SQLiteSpy: The

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-06 Thread Kees Nuyt
On Tue, 6 Feb 2007 15:13:55 -0500, Donald Griggs wrote: >Regarding: "If I want to change data ." > >Sqlite3Explorer is free software, and works as you describe. >I imagine there are several others. I second this wholeheartedly. >http://www.singular.gr/sqlite/ (Not sure if there >will be f

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-06 Thread Griggs, Donald
Regarding: "If I want to change data ." Sqlite3Explorer is free software, and works as you describe. I imagine there are several others. http://www.singular.gr/sqlite/ (Not sure if there will be future releases of this or not) [opinions are my own, not necessarily those of my compa

[sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-06 Thread Rob Richardson
Greetings! The only tool I have for examining and manipulating SQLite databases is SQLiteSpy. If I want to change data in that program, I have to write an SQL statement. Every other database editor I've seen lets a use do simple things from a grid. Open a table and data is loaded into a grid, c