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

2014-04-24 Thread Mark Potter
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

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

2014-04-24 Thread Donald Griggs
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

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

2014-04-24 Thread Simon Slavin
On 23 Apr 2014, at 10:47pm, Mark Potter mpott...@cfl.rr.com 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 Griggs

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

2014-04-24 Thread Teg
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 problem

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

2014-04-24 Thread Mark Potter
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