以下是引用mywisdom88在2016-5-11 15:22:13的发言:
你有个bx.*,如果你这个表有这几个字段,新表也有的。
你查询失败了,你还能brow ?可能是你上次查询的结果
你换个名称看看,叫bx02,
if sqlexec(......................)>0
select bx02
brow
else
messagebox("失败")
endif
SQLEXEC(con1,"select a.*,tel as 业主电话,mobile as 业主手机,calibre as 口径 from bx a,m_meter b,a_client c,a_card d
where a.卡号 =d.card_no and d.client_no = c.client_no and b.meter_id = d.meter_id order by 报修时间 desc","bx02")
*?SQLEXEC(con1,"select bx.*,tel as 业主电话,mobile as 业主手机,calibre as 口径
from bx ,m_meter ,a_client ,a_card
where bx.卡号 =a_card.card_no and a_card.client_no = a_client.client_no and meter.meter_id = a_card.meter_id order by 报修时间 desc","bx02")
这2句有什么不同,一条可以,一条不行,怪事,太长了?