Нужно добавить для определенных 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м ЭТАКСе).