请问这个错误是什么意思？怎么产生的？

[gotolwd]

select error :decimal conversion error,powerbuilder only support 18 decimal digits

我的数据库里的两个字段，id (numeric),val(varchar 600)
我从其他表里取出值给cur_id,最后运行时会产生这样的错误
string sql
long cur_id
currow = row
cur_id = dw_1.getitemdecimal(currow,'id')
sql="SELECT val FROM table where id='"+string(cur_id)+"'"
dw_2.setsqlselect(sql)
dw_2.retrieve()

[wwwafa9]

sql="SELECT val FROM table where id='"+string(cur_id)+"'"这句有问题，改为：

sql="SELECT val FROM table where id = " + string(cur_id）

[mittee]

楼上正确

[huangxinru]

sql="SELECT val FROM table where id='"+string(cur_id)+"'"
改成
sql="SELECT val FROM table where id='"+string(cur_id,0)+"'"

[gotolwd]

呵呵,你说的做法我也做过了,但是情况依旧阿

[小子侯]

类型重新定义一下，sql语句改为以下
deciaml cur_id
sql="SELECT val FROM table where id='"+string(cur_id)+"'"这句有问题，改为：

sql="SELECT val FROM table where id = " + string(cur_id)

//因为cur_id定义为了数值型所以不直接把其转换为字符类型给id即可不必要加引号

[gotolwd]

hehe,我昨天晚上有事，没来，而且也没有说清楚，我是在
sql="SELECT val FROM table where id = " + string(cur_id）
不好使后换的帖子上的语句的，拷贝的时候忘改了，其实就是这两句都出现同一个问题
产生的是同一条错误

[tulip2108]

Test Note 4: PowerBuilder only supports Decimals up to a Maximum Precision of 18

PowerBuilder only supports decimals to a maximum precision of 18 characters. Test attempts to retrieve columns defined with precision greater than 18 resulted in a message similar to the following:

"SQL Preview...Select error: Decimal conversion error. PowerBuilder only supports 18 decimal digits."

[tulip2108]

Long

32-bit signed integers, from -2147483648 to [phone].
Using literals Use literals as for integers, but longer numbers are permitted.
Decimal or Dec

Signed decimal numbers with up to 18 digits. You can place the decimal point anywhere within the 18 digits梖or example, 123.456, 0.000000000000000001 or 12345678901234.5678.
字段类型定义错了。
string sql
decimal cur_id //原来为long
currow = row
cur_id = dw_1.getitemdecimal(currow,'id')
sql="SELECT val FROM table where id = " + string(cur_id）
dw_2.setsqlselect(sql)
dw_2.retrieve()