想通过油标取出多行数据,可运行结果count是‘0’?
直接敲SQL代码查询有数据
我的代码如下:
step = 300
additional = CSJ%
eventtime = 2006/01/09% <-数据库里面是 Date类型
v_sorterno[100][10]
都是varchar 类型
-----------
EXEC SQL DECLARE sorter_cur CURSOR FOR
SELECT DISTINCT additional
FROM lotinfo_simax
WHERE step= :step and additional like :thead and eventtime like :v_cdate;
EXEC SQL OPEN sorter_cur;
for(;
{
EXEC SQL WHENEVER NOT FOUND DO break;
EXEC SQL FETCH sorter_cur
INTO :v_sorterno;
sorter_cnt++;
}EXEC SQL CLOSE sorter_cur;
sprintf(stLog,"Sorter count is [%d]\n",sorter_cnt);
WriteLog(stLog);
------------------------------------------------------
怎么解决
直接敲SQL代码查询有数据
我的代码如下:
step = 300
additional = CSJ%
eventtime = 2006/01/09% <-数据库里面是 Date类型
v_sorterno[100][10]
都是varchar 类型
-----------
EXEC SQL DECLARE sorter_cur CURSOR FOR
SELECT DISTINCT additional
FROM lotinfo_simax
WHERE step= :step and additional like :thead and eventtime like :v_cdate;
EXEC SQL OPEN sorter_cur;
for(;
{
EXEC SQL WHENEVER NOT FOUND DO break;
EXEC SQL FETCH sorter_cur
INTO :v_sorterno;
sorter_cnt++;
}EXEC SQL CLOSE sorter_cur;
sprintf(stLog,"Sorter count is [%d]\n",sorter_cnt);
WriteLog(stLog);
------------------------------------------------------
怎么解决
是因为eventtime 在table里面是Date类型,而在proc里面是varchar 类型,
在上例中我想取今天的数据的话怎么在proc里面实现?