On Thu, 20 Mar 2003 08:31, Bruce Momjian wrote:
> Can someone comment on this?
Ah, this might explain why FREE kept failing on us (see sample code below).
Or have I missed something here?
Regards, Philip Yarra.
int main(int argc, char *argv[])
{
EXEC SQL BEGIN DECLARE SECTION; char *target = "bob@snode5"; char *user = "philip";
char *message = "It came from embedded C"; char *pquery = "INSERT INTO test (message)
VALUES(?)";
EXEC SQL END DECLARE SECTION;
if(argv[1] != NULL) message = argv[1];
EXEC SQL WHENEVER sqlerror sqlprint;
EXEC SQL CONNECT TO :target USER :user; /*EXEC SQL SET AUTOCOMMIT TO ON; */
EXEC SQL PREPARE stmt_id FROM :pquery; EXEC SQL EXECUTE stmt_id USING :message; EXEC SQL COMMIT;
EXEC SQL FREE stmt_id;/* executing this line causes message"sql error Invalid statement name stmt_id in line 25."to be
printedto console*/ EXEC SQL DISCONNECT ALL;
}