Oracle.Data.Client vs. System.Data.OracleClient
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Using an SQL statement under the dataset / table adapter code as follows (overwritten via the Fill to the following): With IQ as (SELECT BOM_REF_KEY, DESCRIPTION, BOM_REVIEWED, COMMENTS FROM SAPRCM.RCM_MRO_BOM a)Select a.BOM_REF_KEY, a.DESCRIPTION, a.BOM_REVIEWED, a.COMMENTS, 0 as MatchType from IQ a Where BOM_REF_KEY in (Select BOM_REF_KEY from SAPRCM.RCM_MRO_BOM_MAT b where material_key in (Select material_key from SAPRCM.RCM_MRO_RSPL where source_key = parent_source_key and ConCat(ConCat(ConCat(manufacturer, item_manu_model), '*'), NVL(item_part_no, '')) = 'CCI THERMAL TECHNOLOGIESGX108C*')) yeilds different results from microsoft version for some reeason (ends up to be 0 records whereas it should have been higher).