Re: [gnome-db] Do you want finish in the near future?

["Vivien Malerba" <vmalerba gmail com>]

On 9/22/06, Vivien Malerba <vmalerba gmail com> wrote:
> On 9/21/06, Daniel Espinosa <esodan gmail com> wrote:
> >
> >
> > 2006/9/21, Vivien Malerba <vmalerba gmail com>:
> > > On 9/20/06, Daniel Espinosa <esodan gmail com> wrote:
> > > > You can found the follow problems:
> > > >
> > > > 1) You can't add new rows
> > > >   a) Open a Data Source or create a new one
> > > >   b) Create a new Table using the SQL console
> > > >   c) Sync with the database, you'll see your new table
> > > >   d) Open the table with the "Edit content" button
> > > >   e) You Can't Add a New Row <===
> > >
> > > If you use the gnome-db-browser program, then you can add a new row:
> > > click on the bottom left icon and you get a new row. See the attached
> > > screenshot.
> >
> > It's correct, you can add new rows if you have at least one row in the
> > table, but if you have crated a new table, when you open it you won't find
> > any row and the add new row button is disable; see the atached capture.
> >
> > > >   f) Open a SQL console and insert manualy a row
> > > >   g) Now you can Add a new Row
> > > >
> > > > 2) You can't update values in a SQLite provider (the PostgreSQL provider
> > > > works)
> > > >   a) Open a table
> > > >   b) Update a value
> > > >   c) Save the value, the value Isn't updated, the requery shows the
> > value
> > > > before the update
> > >
> > > This might an SQLite provider's bug. Can you send me the table
> > > definition and some data for that table so I can try to correct the
> > > bug?
> >
> > A simple definition (any one has the same result):
> >
> > CREATE TABLE products (id int, description string, code string);
> >
> > Becouse the problem in the Grid I add a value using:
> >
> > INSERT INTO products (id, description) VALUES (1,'Product1');
> >
> > Then you have a row (and now you can add new rows becouse the button is
> > enable, as your capture).
> >
> > Try to modify a value (in this case add a code to the existing record), the
> > Grid show the modification but when you save is returned to the value before
> > (in this case NULL for code).
> >
> > If you use the Console you can update the value using: UPDATE products SET
> > code = 'EEE330' WHERE id = 1; and just close and re-open the grid that will
> > show the new value for code in product id = 1.
>
> Right, it seems that are 2 bugs here which I'll correct ASAP.

The bugs have been corrected, it's now in CVS.

Cheers,

Vivien