Народ!!
Вылетает ошибка при работе с ADODataset (примерный текст):
"Параметр не может быть произведен из подзапроса, проверьте параметры перед открытием".
Может и по-английски, в зависимости от версии ADO.
На моей машине не вылетает, на других - вылетает.
Что это за фигня?
Спасибо. Родина вас не забудет. Честно

запрос к SQL-серверу. Ошибка где-то в параметрах.

ТЕКСТ ЗАПРОСА:
SELECT
pop_view_filter.ID_POP,EduNameFull AS EduName,
pop_view_filter.id_Dop,pop_view_filter.EduCode,pop_view_filter.Year,
EduForm,Organization,
StatusProg,PlaceRealizat,pop_view_filter.AddInfo,
SpecializName, SpecializCode,
SpecialnCode,SpecialnName,
EduNaprName, EduNaprCode,
SpecGroupName, SpecGroupCode,
NaprGroupName, NaprGroupCode,
pop_view_filter.ReferToTip

FROM pop_view_filter INNER JOIN
study_F ON pop_view_FILTER.id_EduForm = study_F.id_StudyForm INNER JOIN
pln_EduProgYear ON pln_EduProgYear.id_pln = pop_view_filter.ID_POP INNER JOIN
pln_EduProg ON pln_EduProgYear.id_Dop = pln_EduProg.id_dop LEFT JOIN
Struct_FLAG ON pln_EduProg.id_Structure = Struct_FLAG.id_structure LEFT JOIN
Struct_DIV ON Struct_FLAG.DIV_ID = Struct_DIV.DIV_ID LEFT JOIN
Struct_FLAG Struct_FLAG_1 ON pln_EduProg.id_Organizer = Struct_FLAG_1.id_structure LEFT JOIN
Struct_DIV Struct_DIV_1 ON Struct_FLAG_1.DIV_ID = Struct_DIV_1.DIV_ID
WHERE
study_F.id_StudyForm= ISNULL(:id_StudyForm,study_F.id_StudyForm)
and
pop_view_filter.id_Specialn= ISNULL(:id_Specialn,pop_view_filter.id_Specialn)
and
pop_view_filter.id_Spec= ISNULL(:id_Spec,pop_view_filter.id_Spec)
and
pop_view_filter.id_StatusProg= ISNULL(:id_StatusProg,pop_view_filter.id_StatusProg)
and
pop_view_filter.id_AddInfo= ISNULL(:id_AddInfo,pop_view_filter.id_AddInfo)
and
pop_view_filter.Year= ISNULL( :Year, pop_view_filter.Year)
and
sign(pop_view_filter.referToTip)= ISNULL( :Refer, sign(pop_view_filter.referToTip) )
and
pln_EduProg.id_Structure= ISNULL(:id_Structure, pln_EduProg.id_Structure)
and
pln_EduProg.id_Organizer= ISNULL(:id_Organizer,pln_EduProg.id_Organizer)
ORDER BY pop_view_filter.ID_POP