Re: [sqlite] Crash after add column

[a1rex]

- Original Message 

>From: VasiliyF4 
>After I try to ADD a column by run the querry "ALTER TABLE x
>ADD y NUMERIC" from my application, I can't use the data base any more. If I
>try to get or save any data at my DB it cause crash of the application.

Of course your old INSERT statements will not work anymore, since INSERT 
statement requires knowledge of all columns in the table.


  __
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Crash after add column

[a1rex]

>I try to ADD a column by run the querry "ALTER TABLE x
>ADD y NUMERIC" from my application, I can't use the data base any more.

Try this: "ALTER TABLE main.x ADD y NUMERIC" and verify by external tool that 
column x has been added.


  __
Connect with friends from any web browser - no download required. Try the new 
Yahoo! Canada Messenger for the Web BETA at 
http://ca.messenger.yahoo.com/webmessengerpromo.php
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Crash after add column

[A.]

On Sat, 2010-03-06 at 23:39 -0800, VasiliyF4 wrote:
> I Use C/Linux. After I try to ADD a column by run the querry "ALTER TABLE x
> ADD y NUMERIC" from my application, I can't use the data base any more. If I
> try to get or save any data at my DB it cause crash of the application.

Could you provide us with some reproducible steps?

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

[sqlite] Crash after add column

[VasiliyF4]

Hi.
I Use C/Linux. After I try to ADD a column by run the querry "ALTER TABLE x
ADD y NUMERIC" from my application, I can't use the data base any more. If I
try to get or save any data at my DB it cause crash of the application.
Thanks
-- 
View this message in context: 
http://old.nabble.com/Crash-after-add-column-tp27809597p27809597.html
Sent from the SQLite mailing list archive at Nabble.com.

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