论坛 › Informix › 关于游标的问题，大家帮忙看看程序有什么问题！

jackwenghui 发表于 2007-08-21 10:46

关于游标的问题，大家帮忙看看程序有什么问题！

$include sqlca;
main()
{
   $char DbNameLc;
    char ErrMsg;       
   $long int num;
   $char name;
   $char address;
   printf( "Enter name of database: " );
   gets( DbNameLc );
   $database $DbNameLc;
    if( SQLCODE == 0 )
       printf( "Database %s is now open.\n", DbNameLc );
        else
       {
          rgetmsg((short)sqlca.sqlcode,ErrMsg,sizeof(ErrMsg));
             printf( "Error in opening database: %d:%s\n", SQLCODE,ErrMsg);
                  }
           $declare CustPtr scroll cursor for select * from test;
           $open CustPtr;
           $fetch first CusPtr into $num,$name,$address;
           printf("=====================\n");
           printf("The num is:%d\n",&num);
           printf("=====================\n");
           printf("The name is:%c\n",&name);
           printf("=====================\n");
                   printf("The address is:%c\n",&address);
           printf("======================\n");
           $close database;
                if(SQLCODE == 0)
                   printf("Database %s is now close.\n",DbNameLc);
        else
          {
             rgetmsg((short)sqlca.sqlcode,ErrMsg,sizeof(ErrMsg));
                     printf( "Error in opening database: %d:%s\n", SQLCODE,ErrMsg);
    }
   exit( 0 );
}
无法显示数据库所列出的信息！

ivhb 发表于 2007-08-21 15:21

你要补习C语言了
输出部分，改成

printf
   ("=====================\n");
printf ("The num is:%ld\n", num);
printf ("=====================\n");
printf ("The name is:%s\n", name);
printf ("=====================\n");
printf ("The address is:%s\n", address);
printf ("======================\n");

qzliang1120 发表于 2007-09-19 10:04

呵呵

查看完整版本: 关于游标的问题，大家帮忙看看程序有什么问题！