高手请教，很急

[superboy06]

我的SQL语句如下：
SELECT EA_ArcFileInfo.pagequantity ,
EA_ArcFileInfo.fenshu ,
EA_ArcFileInfo.note ,

EA_ArcFileInfo.RegNo FROM EA_ArcFileInfo where 1=1 and (regdate like '2005%') and classno in '8','9','10','11','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','83','84','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437',)......
in条件是递归组起来的，所以导致sql语句很长
当datawindow.setsqlselect(以上语句)时，数据窗口处于死锁状态，请问如何解决？？？

[godhome_bxs]

建一个临时表，把值保存到临时表中，然后关联临时表，这样有多少个值都没问题，别忘了建索引。

[godhome_bxs]

还有一个办法：
数据窗口中：
参数，string array ls_classno
select …… where classno in ( :la_classno )
脚本：
string ls_classno[] = {'1','2',……}
dw_1.retrieve(ls_classno)

[lzuyh]

帮你顶

[mb459]

数据窗口怎么也会死锁？
估计是你的sql语句效率太低，导致select速度太慢

[mb459]

where 1=1 and (regdate like '2005%') and 。。。。
1=1用来干什么的？》

[mb459]

我看你把classno in '8','9','10','11','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','83'。。。。。
换成 classno not in 。。。。。。要好一点。

[superboy06]

用setfilter就行，用sqlsqlselect就没反应了