Questions about filtering

[OBEXTO]

Hello,

Is it possible to filter verticaly and horizontally ?
Example : I want to include a column when the row is of type In1, but this column should be excluded from synchronization when the row is of type Different.
I see a way to do this by generating two execution blocks with two different SelectionDelegate (one for the In1 and one for the Different) so that I can modifiy the TableDifference.ResultStore.Fields between the two block generation. Is it correct to try this ?

Is it possible to modify the type of a row ?
Example : I get a row of type Different or Same but I want to delete it in the second base, according to external criterias.

Thank you for advice.

[OBEXTO]

I tried what I mentionned before, but I have a serious problem.

I use this method http://labs.red-gate.com/index.php/Vertical_SQL_Filter to remove a FieldPair.

Why is this code nearly the same as here http://labs.red-gate.com/index.php/Vertical_Results_Filter ?
The links mention Fields.Remove and FieldMapping.Remove here http://labs.red-gate.com/index.php/Filtering_data_overview

Then I use this method to filter the rows : http://labs.red-gate.com/index.php/FilterSQLExample

Now the result I get.
If I have a table with 3 columns A, B, C and I want to exclude B from insertion scripts, the script generated is :
INSERT(A, C) -- OK here
VALUES(a, b, c) -- a problem here

For update, it is even worth because the values are shifted, and there is not necessraly an error :
UPDATE T
SET A = a,
B = c
...

Any advice and workaround ?


Thanks

[OBEXTO]

Trying to generate my own scripts I think I pointed out something.
Removing a FieldPair from the StoreFields change the content of the reader (a row doesn't contain values for the removed KeyPair).
Unfortunatly, it seems that the OrdinalInResults1 are not relocated.

[Brian Donahue]

Using the sample databases (WidgetStaging, WidgetProduction) and the "horizontal filter example" and adding the vertical filter by inserting the following lines after line #46

[OBEXTO]

I probably made a mistake reporting the issue with Insert. I have about 50 columns so maybe I didn't see that one was removed at the end. I focused on the fact that values were shifted.

If there is a bug to correct, there is no emergency as I wrote my own scripts (quite simple scripts) to meet our requirements.

Thanks.

[Brian Donahue]

Thanks! Our internal reference number for this bug (if it is a bug) is CSD-129.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521