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

Reply via email to