SQLite - UDF with Delphi

[fripsy]

Hi All,

I'm trying to create a UDF for SQLite3 with Zeos 6.6.1 Beta in Delphi 7.
I've searched this forum and found these threads:

http://zeos.firmos.at/viewtopic.php?t=1746
http://zeos.firmos.at/viewtopic.php?t=1669

but due to the lack of knowledge on my part, I can't find a way to make this work.

I would like to implement a UDF to be able to search the db for "exotic" characters (like é, è ô, ...) with the standard ASCII chars (e, o, ...).

If someone could point me in the right direction this would be very helpfull.

Thanks,
Frank

[fripsy]

After searching for hours I managed to get the right syntax to start testing....

But, sadly, the "GetPlainDriver.CreateFunction" always returns "SQLITE_MISUSE" as the function itself isn't implemented...

Will now investigate the latest stable Zeos source to see if it is implemented there...

Stay tuned.

....

In 6.6.5 stable it isn't either...

[oblossom]

thanks

[DremLIN]

It's working?

Please give me working example for use UDF with Zeos & SQLite.