Status & Roadmap
Authors & License
Funding Ultimate++
Search on this site
Search in forums

SourceForge.net Logo
Home » U++ Library support » U++ SQL » sqlite3 Custom Function in SqlExp (is it possible?)
sqlite3 Custom Function in SqlExp [message #57384] Wed, 28 July 2021 18:37 Go to previous message
JeyCi is currently offline  JeyCi
Messages: 50
Registered: July 2020
I will put a little example (see attached console project) without SqlExp.
As so as simple math functions is problematic to do (e.g. multiply 2 columns), I decided to create Custom Function for this purpose.
C.F. with #include sqlite3.h from MSYS2 32x mingw gcc 9.3 -- in addition to U++ sqlite3 plug-in; so C.F. was done in foreign lib to U++, but it works in Sql sql; sql.Execute("...") U++ query
I would like to use this C.F. in U++ SqlExp Update query & to my viewpoint U++ Update is much quicker than sqlite3 SQL Update (~30 sec per 14000 records Sad plus 30sec for fixing changes in db_sqlite3 )-- as I noticed (U++ SqlExp Update was being done much quicker Rolling Eyes )... therefore I would like to make this C.F. able to be used as a part of SqlExp or inside SqlExp - in order to use it in quicker U++ Update-Select later on... preferably without Fetching (like here in example for update)
I've got away my attempts with Model for SqlExp from attached project, just left working query...
And the Question is:
Is it possible to use e.g. such C.F. in U++ SqlExp? How to make it to work? (because in my attempts I had no success) -- I'm not attaching these fault attempts
for any case: Build Method Common Options -
All static

Best regards.

[Updated on: Thu, 29 July 2021 04:44]

Report message to a moderator

Read Message
Read Message
Read Message
Previous Topic: ODBC Assertion failed
Next Topic: Using MYSQLDLL flag
Goto Forum:

Current Time: Tue Jul 23 16:53:36 CEST 2024

Total time taken to generate the page: 0.02107 seconds