报错为XML tag ID 2 that was originally declared as 'drug_item' is being redeclared as 'drug_rate'.sql语句为:
sql = "select 1 as tag,null as parent, drug.id as [drug!1!id],drug.patient_case_id as [drug!1!patient_case_id]," _
& "drug.begin_time as [drug!1!begin_time],drug.end_time as [drug!1!end_time]," _
& "drug.description as [drug!1!description],drug.volumn_used as [drug!1!volumn_used], " _
& "drug.routine_id as [drug!1!routine_id],drug.doctor_id as [drug!1!doctor_id], " _
& "drug.is_blood as [drug!1!is_brood],drug.is_continuum as [drug!1!continum], " _
& "drug_item.drug_id as [drug_item!2!drug_id],drug_item.medicine_id as [drug_item!2!medicine_id], " _
& "drug_item.dosage as [drug_item!2!dosage],drug_item.volumn as [drug_item!2!volumn]," _
& "drug_item.concentration as [drug_item!2!concentration],drug_item.unit_id as [drug_item!2!unit_id]," _
& "drug_item.is_liquid as [drug_item!2!is_liquid], " _
& "drug_rate.drug_id as [drug_rate!2!drug_id],drug_rate.begin_time as [drug_rate!2!begin_time], " _
& "drug_rate.end_time [drug_rate!2!end_time],drug_rate.rate as [drug_rate!2!rate] " _
& "from drug,drug_item,drug_rate " _
& "where drug_item.drug_id in (select id from drug where patient_case_id=" & CaseIDs(i) & ") and drug_rate.drug_id in (select id from drug where patient_case_id=" & CaseIDs(i) & ")" _
& "for xml explicit"强调两个子表应该是在同一层次上的。
sql = "select 1 as tag,null as parent, drug.id as [drug!1!id],drug.patient_case_id as [drug!1!patient_case_id]," _
& "drug.begin_time as [drug!1!begin_time],drug.end_time as [drug!1!end_time]," _
& "drug.description as [drug!1!description],drug.volumn_used as [drug!1!volumn_used], " _
& "drug.routine_id as [drug!1!routine_id],drug.doctor_id as [drug!1!doctor_id], " _
& "drug.is_blood as [drug!1!is_brood],drug.is_continuum as [drug!1!continum], " _
& "drug_item.drug_id as [drug_item!2!drug_id],drug_item.medicine_id as [drug_item!2!medicine_id], " _
& "drug_item.dosage as [drug_item!2!dosage],drug_item.volumn as [drug_item!2!volumn]," _
& "drug_item.concentration as [drug_item!2!concentration],drug_item.unit_id as [drug_item!2!unit_id]," _
& "drug_item.is_liquid as [drug_item!2!is_liquid], " _
& "drug_rate.drug_id as [drug_rate!2!drug_id],drug_rate.begin_time as [drug_rate!2!begin_time], " _
& "drug_rate.end_time [drug_rate!2!end_time],drug_rate.rate as [drug_rate!2!rate] " _
& "from drug,drug_item,drug_rate " _
& "where drug_item.drug_id in (select id from drug where patient_case_id=" & CaseIDs(i) & ") and drug_rate.drug_id in (select id from drug where patient_case_id=" & CaseIDs(i) & ")" _
& "for xml explicit"强调两个子表应该是在同一层次上的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货