[vadimus_ca]

Нужно добавить для определенных PARID (параметр) отсутствующие у них STAID (значение).
Отобрал группу по названию, указанному в etacs_suv.xml
<DiscretValue Label="@P8618-POLUXDATA" Name="Helical_2858"/>

SELECT 
  STATES.STAID,
  STATES.PARID,
  STATES.STASNAME,
  STATES.STALNAME,
  STATES.STAVALUE,
  PARAM.PARLNAME,
  STATES.STATYID,
  STATES.STADESCRIPTION,
  STATES.STAMINVALUE,
  STATES.STAMAXVALUE,
  STATES.STAGROUPNAME,
  PARAM.PARDESCRIPTION,
  PARAM.PARENCODING,
  PARAM.PARTYPE,
  PARAM.PARSNAME,
  PARAM.DATTYID,
  ADDDATA.ADDTYID,
  ADDDATA.ADDABSOLUTENUMBER,
  ADDTYPE.ADDTYNAME
FROM
  STATES
  INNER JOIN PARAM ON (STATES.PARID = PARAM.PARID)
  INNER JOIN ADDDATA ON (PARAM.PARID = ADDDATA.PARID)
  INNER JOIN ADDTYPE ON (ADDDATA.ADDTYID = ADDTYPE.ADDTYID)
WHERE
  PARAM.PARLNAME CONTAINING 'front diff' AND 
  STATES.STASNAME CONTAINING '2858'

Получил 27 параметров, по 2 значения в каждом.

STAID	PARID	STASNAME	STALNAME	STAVALUE	PARLNAME	STATYID	STADESCRIPTION	STAMINVALUE	STAMAXVALUE	STAGROUPNAME	PARDESCRIPTION	PARENCODING	PARTYPE	PARSNAME	DATTYID	ADDTYID	ADDABSOLUTENUMBER	ADDTYNAME
10433	5129	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
10434	5129	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
33506	15944	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
33507	15944	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
36747	17261	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
36748	17261	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
55348	26184	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
55349	26184	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
58721	27705	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
58722	27705	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
108126	49715	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
108127	49715	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
116217	53095	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
116218	53095	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
119310	54426	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
119311	54426	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
128139	58241	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
128140	58241	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
135925	61836	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
135926	61836	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
143423	65139	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
143424	65139	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
153858	69597	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
153859	69597	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
163722	73985	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
163723	73985	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
166232	75031	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
166233	75031	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
170172	76770	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
170173	76770	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
174542	78637	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
174543	78637	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
187013	84133	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
187014	84133	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
189701	85197	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
189702	85197	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
214821	96053	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
214822	96053	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
221232	98751	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
221233	98751	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
233810	104537	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
233811	104537	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
239909	107284	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
239910	107284	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
248545	110757	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
248546	110757	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
259623	115880	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
259624	115880	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
267902	119657	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
267903	119657	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
275804	123151	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
275805	123151	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
286749	128289	Helical_2858	Helical	0010	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS
286750	128289	Open_2858	Open	0001	Front Differential	3						ENUM		Front_Differential	0	1	-1	BITS

Вопрос к какой группе добавлять значения, а главное - нужно ли внести изменения в сам XML!

---------- Добавлено в 17:42 ---------- Предыдущее сообщение было написано в 17:32 ----------

Похоже, PARSNAME соответствует ReadParamName в XML файле.

---------- Добавлено в 21:39 ---------- Предыдущее сообщение было написано в 17:32 ----------

Сообщение от Vadgr

Что странно, после того как я вчера поменял режим омывателя, отключилось пошаговое открытие =0 я это только сегодня понял, пробовал опять с пульта - ничего не получилось, в чем причина я так и не понял =(

Потому что это опции клиента (по крайней мере на 322м ЭТАКСе).