470,810 Members | 880 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

pysqlite

hi all,

I need to be able to flash a database with the sql def'ns I have, and it
works if I pipe my file into sqlite, but when I execute the same data as
a giant string I get no error, but the database isn't flashed.

anyone have any ideas ? Ive tried stripping out newlines, all whitespace
reduced to single spaces etc etc ...

--
Dave Harrison
Nullcube
da**@nullcube.com
http://www.nullcube.com

Jul 18 '05 #1
2 1687
Dave Harrison wrote:
I need to be able to flash a database with the sql def'ns I have, and it
works if I pipe my file into sqlite, but when I execute the same data as
a giant string I get no error, but the database isn't flashed.

anyone have any ideas ? Ive tried stripping out newlines, all whitespace
reduced to single spaces etc etc ...


Did you commit() before closing the connection?

Peter

Jul 18 '05 #2
On Sun, 28 Mar 2004 21:59:35 +1000,
Dave Harrison <da**@nullcube.com> wrote:
I need to be able to flash a database with the sql def'ns I
have, and it works if I pipe my file into sqlite, but when I
execute the same data as a giant string I get no error, but the
database isn't flashed. anyone have any ideas ? Ive tried stripping out newlines, all
whitespace reduced to single spaces etc etc ...


Is there a final newline on the string?

Regards,
Heather

--
Heather Coppersmith
That's not right; that's not even wrong. -- Wolfgang Pauli
Jul 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Martin Maney | last post: by
6 posts views Thread by Rob Cowie | last post: by
1 post views Thread by DurumDara | last post: by
14 posts views Thread by Nader Emami | last post: by
5 posts views Thread by =?ISO-8859-1?Q?Gerhard_H=E4ring?= | last post: by
4 posts views Thread by Tilman Kispersky | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.