How to use dynamic sql...?? in ECPG.....

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.....

}

Browse pgsql-general by date

  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...