注册 登录
编程论坛 PowerBuilder

[求助]select a into :i_pd from dual where exists (select * from yd_yprkb whe

nzylbx 发布于 2006-08-30 23:02, 1070 次点击

我的PB程序如下:
string v_ypbm
int i_pd
v_ypbm='1111111111'

我建立了一个表dual ,a为数值型 1
select a into :i_pd from dual
where exists (select * from yd_yprkb where ypbm=:v_ypbm);

用以上方法i_pd的值总是为0

但改用下面语句可以得到i_pd的返回值为1

select a into :i_pd from dual
where exists (select * from yd_yprkb where ypbm='1111111111');

注:表yd_yprkb中 ypbm 字段为字符型

为什么把变量v_ypbm换成'1111111111',就有返回值了呢,请高手指教!!!

2 回复
#2
Meng_Ya2006-08-31 17:03

您检查一下是不是跟字符的长度有关系啊。。。。。。。。。

#3
潇洒老乌龟2006-09-01 21:26

select a into :i_pd from dual
where a in (select * from yd_yprkb where ypbm='1111111111');

1