Received: from web2105.mail.yahoo.com (web2105.mail.yahoo.com [128.11.68.249]) by hub.org (8.10.1/8.10.1) with SMTP id e7VAZVC78375 for ; Thu, 31 Aug 2000 06:35:31 -0400 (EDT) Received: (qmail 6929 invoked by uid 60001); 31 Aug 2000 10:35:30 -0000 Message-ID: <20000831103530.6928.qmail@web2105.mail.yahoo.com> Received: from [194.117.218.130] by web2105.mail.yahoo.com; Thu, 31 Aug 2000 03:35:30 PDT Date: Thu, 31 Aug 2000 03:35:30 -0700 (PDT) From: =?iso-8859-1?q?FEYS=20Mickael?= Subject: problem with the ecpg -D option To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200008/199 Configuration : system : sun sparc ultra 5 os : solaris 2.7 postgres : 7.0.2 compilator : cc compilator from the workshop. Problem: I used the ecpg tool in order to build a c program. I would like to use a conditional compilation in order to have the same code to acces different system database but the ecpg tool just copy the #ifdef statements to the c program. Example: #ifdef ORACLE exec sql fetch cursor_name into :s_variable /* fetch instruction for an oracle database */ #endif The preprocessor just copy those lines to the c program whereas it should ignore them and as the fetch statement which was deserved for oracle is unrecognised by postgres, the preprocessor is unable to parse the file. I try with the -D option, thinking it works like the -D option in C but it doesn't. Thanks in advance. Mickael FEYS __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/