From: | "Ki won, Song" <schiva(at)m2000(dot)co(dot)kr> |
---|---|
To: | "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | How to use dynamic sql...?? in ECPG..... |
Date: | 1998-11-24 02:53:05 |
Message-ID: | 000701be1755$8fdc6fc0$4157fbcb@m2000.www.m2000.co.kr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In C programming... with ECPG tool...
I have some problem!!
How to use dynamic sql cursor??
void main()
{
char sqlsentence[255];
int flag;
....... Db Connection.....
switch(flag) {
case 1: {
sprintf(sqlsentence,"select id , name from testa where id = 1");
break;
}
case 2: {
sprintf(sqlsentece," select tel, address from testb where key=22");
break;
}
}
EXEC SQL DECLARE cur1 CURSOR FOR :sqlsentence;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
==> ecpg pre compile error "parse error"!!!
==> How to use Dynamic sql with ECPG??
....... some process.....
}
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-11-24 03:07:12 | Re: [GENERAL] User Gallery and Third Party pages merged and rebuilt... |
Previous Message | Peter T Mount | 1998-11-23 21:59:30 | Re: [GENERAL] User Gallery and Third Party pages merged and rebuilt... |