Page 1 of 1

SQLite - UDF with Delphi

Posted: 15.10.2009, 12:00
by 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

Posted: 16.10.2009, 09:27
by 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...

Posted: 07.06.2010, 02:06
by oblossom
thanks :)

Posted: 06.10.2010, 02:48
by DremLIN
It's working?

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