I am sorry that I can not provide any sample records of the table because every time I acces the table sqlite will crash.
exceute sql: select * from carimages limit 0,1; OK! exceute sql: select * from carimages limit 1,1; OK! exceute sql: select * from carimages limit 2,1; CRASH!! Maybe the database has been damaged. The shcema of table "CarImages" is : CREATE TABLE CarImages( CarID char(32) NOT NULL, CarNumber char(20) NULL, OpTime datetime NOT NULL , TSCode char(6) NOT NULL, LaneNum int NOT NULL, PicBigPlate Long null, PicSmallPlate Long null, PicBlackWhitePlate Long null, PicLane Long null, Constraint CarImages_Key Primary Key (CarID) ); ----- Original Message ----- From: "Dennis Cote" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, May 14, 2008 9:50 PM Subject: Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation > [EMAIL PROTECTED] wrote: >> When I execute sql statement "delete from Carimages where OpTime >> <'2008-05-01 00:00:00'" in my database, sqlite3 crashed. >> The Exception Information reported by XP is: >> Code: 0xc0000005 Flags:0x00000000 >> Record: 0x0000000000000000 Address: 0x0000000000406652 >> >> The sqlite3.exe is downloaded from http://www.sqlite.org/sqlite-3_5_8.zip >> The database file is to big ( about 600M, after compressed by WinRAR, the >> size is 18M), so I can't upload here. > > Please don't hijack other threads. > http://en.wikipedia.org/wiki/Thread_hijacking > > What is the schema of Carimages table? Can you provide a couple of > sample records instead of the entire database? > > Dennis Cote > _______________________________________________ > 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