U++ forum: Welcome to the forum

Re: sqlite3 Custom Function in SqlExp [message #57385 is a reply to message #57384]

Wed, 28 July 2021 19:58

JeyCi
Messages: 67
Registered: July 2020

Member

JeyCi wrote on Wed, 28 July 2021 18:37

As so as simple math functions is problematic to do (e.g. multiply 2 columns), I decided to create Custom Function for this purpose.
...
to use it in quicker U++ Update-Select later on... preferably without Fetching

sorry to hurry with this topic - in my final project everything works as I desired - without C.F., normal multiplication, & Update OK in SqlExp

 	it* Update(j)(IT, Case(t == "C", (f*k)-s) \
           (t == "P", s-(f*k)));

- with appropriate SqlIds...
- Smile

my real problem is solved
p.s.
in any case:
let the example of C.F. just be in mind...

Best regards.

[Updated on: Wed, 28 July 2021 20:13]

Report message to a moderator