Hi, Try
DELETE FROM ticket WHERE ticket.FIELDNAME =102 Regards Denis On 08/22/2008 09:02 AM, jojobo wrote: > hello. > I am not a coder so I aplogise for my naivety. I am using TRAC with a sqlite > db called trac.db > > I have the commanline sqlite3.exe in the same folder as the .db and need to > now manipulate the db to manually remove a corrupt record. > > Once opened sqlite2 shows: > > sqlite> > > I need to know the commnad / string / line to remove remoce the effected > ticket (record) from the ticket table. > > Can someone please help me with the terminogoly? > > I tried: .tables to show trables but nothing happens > I tried DELETE FROM ticket WHERE 102 > > I think I am missing the boat here...is there an easy way to show the tables > / database as text so I can manually remove problem? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
