Да с данными-то всё должно быть в порядке, иначе бы и IBExpert ругался, да и на полях ограничение на уникальность и не пустоту стоит в нужных местах (в том числе и на это поле)
rlobes - это integer
Запрос (просьба, не говорить о алиасах):
- Код: Выделить всё
select
resultdata_id,
servicetest_id,
rotor_numberrt,
rotor_modification,
stator_numberst,
stator_modification,
diametretype,
lobes,
lengthtype,
assignflowrate,
statordiametremiddle-rotordiametremiddle natjagP,
statordiametremiddlev-rotordiametremiddle natjagV,
rotor_numberrt ||'-'|| CAST(rotor_modification as CHAR) rotorM,
rotorlabelcompany,
depositlabelcompany,
stator_numberst ||'-'|| CAST(stator_modification as CHAR) statorM,
statorlabelcompany,
numbert,
twaindatecreate,
sborkat,
numberaggregate,
typetest,
quality,
datetest
from
(
select
resultdata.ResultData_id resultdata_id,
resultdata.assignflowrate,
servicetest.ServiceTest_id servicetest_id,
servicetest.datetest,
typeservicetest.typetest,
quality.quality,
aggregate.sborkat,
aggregate.numberaggregate,
workertwain.numbert,
workertwain.labelt,
rotor.producer_id rotorproducer_id,
modificationofrotor.currentproducerofdeposit_id depositproducer_id,
stator.producer_id statorproducer_id,
rotorproducer.labelcompany rotorlabelcompany,
depositproducer.labelcompany depositlabelcompany,
statorproducer.labelcompany statorlabelcompany,
modelofrotor.dimensiontype_diametretype diametretype,
modelofrotor.dimensiontype_lengthtype lengthtype,
CAST(modelofrotor.rlobes as CHAR) || '/' || CAST(modelofrotor.rlobes+1 as CHAR) lobes,
/* modelofrotor.rlobes lobes,*/
modificationofrotor.modification rotor_modification,
modificationofstator.stator_numberst,
modificationofstator.modification stator_modification,
modificationofrotor.diametremiddle rotordiametremiddle,
modificationofrotor.rotor_numberrt,
modificationofstator.diametremiddle statordiametremiddle,
modificationofstator.diametremiddlev statordiametremiddlev,
workertwain.twaindatecreate
/
from servicetest
inner join workertwain on (workertwain.workertwain_id = servicetest.workertwain_id)
left join aggregate on (workertwain.workertwain_id = aggregate.workertwain_id)
inner join resultdata on (servicetest.ServiceTest_id = resultdata.servicetest_id)
inner join modificationofrotor on (workertwain.modificationofrotor_id = modificationofrotor.ModificationOfRotor_id)
inner join rotor on (modificationofrotor.rotor_numberrt = rotor.numberrt)
inner join modelofrotor on (rotor.modelofrotor_id = modelofrotor.modelofrotor_id)
inner join modificationofstator on (workertwain.modificationofstator_id = modificationofstator.ModificationOfStator_id)
inner join stator on (modificationofstator.stator_numberst = stator.numberst)
inner join modelofstator on (stator.modelofstator_id = modelofstator.modelofstator_id)
inner join typeservicetest on (servicetest.typeservicetest_id = typeservicetest.TypeServiceTest_id)
inner join quality on (servicetest.quality_id = quality.Quality_id)
left join producer rotorproducer on (rotor.producer_id = rotorproducer.producer_id)
left join producer statorproducer on (stator.producer_id = statorproducer.producer_id)
left join producer depositproducer on (modificationofrotor.currentproducerofdeposit_id = depositproducer.producer_id)
@macrosWHERE
)
Да, уж. Похоже зря я на 2.1 перешел. Вроде раньше не было такого (хотя данные были тестовые, может не всё предусмотрел).
А что за траблы? если изначально работать в 2.1 проблемы серъезны?
