[sqlite] Re: Re: End of Search Notification to Collation function

2007-09-30 Thread Igor Tandetnik
RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: Subject: Re: Re: End of Search Notification to Collation function i have one new collation function TestEq. I register this with sqlite. Also provide a context structure. Now i write query as below, select * from table where col = 'xxx' collate Tes

Re: [sqlite] Re: End of Search Notification to Collation function

2007-09-30 Thread RaghavendraK 70574
Hi, its like this, i have one new collation function TestEq. I register this with sqlite. Also provide a context structure. Now i write query as below, select * from table where col = 'xxx' collate TestEq and col2='xxx' collate TestEq and col3='xxx' collate TestEq; Now in the TestEq impl i

Re: [sqlite] C API trouble

2007-09-30 Thread Andrew Sledge
Hi Mike, That did the trick. I am new to C, but I have used SQLite in Perl and Python. Thanks!* List: sqlite-users Subject:Re: [sqlite] C API trouble From: "Mike Polyakov" Date: 2007

Re: [sqlite] C API trouble

2007-09-30 Thread Mike Polyakov
Besides the unneded function calls, and a lot of checks for valid data, the problem here is that you have to copy data using memcpy or somthing similar: instead of chCommand = (const char*)sqlite3_column_text(ptrSel,2); do memcpy(chCommand, sqlite3_column_text(ptrSel,2), sqlite3_column_bytes(ptr

[sqlite] C API trouble

2007-09-30 Thread Andrew Sledge
Hi, first off thank you to all of the regulars who have made my life easier :). I have a C program that pulls data from a SQLite3 database into a variable and then uses that data to do other things. However, when I iterate through the returns (no matter how many) the data never gets outside of my

[sqlite] Re: End of Search Notification to Collation function

2007-09-30 Thread Igor Tandetnik
RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: Can any suggest a way to notify collation function "end of search" from control algorthim? What for? What exactly are you trying to achieve? Igor Tandetnik - To unsubscr