Search found 3 matches

by pastor
06.09.2017, 14:59
Forum: Lazarus / Freepascal
Topic: How can I create a user-defined function?
Replies: 4
Views: 1999

Re: How can I create a user-defined function?

Jan, thanks for the tip!

This code works:

uses ZDbcSqLite, Unit_SQLite3Dataset_LanguageSupport;
var dbHandle: Pointer;
...
dbHandle := (ZConnection1.DbcConnection as TZSQLiteConnection).GetConnectionHandle();
SQLite3Dataset_LanguageSupport(dbHandle);

Blessings..
by pastor
30.08.2017, 08:53
Forum: Lazarus / Freepascal
Topic: How can I create a user-defined function?
Replies: 4
Views: 1999

Re: How can I create a user-defined function?

Thank you, Jan! But I am using SQLite3.

I've found solution for SQLDB:

uses Unit_SQLite3Dataset_LanguageSupport;
...
SQLite3Dataset_LanguageSupport (SQLite3Connection.Handle);

But it does`t work in Zeos.
How to get a Handle of SQLite database in Zeoslib?
by pastor
28.08.2017, 13:37
Forum: Lazarus / Freepascal
Topic: How can I create a user-defined function?
Replies: 4
Views: 1999

How can I create a user-defined function?

Hi All!

How can I create a user-defined function in Zeos? I need it for making case-insensitive LIKE.

This this solution for TSQLite3Dataset but I need same for ZeosLib - http://forum.lazarus.freepascal.org/ind ... ic=34259.0

sqlite3_create_function(...