Some issues with Rebuid Fields Admin Area

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Some issues with Rebuid Fields Admin Area

Post by RonP » 2019-12-20 16:11

Hi,
I've some issues with a mismatch between database table fields and Appgini generated fields.
Within Admin Area you can check for consistencies however if I try to have it fixed no fixes where performed.
Especially with the SQL Views against the AppGini "tables"

What is the remedy to get all in sync?
(The data shows up well)
Ron
Attachments
RebuildFields.PNG
RebuildFields.PNG (65.99 KiB) Viewed 2595 times

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

Re: Some issues with Rebuid Fields Admin Area

Post by pbottcher » 2019-12-21 09:53

Hi Ron,

in regards to views that you created to replace the tables created in AppGini, actually there is not need real to correct the differences for the field definitions.

But if you want to do so, you need to adjust the settings in AppGini, as the view always picks the definion of the refering table(s). So if you changed something in the original table, the view will automatically pick it up, but the table that you defined in AppGini will not know about those changes unless you change the definition in AppGini as well.
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.

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Some issues with Rebuid Fields Admin Area

Post by RonP » 2019-12-21 16:46

Hi Paul,
Thanks for looking into my "problem"
If I regenerate the views I still get the discrepancy, I can live with that for the views.

Ron

Post Reply