[sqlite] Using sqlite3.exe as a subprocess

2016-01-16 Thread Matthew Allen
On 16 January 2016 at 07:16, Roger Binns wrote: > > > while p.poll() == None: resp = p.communicate() print len(resp[0]), > > resp[0] > > That code doesn't make sense. communicate waits until the process > terminates. The SQLite shell won't terminate unless it gets a quit > command, or EOF on

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Matthew Allen
It seems that sqlite3.exe (console) doesn't work as a subprocess with pipes. I've tried it with both C++ code calling the CreateProcessW win32 API and with python and both resulted in the same behaviour. Which is the sub-process doesn't return anything when I try and read it's output (just

Re: [sqlite] sqlite3_bind_text problem

2008-11-16 Thread Matthew Allen
] This is a vc6 project that compiles and produces 'Database.sqlite' in the current folder. I've zipped up the example database from my testing, but you should delete that before running the code. Thanks for any time to take to look at this, I do appreci

Re: [sqlite] sqlite3_bind_text problem

2008-11-14 Thread Matthew Allen
know I'm not doing anything obviously wrong. As I mentioned in my other response I'm building with VC6 and maybe that is part of the problem. -- Matthew Allen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_bind_text problem

2008-11-14 Thread Matthew Allen
3_bind_text(Stmt, 3, (const char*)Name, -1, SQLITE_STATIC); And it return SQLITE_OK, however the value in the DB is NULL, or an empty string. Certainly not the "Something" I pass in. All the integer fields are written successfully so I know it's mostly working. The string is valid utf-8, nul