what better way to work with cached updates when I have triggers and procedures using firebird?
what better way to work with cached updates when I have triggers and procedures using firebird?
Hello everyone. what better way to work with cached updates when I have triggers and procedures that I need to capture values of them using firebird?
Re: what better way to work with cached updates when I have triggers and procedures using firebird?
Please specify the essence of your question in more detail. Your current question is very extensive and can affect both the functionality of our components and the principles of working with databases.
Re: what better way to work with cached updates when I have triggers and procedures using firebird?
right. I would like to know how best to work with firebird using cached updates when I need to retrieve certain values from procedures.
I have a value recalculation procedure that with each item insertion I do the calculation, I would like to know how to do it, if the procedure is going to fetch all the time in the bank, and the procedure calculates values in the item table, or I will have to use I calculate via code myself?
I have a value recalculation procedure that with each item insertion I do the calculation, I would like to know how to do it, if the procedure is going to fetch all the time in the bank, and the procedure calculates values in the item table, or I will have to use I calculate via code myself?
Re: what better way to work with cached updates when I have triggers and procedures using firebird?
For a quicker response, please compose a small sample demonstrating the specified behavior and send it to us using the contact form https://devart.com/company/contactform.html, including scripts for creating and filling database objects.
Re: what better way to work with cached updates when I have triggers and procedures using firebird?
What I supose. Is how to refresh data from the server after the changes are posted.
For example you have some fields in a table record, which values are calculated and updated to the table record at serverside on a trigger, via inside the same trigger or that trigger call a procedure.
So what he means is how to refresh those fields after a posting records (beause it can be more than one record sent to the server) to the server (applyupdates) in a dataset which has CachedUpdates := true.
For example you have some fields in a table record, which values are calculated and updated to the table record at serverside on a trigger, via inside the same trigger or that trigger call a procedure.
So what he means is how to refresh those fields after a posting records (beause it can be more than one record sent to the server) to the server (applyupdates) in a dataset which has CachedUpdates := true.
Re: what better way to work with cached updates when I have triggers and procedures using firebird?
To return the value of field value generated on the server-side, you should set the TUniQuery.DMLRefresh property to True. See more details about this property in the UniDAC help: https://devart.com/unidac/docs/index.ht ... efresh.htm