Re: [sqlite] Simple SQLite-based spreadsheet?

[Tom Lynn]

Why not use LibreOffice or OpenOffice with the odbc driver for SQLite?

I do it with Excel a lot and just confirmed you can access it with these
open source tools, too.

On Fri, Dec 7, 2012 at 10:15 AM, Rob Richardson wrote:

> There's several GUI-based SQLite tools available now.  Maestro was already
> mentioned.  My favorite is SQLiteSpy because it's fast, even though you
> can't insert or update data in its grid view (you have to write insert or
> update queries to do that, which I admit is a pain, but most of the time
> I'm just looking at data).  There are others.  What would this new tool do
> that those don't?
>
> RobR
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] no such table error.

[Tom Lynn]

Yes, that's it!  Thanks.


On Mon, Jun 14, 2010 at 3:56 PM, P Kishor <punk.k...@gmail.com> wrote:

> On Mon, Jun 14, 2010 at 5:53 PM, Tom Lynn <t...@tomlynn.com> wrote:
> > I'm fairly new to sqlite and generally use databases with single tables
> for
> > use with my PERL scripts.  I've encountered a problem where I've tried to
> > insert data into a table named trunks and get the error "No such table:
> > main.atd_data"
> >
> > atd_data is a table that I use in a different script.  The insert
> statement
> > does not reference it whatsoever (shown below).  This error occurs
> whether I
> > execute the statement from my script or from the sqlite3 command shell.
>  I
> > cannot imagine sqlite "remembering" my other table.  Should I suspect
> some
> > kind of file corruption?
> >
> > INSERT INTO trunks ( store, trk_date, grp_num, grp_size, grp_type,
> grp_dir,
> > meas_hour, usage, seizures, inc_seizures, grp_overflow, queue_size,
> queued,
> > que_overflow, que_abandoned, out_service, percent_atb, out_block ) VALUES
> (
> > 001, '6/04/2010', 12, 24, 'tie', 'two', 1300, 0, 1, 0, 0, 0, 0, 0, 0, 0,
> 0,
> > 0);
> >
>
>
> Do you have a TRIGGER that is firing on INSERT INTO trunks, a TRIGGER
> that is trying to fiddle with main.atd_data?
>
>
> --
> Puneet Kishor
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] no such table error.

[Tom Lynn]

I'm fairly new to sqlite and generally use databases with single tables for
use with my PERL scripts.  I've encountered a problem where I've tried to
insert data into a table named trunks and get the error "No such table:
main.atd_data"

atd_data is a table that I use in a different script.  The insert statement
does not reference it whatsoever (shown below).  This error occurs whether I
execute the statement from my script or from the sqlite3 command shell.  I
cannot imagine sqlite "remembering" my other table.  Should I suspect some
kind of file corruption?

INSERT INTO trunks ( store, trk_date, grp_num, grp_size, grp_type, grp_dir,
meas_hour, usage, seizures, inc_seizures, grp_overflow, queue_size, queued,
que_overflow, que_abandoned, out_service, percent_atb, out_block ) VALUES (
001, '6/04/2010', 12, 24, 'tie', 'two', 1300, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0,
0);

Best regards,
Tom
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users