ecpg - select * into structure problem

Поиск
Список
Период
Сортировка
От Tim Nelson
Тема ecpg - select * into structure problem
Дата
Msg-id iZ5R7.1085$vK1.98901@newsread2.prod.itd.earthlink.net
обсуждение исходный текст
Ответы Re: ecpg - select * into structure problem  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-general
I am running 7.1.3 (ecpg 2.8.0) ....seems I need to reference each variable
into the structure for the fetch to succeed.  I looked at the generated code
and it's missing the ECPGt_NO_INDICATOR lines in the call to ECPGdo.

Is this a bug?  Thanks.

------------ code -------

EXEC SQL include sqlca;

main()
{
   EXEC SQL BEGIN DECLARE SECTION;
   struct  {
   char prfc_cd[21];
   char prfc_entry[31];
   } x;

   EXEC SQL END DECLARE SECTION;

   EXEC SQL CONNECT TO ecs;
   printf("CONNECT = %d\n",sqlca.sqlcode);

   EXEC SQL DECLARE c1 CURSOR FOR select * from pref_char;
   printf("DECLARE = %d\n",sqlca.sqlcode);

   EXEC SQL open c1;
   printf("OPEN = %d\n",sqlca.sqlcode);

   while (1) {
      EXEC SQL fetch c1 into :x;  /* this fails with -200 */

      /* this works ...EXEC SQL fetch c1 into :x.prfc_cd,:x.prfc_entry; */

      printf("FETCH %d\n",sqlca.sqlcode);
      if (sqlca.sqlcode)
         break;
      printf("X.prfc_cd = %s X.prfc_entry = %s\n",x.prfc_cd,x.prfc_entry);
   }
   EXEC SQL DISCONNECT;
   exit(0);
}




В списке pgsql-general по дате отправления:

Предыдущее
От: Jason Earl
Дата:
Сообщение: Re: Inserting the current date
Следующее
От: "Raul DAVIDOVICH"
Дата:
Сообщение: problem with select after updating