Caluctaled Fields Not Inserting into DB

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
Daniels
Posts: 4
Joined: 2015-04-27 22:33

Caluctaled Fields Not Inserting into DB

Post by Daniels » 2020-04-12 18:31

Hello,

I am new to SQL statements, I am trying to use a calculated field, and then access the results in the database. However the results don't post to the db, they show up in the appgini app, however the results are not saved into the DB.


Do I need to ad an insert or update into the SQL statement?

Thanks?

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Caluctaled Fields Not Inserting into DB

Post by pbottcher » 2020-04-12 20:00

Hi,

as the name says, they are calculated. So think about a datefield of now - 3 days. What would you expect in the database?
The app calculates them at runtime.
Not verified, but seems logical (to me :-) )
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

Post Reply