MAILER-DAEMON írta:
> It would be helpful to post your code in order to fully understand
> what you are trying to do.
>
> Are you sure you have done this:
> http://www.sqlite.org/lang_corefunc.html#like
> "... it may be important to override both the two and three argument
> versions of the like() function."
>
With Java (and SQLiteJDBC) it is not possible to ovverride "/both /the
two and three argument
versions of the like() function". I can only ovverride the like() function:
Function.create(connection, "like", new Function() {
protected void xFunc() throws SQLException {
System.out.println("LIKE called: " + value_text(0));
// ...
}
});
It works *only with the three arguments calling*. But if I rename it to
"mylike", it works with the two arguments calling too:
SELECT * FROM table WHERE mylike(column, 'a') // works
SELECT * FROM table WHERE like(column, 'a', 'z') // works
*SELECT * FROM table WHERE like(column, 'a') // NOT works
*
Regards,
Máté.
--
„A hosszú élet titka: tiszteld a szüleidet.”
FARKAS Máté
http://fmate14.try.hu/
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
