How does one specify a string value in a SQL query for SWE? My query works in server management studio using ' to specify a string but it will not take in SWE. See my query below
SELECT DISTINCT
tew_component.com_id AS id
, tew_component.com_type AS type
, tew_component.com_tagmanual AS tagtype
, tew_component_parent.com_tag AS TagParent
, tew_component.com_tag AS TagText
, tew_component.com_tagroot AS TagRoot
, tew_component.com_tagorderno AS TagOrderNo
, tew_componentelement.cel_group AS Deck
, tew_componentelement.cel_orderno AS CelOrderNo
, 1 AS %ELEMENT_COUNT%
, tew_component.com_tagpath AS com_fulltagpath
, tew_component.com_parenttagpath AS com_tagpath
, tew_compbom.bom_articlename AS JDE_part
FROM ((tew_component LEFT JOIN tew_component AS tew_component_parent ON tew_component.com_com_id=tew_component_parent.com_id)
LEFT JOIN tew_componentelement ON tew_component.com_id=tew_componentelement.cel_com_id)
LEFT JOIN tew_location AS tew_comploc ON tew_component.com_loc_id = tew_comploc.loc_id
LEFT JOIN tew_buildofmaterial AS tew_compbom on tew_component.com_id = tew_compbom.bom_objectid
WHERE (tew_component.com_type = 3 OR tew_component.com_type = 4) AND (tew_comploc.loc_bun_id = %CUR_BUNDLE_ID%) AND (tew_component_parent.com_tag IS NOT NULL) AND (tew_compbom.bom_articlename IS NOT NULL AND tew_compbom.bom_articlename = 'PNNTT' OR tew_compbom.bom_articlename = '31991' OR tew_compbom.bom_articlename = 'PNDPT')
ORDER BY type,TagParent, TagOrderNo
SolidworksElectrical