[Postgres-ECPG] Select multiple

Select multiple [Postgres-ECPG] - SQL/NoSQL - Programmation

Marsh Posté le 09-09-2002 à 09:54:16    

Comment stocker les engegistrement retournés pas un select en ECPG/Pro-C ?
 
J'ai essayé ça:
 

Code :
  1. EXEC SQL include sqlca;
  2. EXEC SQL begin declare section;
  3.   char* array = NULL;
  4. EXEC SQL end declare section;
  5. EXEC SQL select * into :array from message where msg_id>440;
  6. printf("Cannot perform action: error %d : %s\n", sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc);
  7. printf("%d\n", (int)array[0]);


 
et ça foire:
 
52
Cannot perform action: error -202 : Too few arguments in line 25.
 
Comment on fait ?
 
PS: pas d'utilisation de CURSOR/FETCH svp.

Reply

Marsh Posté le 09-09-2002 à 09:54:16   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed