Re: [sqlite] sqlite wrapper .dll - best way to store result set and expose it to user

2012-08-27 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 27/08/12 16:05, Daniel Dawson wrote: > I am writing a .dll-based wrapper for sqlite3 in C++. Many others have been down that path before. I suggest having a look at their work first. It should also be noted that the existing SQLite API can be

Re: [sqlite] sqlite wrapper .dll - best way to store result set and expose it to user

2012-08-27 Thread Simon Slavin
On 28 Aug 2012, at 12:05am, Daniel Dawson wrote: > I am writing a .dll-based wrapper for sqlite3 in C++. I recommend you study the ones already available before you reinvent the wheel. Google 'sqlite c++ wrapper'. Simon.

[sqlite] sqlite wrapper .dll - best way to store result set and expose it to user

2012-08-27 Thread Daniel Dawson
I am writing a .dll-based wrapper for sqlite3 in C++. I am planning on providing functions to do inserts and selects and other things, it is mostly centred around usability for whoever uses the .dll. For example my select function looks like this void* SQL_singleSelect(char *query,

Re: [sqlite] How to know what terms were created using FTS

2012-08-27 Thread Scott Hess
On Sat, Aug 18, 2012 at 10:00 AM, Mohit Sindhwani wrote: > On 17/8/2012 7:14 PM, Dominique Pellé wrote: >> This gives the tokens: >> >> sqlite> CREATE VIRTUAL TABLE ft USING fts4(x); >> sqlite> INSERT INTO ft VALUES("hello world"); >> sqlite> INSERT INTO ft VALUES("hello there");

Re: [sqlite] foreign keys across database boundaries

2012-08-27 Thread Kees Nuyt
On Mon, 27 Aug 2012 11:44:18 +0300, Baruch Burstein wrote: > Can foreign keys or triggers be set between ATTACHed database tables? If > so, is there any other type of statment that doesn't work across ATTACH > boundaries? Foreign keys, triggers and views cannot cross

Re: [sqlite] Fw: create table question

2012-08-27 Thread _ph_
> our Visual Studio project will not breakpoint in certain places For SQLite, this is usually caused by Visual Studio only supporting breakpoints in the first 64K lines. (VS doesn't even tell you the breakpoints don't work, they just don't get hit). -- View this message in context:

Re: [sqlite] foreign keys across database boundaries

2012-08-27 Thread Dan Kennedy
On 08/27/2012 03:44 PM, Baruch Burstein wrote: Can foreign keys or triggers be set between ATTACHed database tables? No. They can not. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] foreign keys across database boundaries

2012-08-27 Thread Baruch Burstein
Can foreign keys or triggers be set between ATTACHed database tables? If so, is there any other type of statment that doesn't work across ATTACH boundaries? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list