- 论坛徽章:
- 0
|
我在declare中 定义一个和表结构一样的结构。在sql语句中使用,结果在预编译中就报错。
代码如下
EXEC SQL BEGIN DECLARE SECTION;
typedef struct {
int ROBIT_ID[4];
char AREA_CODE[10];
} _T_ROBIT_CONF;
struct _T_ROBIT_CONF tROBIT_CONF;
EXEC SQL END DECLARE SECTION;
EXEC SQL INCLUDE SQLCA;
.......
EXEC SQL DECLARE EMP_ROBIT_CONF CURSOR for
select ROBIT_ID,AREA_CODEfrom ROBIT_CONF ;
EXEC SQL OPEN EMP_ROBIT_CONF;
for (i = 0;;i++)
{
EXEC SQL WHENEVER NOT FOUND DO break;
EXEC SQL FETCH EMP_ROBIT_CONF INTO :tROBIT_CONF;
}
EXEC SQL CLOSE EMP_ROBIT_CONF;
.......
预编译时报错。
EXEC SQL FETCH EMP_ROBIT_CONF INTO :tROBIT_CONF;
.........................................1
PCC-S-02420, Incomplete (or missing) type specification
请问错在那儿。 |
|