[sqlite] Updating sqlite3 in anaconda

Hi, Can someone point me to the instructions for updating sqlite3 in an anaconda install? I have the .dll but I do not know how to create the .pyd file. I think all I need to do is copy these two files? Thanks ___ sqlite-users mailing list sqlit

[sqlite] Fwd: [SpatiaLite-Users] using spatialite on C# VS2008 SP1, Windows7 64 bit

iteCommand cmd, CommandBehavior behave) System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() ConsoleApplication1.Program.ExecuteStatement(String statement, SQLiteConnection connection) file C:\Users\Mitch\Desktop\TEST \ConsoleApplication1\ConsoleApp

[sqlite] Protecting the database (revisited)

I remember someone talking about something that could be changed at compile time to prevent other sqlite DLLs from seeing the database file as valid.. I tried to find the original message but wasn't able to.. Can someone clue me in? I know it wont offer a whole lot of protection but I'm just want

[sqlite] Select as a column

Again I find myself spoiled by PostgreSQL and it's nifty rewriting.. I'm trying to do this in SQLite : SELECT *,(SELECT count(*) FROM invoice_master WHERE invoice_master.customer_id = customers.customer_id) FROM customers as; It's giving me "no such column: customers.customer_id" and I underst