Using psql V7.4.1 and ecpg V3.1.0 on RH Linux 7.2, gcc compiler: The following statement precompiles, compiles and links fine:
EXEC SQL declare state_cursor cursor for "select unique state from location where post = 1"; I then change the above to EXEC SQL BEGIN DECLARE SECTION; const char *stmt="select unique state from location where post = 1"; EXEC SQL END DECLARE SECTION; EXEC SQL declare state_cursor cursor for :stmt; These statements generate the following warning from the gcc compiler: warning: passing arg 3 of ECPGprepare discards qualifiers from pointer target type and the link fails. What am I doing wrong? TIA, Paul Tilles ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]