[sqlite] Re: User function in WHERE clause

2006-07-28 Thread Igor Tandetnik
Stan <[EMAIL PROTECTED]> wrote: Thanks for answer. Yes, I have read this many times, but... ...I'm dumb maybe. I understand first 5 parameters in the "sqlite3_create_function". xStep and xFinal will be NULL. But there are my problems: 1) Return value xFunc is void? I have to return integer.

[sqlite] Re: User function in WHERE clause

2006-07-28 Thread Igor Tandetnik
Stan <[EMAIL PROTECTED]> wrote: Thanks for tip. I'm happy to see it's possible. Alas, I'm rather confused. I have read documentation, but I'm not sure what parameters to use What parameters your function needs to take depends entirely on what said function is supposed to do. and what

RE: [sqlite] Re: User function in WHERE clause

2006-07-27 Thread Robert Simpson
> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 7:48 AM > To: SQLite > Subject: [sqlite] Re: User function in WHERE clause > > Stan <[EMAIL PROTECTED]> wrote: > > is there a way to create user funct

[sqlite] Re: User function in WHERE clause

2006-07-27 Thread Igor Tandetnik
Stan <[EMAIL PROTECTED]> wrote: is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. Not like this, but you can create a function and use it this way: SELECT