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 :
Code: Select all
UniTable1.Insert;
UniTable1.FieldByName('FName').AsString := '';
UniTable1.FieldByName('FFamily').AsString := '';
...
UniTable1.Post;
Now the problem is MyField has no value in DBGrid untile TUniTable reactivated !
If you try to Edit Table like this :
Code: Select all
UniTable1.Edit;
...
UniTable1.Post;
All Computed fields has this problem, what goes wrong ?