U++ framework: U++ SQL » How to create a sqlite3 function

Home » U++ Library support » U++ SQL » How to create a sqlite3 function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create a sqlite3 function [message #22084]

Wed, 17 June 2009 02:10

bushman
Messages: 134
Registered: February 2009

Experienced Member

I need to create a sqlite function to use regexp in a SELECT/WHERE clause so that I can boost my db search capabilities. After a quick search using TheIDE->Assist->Assist, I found the function 'sqlite3CreateFunc' definition, which I guess is the UPP version for the sqlite3 'sqlite3_create_function' (is it? - see http://www.sqlite.org/c3ref/create_function.html).

I'm getting the following error when I try to use the 'sqlite3CreateFunc':
error C2039: 'sqlite3CreateFunc' : is not a member of '`global namespace''

I would appreciate if you could help me to make it work, i.e., can you give me a couple code lines on how to do it? I mean, how to use the sqlite3CreateFunc? Have I missed the inclusion of some header file? How do I point to my regexp() function so that sqlite3 can use it?

Thanks!

Report message to a moderator