Re: [sqlite] problem with INSERT after ALTER TABLE ... ADD COLUMN ... DEFAULT ... performed on source table

On 04/26/2014 05:23 AM, Hinrichsen, John wrote: Default non-NULL values copied from a column that was added using "ALTER TABLE ... ADD COLUMN ... DEFAULT ..." are inserted into another table as NULLs when copied using "INSERT INTO ... SELECT * FROM ..." However, the same values are propagated

[sqlite] problem with INSERT after ALTER TABLE ... ADD COLUMN ... DEFAULT ... performed on source table

Default non-NULL values copied from a column that was added using "ALTER TABLE ... ADD COLUMN ... DEFAULT ..." are inserted into another table as NULLs when copied using "INSERT INTO ... SELECT * FROM ..." However, the same values are propagated correctly when "CREATE TABLE ... AS SELECT * FROM

Re: [sqlite] Problem with insert

ions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Bageesh.M.Bose [bageesh...@gmail.com] Sent: Friday, April 27, 2012 6:25 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Proble

Re: [sqlite] Problem with insert

Thanks for your suggestion.. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with insert

On 27 Apr 2012, at 12:36pm, Bageesh.M.Bose wrote: > so how can i do thai in c? > can you please tell me... Sorry that would be a lesson in how to manipulate text strings in C. It doesn't have much to do with SQLite. I cannot train you to be a C programmer. Simon.

Re: [sqlite] Problem with insert

so how can i do thai in c? can you please tell me... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with insert

On 27 Apr 2012, at 12:25pm, "Bageesh.M.Bose" wrote: > Thanks for your attention sir.. > > I tried ".import stock.txt myStockTable" > But in c it shows some errors... This is not a C command. It it not part of the SQLite library. It is interpreted by the shell tool

Re: [sqlite] Problem with insert

On 27 Apr 2012, at 5:58am, "Bageesh.M.Bose" wrote: > I have a file named "stock.txt" with datas seperated by "|" symbol.I want > insert these datas into a table named "stock".How can i do this in c(in > linux) with sqlite. If you want to write the program yourself, you

[sqlite] Problem with insert

I have a file named "stock.txt" with datas seperated by "|" symbol.I want insert these datas into a table named "stock".How can i do this in c(in linux) with sqlite. Please help me... -- With Regards, *Bageesh.M.Bose* ** ___ sqlite-users mailing list

Re: [sqlite] Problem with Insert Statement

Thank you so much that was the problem, you really made my day hakim On May 21, 2009, at 4:22 PM, Igor Tandetnik wrote: > Hakim TAMGALT wrote: >> The goal is to insert into the Workout table about 1000 rows in one >> shot thru a loop, my problem is as soon as it reaches 250

Re: [sqlite] Problem with Insert Statement

Hakim TAMGALT wrote: > The goal is to insert into the Workout table about 1000 rows in one > shot thru a loop, my problem is as soon as it reaches 250 the > statement crashes with the following error: > > **Terminating app due to uncaught exception >

[sqlite] Problem with Insert Statement

Hi all I need some help with SQLite Insert statement, I have a table called workout which has been created with the following definition CREATE TABLE "Workout" ("workoutId" INTEGER PRIMARY KEY NOT NULL ,"historyId" INTEGER NOT NULL ,"latitude" DOUBLE,"longitude" DOUBLE,"vert_accuracy"