Re: [sqlite] About Alter table add column

Hi, If you are specifing fieldnames in your statements then there won't be any problem. Means if a statement like INSERT INTO Person (ID, name , addr ) VALUES ( 10,'Yoky','India'); will not be distrubed. But if your other code contains INSERT INTO Person VALUES ( 10,'Yoky','India'); then you will

Re: [sqlite] Is this expected behavoir, or should I open a ticket?

Never mind, brain glitch. Sorry for the waste of bandwidth. Just too late on a Friday afternoon. Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Friday, February 06, 2009 4:14 PM To: sqlite-users@sq

Re: [sqlite] Is this expected behavoir, or should I open a ticket?

Noah Hart wrote: > SQL Version: 3.6.10 > > CREATE TABLE T1(a, b); > INSERT INTO T1 VALUES(C1_A, randomblob(1)); > > SQL error:no such column: C1_A > > I know that I can quote the value C1_A, but why is that necessary? Why do you believe it shouldn't be necessary? C1_A is an identifier, not a str

[sqlite] Is this expected behavoir, or should I open a ticket?

SQL Version: 3.6.10 CREATE TABLE T1(a, b); INSERT INTO T1 VALUES(C1_A, randomblob(1)); SQL error:no such column: C1_A I know that I can quote the value C1_A, but why is that necessary? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged informa

Re: [sqlite] Trying to INSERT rows into a table

Good day, I'm new to SQL lite too, but I don't see the point of reset for a one-off insert query or one that gets finalized right away. Insert has no row set, so you aren't about to reset and step through the rowset again. As always, I'm willing to be enlightened My code runs successive in

Re: [sqlite] Trying to INSERT rows into a table

Because the SDK docs tell me to. http://www.sqlite.org/c3ref/step.html " SQLITE_DONE means that the statement has finished executing successfully. sqlite3_step() should not be called again on this virtual machine without first calling sqlite3_reset() to reset the virtual machine back to its initi

Re: [sqlite] Trying to INSERT rows into a table

Why are you calling reset after step? regards, Adam On Fri, Feb 6, 2009 at 3:51 PM, Stephen Abbamonte wrote: > Hi all I am using SQLite3 and running into a bit of a snag. I have a > Database with an empty table and I am calling a series of INSERT commands > during the execution of my program bu

[sqlite] Trying to INSERT rows into a table

Hi all I am using SQLite3 and running into a bit of a snag. I have a Database with an empty table and I am calling a series of INSERT commands during the execution of my program but it seems that each call is overwriting the first row in the table. I have tried the table with and without a PRIMARY

Re: [sqlite] TRIGGER to catch UPDATES without a WHERE clause

Hi Puneet, I don't know if you can intercept a query with a trigger the way you're intending (maybe this is possible in sqlite?), but if I may make a suggestion, get in the habit of starting your every session on a crucial database with a transaction. The moment you login: sqlite> BEGIN; Take a

Re: [sqlite] Insertion and Updation using sqlite3_prepare()

I second that motion, there's a possibility here that you might be mixing up integers and strings either when you bind for the insert or when you bind for the select later to check if the insert worked! On Fri, Feb 6, 2009 at 12:22 AM, Igor Tandetnik wrote: > "hussainfarzana" > wrote in > messa

[sqlite] TRIGGER to catch UPDATES without a WHERE clause

I had asked this a while back but I think my query got Warnocked. I would like to create a TRIGGER (or a CONSTRAINT) that throws an error if an UPDATE query is run *without* a WHERE clause. This would prevent accidentally mucking up the entire database, which, believe you me, I have done more than

Re: [sqlite] How to drop table in trigger

On Feb 6, 2009, at 3:23 AM, Wenton Thomas wrote: > could anyone help me ? > The sqlite version i usedis 3.5.0. You cannot make schema changes while an SQL statement is running. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sq

[sqlite] How to drop table in trigger

could anyone help me ? The sqlite version i usedis 3.5.0. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error message This program cannot be run in DOS

Hi, The file seems to be perfect. I am sorry, I omitted some thing. Right click the ZIP file and select the "Properties" menu item and then examine the window displayed. You can see the "UNBLOCK" button on that window. Generally XP blocks the downloaded ZIP,EXE,DLL,... files and some email-attachme