Monday, March 21, 2011 10:18 PM
Since I used FilterClause, delete statement won't apply to the synchronized database. By looking to the xxx_selectchanges statement, I don't understand why the query applies the filterclause to the select, the corresponding entry is deleted...
Here is the filterclause :
- lTable.FilterClause = "[base].[NO_SYNCHRO] = 0"
Here is the select statement of selectchanges stored procedre :
([base].[NO_SYNCHRO] = 0) OR
AND [side].[NO_SYNCHRO] IS NULL
As you can see, the where clause use the filter on NO_SYNCHRO column.
Did I write a wrong filterclause ?
Monday, March 21, 2011 11:21 PMModerator
try the filter on the tracking table instead:
e.g. able.FilterClause = "[side].[NO_SYNCHRO] = 0"
you're filtering on the base table, if the row has been deleted, then its no longer in the table and thus there is nothing to filter.
- Marked As Answer by David Chanussot Thursday, March 24, 2011 10:04 PM
Thursday, March 24, 2011 10:04 PM
Great solution, works fine !
Thank a lot :)