Devart Forums

I have a problem with Computed Fields in SQL Server
Steps to reproduce the problem :
1. Create a new Table in SQL Server and add some fields to it
2. Create a field ( name it "MyField" ) and set a formula in the "Computed Column Specification" section of field properties like this : ([ID] + 1000) - ( ID is the auto-increment field )
3. Create a new project in Delphi, add a TUniConnection and a TUniTable
connect Table and add fields to it ( add a DBGrid to see the values )
4. Insert a record in the table : * not assign any value to Computed field (MyField);
Now the problem is MyField has no value in DBGrid untile TUniTable reactivated !
If you try to Edit Table like this : an error shown as "Record was changed by another user"

All Computed fields has this problem, what goes wrong ?

Any suggestion ?

The value of the calculated fields does not change when the record is refreshed, because they are not included in the record refresh query.
Try manually setting the refresh query for the record where there are Computed Columns:

UniTable.SQLRefresh.Text := ' SELECT FName, FFamily, MyField FROM Table WHERE KeyField = :KeyField ';

After changing the data in the database, you need to refresh the record in the dataset. You can refresh the record either manually TUniTable.RefreshRecord, or automatically by setting the RefreshOptions property of the TUniTable component when executing the refresh.
For example, refresh the record after inserting and updating:
UniTable.RefreshOptions: = [roAfterInsert, roAfterUpdate];

Refreshing the record after the change will solve the issue "Record was changed by another user".

Problem solved, thanks

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.