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 need to know the column for which am doing the comparison. Now most would suggest have different functions,but thats not possible because table creation and ppl writing the query is dynamic (not controlled by me). I can only bundle my TestEq function and provide api desc abt what it does. End users would club it as above in the sql statement and use it. So is there a way to get column information for which am running the collate function? it is logical to have the column names as part of the collate function. Second Part: Collate function needs a end of search notification,as Collate function can do a re-drill down or up based on the saved context. All these increases the performance as it happens within sqlite boundary. regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ***************************************************************************************** ----- Original Message ----- From: Igor Tandetnik <[EMAIL PROTECTED]> Date: Sunday, September 30, 2007 6:41 pm Subject: [sqlite] Re: End of Search Notification to Collation function > 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 unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------- > --------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
