[fpc-pascal] fpc and Sqlite UDF

[Luiz Americo Pereira Camara]

Nataraj S Narayan escreveu:
> Luiz
>
> Got it compiled for arm after putting libsqlite in proper path. Getting this:-
>
> # ./testfunction
>
> ./testfunction: can't resolve symbol 'dl_iterate_phdr'
>   

I have no clue what's the problem. Maybe someone else can help

> BTW, this function should be compiled to a lib.so  first? Then call it
> in a trigger ?
>   

No.

In the example a custom function (strftime) is registered with 
sqlite3_create_function.
After this you can call in a Select. (See example in the same file).

So the only thing that you need is to call sqlite3_create_function in 
the start of your program with the correct parameters.

Luiz