View Issue Details

IDProjectCategoryView StatusLast Update
0004226SymmetricDSBugpublic2020-01-06 21:33
ReportertmdoitAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.11.3 
Target VersionFixed in Version 
Summary0004226: Table trigger configuration - Sync on Insert/Delete/Update Condition, wrong Sync Condition example
DescriptionIn docs is "Sync Conditions can access both old values and new values of a field/column using "old_" and "new_" respectively. [...]". It's not true, you can get values by accessing tables "inserted." and "deleted.".
Additional InformationI'm almost sure. :)
TagsCondition, trigger

Activities

tmdoit

2020-01-06 21:33

reporter   ~0001674

Now I read from docs: "On SQL-Server it is added to the "WHERE" clause of a query for inserted/deleted logical tables. See Sync Condition Example.".
Maybe update docs to smth like:
Sync Condition Example
Sync Conditions can access both old values and new values of a field/column using "old_" and "new_" respectively (for MSSQL it is "deleted." and "inserted."). For example, if your column is id and your condition checks the value coming in to be 'test', your condition will be:
[...]

Issue History

Date Modified Username Field Change
2020-01-02 19:53 tmdoit New Issue
2020-01-02 19:53 tmdoit Tag Attached: trigger
2020-01-02 19:53 tmdoit Tag Attached: Condition
2020-01-06 21:33 tmdoit Note Added: 0001674