Question

VB中如何将多个SQL求出的值在vsflexgrid中显示在一行

select round((select COUNT(*) from INSPECTION.REPAIR_DEFECT_INFO_RPL_RRP_RP T

WHERE T.Lot_No='BDBCK44191000')/(select SUM(ID_SHEET_COUNT)
as RPL_QTY from progress.rpl_in_cassette_result WHERE LOT_NO = 'BDBCK44191000')*100,1)||'%' as DF/S from dual

select round((select sum(repair_defects) from INSPECTION.repair_defect_count_rpl_rrp_rp
where lot_no = 'BJ0CK42211000')/(select SUM(ID_SHEET_COUNT)
as RPL_QTY from progress.rpl_in_cassette_result WHERE LOT_NO = 'BDBCK44191000')*100,1)||'%' as LAP/S from dual

select round((select count(*) from INSPECTION.REPAIR_DEFECT_INFO_RPL_RRP_RP

where lot_no in ('BDBCK44191000') and end_height <1.5 )/(select sum(repair_defects) from INSPECTION.repair_defect_count_rpl_rrp_rp where lot_no = 'BJ0CK42211000')*100,1)||'%' a from dual

select round ((select count(*) from INSPECTION.REPAIR_DEFECT_INFO_RPL_RRP_RP

where lot_no = 'BDBCK44191000' and judgement = 'G')/(select COUNT(*) from INSPECTION.REPAIR_DEFECT_INFO_RPL_RRP_RP

WHERE Lot_No='BDBCK44191000')*100,1)||'%' from dual

select round((select count(*) from repair_defect_count_rpl_rrp_rp

WHERE Lot_No = 'BDBCK44191000' and total_defects > 3)/(select count(*) from INSPECTION.REPAIR_INFO_RPL_RRP_RP

WHERE Lot_No='BJ0CK42211000')*100,1)||'%' as H_Ratio from dual

如何将上面几个SQL求出的值在VB的vsflexgrid中显示在一行中？没有那么多财富值了，希望大神可以帮忙下！

Answer 1

rowStr=rs(0) & vbTab & rs(1) & vbTab & rs(2)

vsflexgrid.AddItem rowStr

追问

能写的具体点，把我的那些写到一起吗，刚开始学，不懂！谢谢了！

追答

你自己先去弄懂vb如果得到数据库的记录，再说吧。