pro*c动态SQL出错

[yyw6637]

void Query()
{
	char *datainfo;
	char c_DateTime[50];	/*输出的时间变量*/
	int i = 0;
	int j=0;
	GetDateTime(c_DateTime);
	char msg[DEFAULT_FILEBUFFER_LEN];
	char C_SP_TYPE_CODE[DEFAULT_FILEBUFFER_LEN];
	EXEC SQL INCLUDE SQLCA;
	EXEC SQL BEGIN DECLARE SECTION;
	VARCHAR count[20];
	VARCHAR  c_SqlStr[5000];
	
	VARCHAR SP_TYPE[20];
	VARCHAR  SP_TYPE_CODE[DEFAULT_BUF_SIZE];
	EXEC SQL END DECLARE SECTION;
	strcpy ((char *)c_SqlStr.arr,param.c_SqlStr);
	if (ConnectDB(param.USER_PASSWORD) == 0)
	{
		EXEC SQL SELECT count(*) INTO :count FROM TD_B_SPTYPE;
		if (sqlca.sqlcode < 0)
		{
			DisconnectDB();	/*断开数据库连接*/

			printf("建立游标错误！错误代码:%d\n", sqlca.sqlcode);
			exit(-1);
		}
		strcpy((char*)msg, (char*)count.arr);
	
		
		if ((in_fp = fopen(param.FILENAME, "w")) != NULL)
		{
			printf("打开%s文件成功\n\n", param.FILENAME); 
			printf("---------------------%s 开始处理数据---------------------\n\n", c_DateTime);

			if (setvbuf(in_fp, msg, _IONBF, DEFAULT_FILEBUFFER_LEN) != 0)
				printf("设置缓冲失败\n");
			else
			{
				printf("设置缓冲成功：%d\n", setvbuf(in_fp, msg, _IONBF, DEFAULT_FILEBUFFER_LEN));
			}
			
			EXEC SQL PREPARE s from :c_SqlStr;
			EXEC SQL DECLARE cur_out CURSOR for s;
			EXEC SQL OPEN cur_out;
			EXEC SQL WHENEVER NOT FOUND GOTO notfound;
    for (;;) 
			{
					EXEC SQL FETCH cur_out into :SP_TYPE_CODE;
			printf("%s\n",SP_TYPE_CODE);
			/*EXEC SQL ;*/
			strcpy((char*)C_SP_TYPE_CODE, (char*)SP_TYPE_CODE.arr);
			while (C_SP_TYPE_CODE[i] && (i < strlen(C_SP_TYPE_CODE)))
			{SELECT replace(replace(SP_TYPE_CODE||chr(01)||SP_TYPE,chr(10)),chr(13)) INTO :SP_TYPE_CODE FROM TD_B_SPTYPE where SP_TYPE_CODE='66'
				fputc(C_SP_TYPE_CODE[i], in_fp);
				i++;
			}
		}
		notfound:
		EXEC SQL CLOSE cur_out;
    EXEC SQL COMMIT RELEASE;
    printf("Have a good day!\n");
    exit(0);
		printf("--------------------------共处理%d条数据---------------------------\n\n", msg);

		fclose(in_fp);
		}
	}
}

我的sql是：SELECT replace(replace(SP_TYPE_CODE||chr(01)||SP_TYPE,chr(10)),chr(13)) INTO :SP_TYPE_CODE FROM TD_B_SPTYPE where SP_TYPE_CODE='66'，按理说只查出一天数据，可为什么循环的时候一直循环

[mymtom]

完全不知道c_SqlStr里是什么内容啊！

[yyw6637]

引用 1 楼 mymtom 的回复:

完全不知道c_SqlStr里是什么内容啊！

select replace(replace(calling_sub_type_code||chr(01)||calling_sub_type_name||chr(01)||calling_type_code||chr(01)||start_date||chr(01)||end_date,chr(10)),chr(13)) from TD_S_CALLINGSUBTYPE 数据不多，但是却成死循环了