pb7.0中,setsqlselect如何在datastore中使用

[nielisheng]

datastore ds;
ds = create datastore;
ds.settrans(sqlca);
ds.setsqlselect(strsql);
ds.retrieve();

messagebox("",strsql); //此处显示正常
messagebox("",ds.getsqlselect()); //此处显示乱码

messagebox("",ds.rowcount()); //查询结果 0,但在查询分析器中不为0

[klbt]

你可以换成数据窗口试试，看看是否还有错误

[nielisheng]

SELECT dbo.country.countrynm+dbo.city.citynm+dbo.cust_mf.addr2,
dbo.cust_mf.cardnm,
dbo.cust_mf.zip2,
case when dbo.cust_mf.telo="" then dbo.cust_mf.telb else dbo.cust_mf.telo end tel
FROM dbo.city,
dbo.country,
dbo.cust_mf,
dbo.cust_vipm
WHERE ( dbo.cust_mf.cust_sys = dbo.cust_vipm.cust_sys ) and
( dbo.city.city = dbo.cust_mf.city2 ) and
( dbo.country.country = dbo.cust_mf.country2 )