Writing in C with ECPG and I have the following code:
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;
strcpy (h_sqlBuffer, "INSERT INTO address (street, county, postcode,
country) VALUES (?,?,?,?)");
EXEC SQL PREPARE insert_temp FROM :h_sqlBuffer;
EXEC SQL EXECUTE insert_temp USING :h_street, :h_county, POSTCODE_IND,
POSTCODE_IND and COUNTRY_IND are #define'd in an included header file as "Y"
(inside a BEGIN DECLARE SECTION)
When compiling I get an error which read:
ERROR: syntax error at or near """
and the line it shows is the one in red.
pgsql-novice by date
|Next:||From: Urs Rau||Date: 2010-04-28 15:59:05|
|Subject: how to continue after error in batch mode with psql|
|Previous:||From: gargoyle60||Date: 2010-04-28 08:27:41|
|Subject: Re: PostgreSQL Book|