帮个忙

[slplp]

1.在c下面写嵌套sql时，主函数里面宿主变量声明时可以是指针型，或数组变量型吗？
如：void main(){
struct sqlda *sqr;
struct sqlda sqr; //sqlda是sql的描述符区
}


2.如下程序
#include <stdio.h>
#include <stdlib.h>
#include <string.h>

//EXEC SQL INCLUDE SQLCA;
EXEC SQL INCLUDE SQLDA;

int main() {
EXEC SQL BEGIN DECLARE SECTION;

char stmt[200];
char firstname[13];
char userid[15];
char password[19];
char lastname[15];
float bonus1;
struct sqlda *sqldaptr; //编译时提示错误：在主变量申明中找到
// 的"*"无效

EXEC SQL END DECLARE SECTION;

sqldaptr=(struct sqlda *) malloc(SQDLDASIZE(n));
sqldaptr->sqln=0;
strcpy(stmt,"SELECT FIRSTNME,LASTNAME,BONUS FROM employee");
strcpy(userid,"administrator");
strcpy(password,"123456");
EXEC SQL CONNECT TO sample USER :userid USING :password;

EXEC SQL PREPARE A INTO :*sqldaptr From:stmt;
if(sqldaptr->sqld==0) {
EXEC SQL EXECUTE A;
return;
}
if(sqldaptr->sqln<sqldaptr->sqld){
sqldaptr = (struct sqlda * )remalloc(SQLDASIZE(sqldaptr->sqld));
sqldaptr->sqln=sqldaptr->sqld;
}
EXEC SQL DESCRIBE A INTO :*sqldaptr;
EXEC SQL DECLARE cur CURSOR FOR A;
EXEC SQL OPEN cur;
while(1){
EXEC SQL FETCH cur Using DESCRIPTOR :*sqldaptr;
}


EXEC SQL CLOSE cur;
EXEC SQL CONNECT RESET;
return 0;
}

[klbt]

支持！

[m505]

把struct sqlda *sqldaptr放到DECLARE SECTION外...