Page 1 of 1

Caluctaled Fields Not Inserting into DB

Posted: 2020-04-12 18:31
by Daniels
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?

Re: Caluctaled Fields Not Inserting into DB

Posted: 2020-04-12 20:00
by pbottcher
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 :-) )