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