[sqlite] [Wishlist] Make RAISE function accept derived arguments

In triggers I often want to include information when raising an error. However, RAISE doesn't accept dynamic/derived arguments which would otherwise be valid in a SELECT. SELECT RAISE(ABORT, 'string1' || 'string2'); -- Error: near 'string1': syntax error Does anyone know of a

Re: [sqlite] [Wishlist] Make RAISE function accept derived arguments

On Thu Apr 24, 2014 at 09:42:20AM +0200, Mark Lawrence wrote: In triggers I often want to include information when raising an error. However, RAISE doesn't accept dynamic/derived arguments which would otherwise be valid in a SELECT. SELECT RAISE(ABORT, 'string1' || 'string2'); --

Re: [sqlite] BLOBs and NULLs

UNSUBSCRIBE ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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

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

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

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

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

[sqlite] Question about checking table requirements on INSERT into a table

Hi sqlite-users, When I was toying around with sqlite in python, I ran into an interesting caveat when INSERTing into a table where an unsupported data type didn't throw an exception/error from sqlite's perspective. In the example below, I expected an insert of a text field to an integer

Re: [sqlite] Question about checking table requirements on INSERT into a table

On 4/24/2014 1:03 PM, yaneurabeya . wrote: Being able to INSERT and print out 'a' above caught me off guard a bit. Is this programmer error when I ran CREATE TABLE or the INSERT (this is the most likely answer, but I wanted to be sure), or is this by design? By design. For details,

Re: [sqlite] Question about checking table requirements on INSERT into a table

On Thu, Apr 24, 2014 at 10:23 AM, Igor Tandetnik i...@tandetnik.org wrote: On 4/24/2014 1:03 PM, yaneurabeya . wrote: Being able to INSERT and print out 'a' above caught me off guard a bit. Is this programmer error when I ran CREATE TABLE or the INSERT (this is the most likely

[sqlite] Provider not showing up in .Net Model import wizard

First, I am a long time SQLite user, (first time on .Net). I installed the NuGet packages (the one with all 3 modules) into my C# project. I want to import an existing SQLite DB and create a Entity Data Model from it. But, when I try to generate from database, the data source and provider do

Re: [sqlite] Provider not showing up in .Net Model import wizard

Sean McBride wrote: I installed the NuGet packages (the one with all 3 modules) into my C# project. I want to import an existing SQLite DB and create a Entity Data Model from it. But, when I try to generate from database, the data source and provider do not appear in the list. None of

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] Provider not showing up in .Net Model import wizard

Thanks for your reply Joe! I think I am just not getting across exactly where I expect SQLite to show up. I am pretty sure it is supposed to be there because there are tutorials floating around that show screen shots with the SQLite source showing up where I would expect it to. For example,