Re: [sqlite] Long table fails to create with exec sql on windows 8.1

Good catch, thank you! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Donald Griggs Sent: Thursday, April 24, 2014 8:20 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Long table fails to create with exec

Re: [sqlite] Long table fails to create with exec sql on windows 8.1

Hello Mark, >>System just stops responding. It's not clear if you're talking about the program or your PC. If the PC is hanging, it's broken and this isn't a software problem (well not a Sqlite problem). Anytime a PC running windows hangs or crashes, you know it's a driver or hardware

Re: [sqlite] Long table fails to create with exec sql on windows 8.1

On 23 Apr 2014, at 10:47pm, Mark Potter wrote: > I have this table and SQL LITE crashes on windows when I try to create using > exec sql. System just stops responding. Does it crash inside the routine ? If so, can you show us a crash message of some kind ? Donald

Re: [sqlite] Long table fails to create with exec sql on windows 8.1

fyi, when I run it from sqlite3.exe on windows I get: Error: duplicate column name: SubrouteNumber You're checking returned error codes, right? > ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Long table fails to create with exec sql on windows 8.1

I have this table and SQL LITE crashes on windows when I try to create using exec sql. System just stops responding. CREATE TABLE Bridge (_id INTEGER PRIMARY KEY, StateCode INTEGER, StructureNumber TEXT, InventoryRoute TEXT, RecordType TEXT, RouteSigningPrefix INTEGER, LevelOfService