02-20-2019 07:37 AM - edited 02-21-2019 04:43 AM
I have added a SQLTrigger to update a field from other table.
<Entity.Triggers> <SqlTrigger Id="updateSQL" Method="AfterSave,AfterUpdate" Sql="UPDATE car SET car_last_inspection=(select max(ins_date_inspection) from inspection_car WHERE car_num=456789) WHERE car_num='456789'"/> </Entity.Triggers>
It works well, I can see the correct value on database aftersave/afterupdate, but the problem is that it doesn't synchronize on App.
I also try to update the revisionfield on database but it doesn’t synch until I restart the app.
Is it possible to force synchronization to update database values to SQLite? Or execute the trigger in SQLite database also?
If it's no possible, how can I update a value from another Entity? (ForeignEntity doesn't work for me)
Does anyone know how can I achieve this?
If there is a better wat to do that please let me know..
Thank you very much!
05-15-2019 03:45 AM
We've seen on the new version details (0.6.95) there is an improvement on this topic:
Is there already a way to do this automatically without pull-to-refresh each time?
Thank you very much