ecpg - `exec sql delete' failing - Mailing list pgsql-interfaces

From Tom Good
Subject ecpg - `exec sql delete' failing
Date
Msg-id Pine.LNX.3.95.980403164223.2163A-100000@mailhost.nrnet.org
Whole thread Raw
Responses Re: [INTERFACES] ecpg - `exec sql delete' failing
List pgsql-interfaces
Hi.  Can't fathom why this code precompiles, compiles, links and
seems to execute - but won't delete records.
As always - any assistance greatly appreciated!
Tom
--- pgc code follows ---

#include <stdio.h>

EXEC SQL BEGIN DECLARE SECTION;
  int ClientID;         /* client_id */
  char FirstName[16];   /* client_fname */
  char LastName[16];    /* client_lname */
  char NameTag[16];     /* usr buffer */
  char reply;           /* usr buffer */
  int delete_num;       /* usr buffer */
EXEC SQL END DECLARE SECTION;

EXEC SQL INCLUDE sqlca;

main()
{

EXEC SQL CONNECT 'registry';

  if(sqlca.sqlcode) {
    printf("Error connecting to database server.\n");
    exit(0);
  }
system("tput clear");
printf("\n\n");
printf("\t\t\tConnected to database server...\n");
printf("\t\t\tEnter Last Name of Client: ");
scanf("%s", &NameTag);

EXEC SQL SELECT client_id, client_lname, client_fname
INTO :ClientID, :LastName, :FirstName
  FROM central
  WHERE client_lname = :NameTag;

printf("\n");
printf("\t\tID: %d  Lastname: %s Firstname: %s\n", ClientID, LastName, FirstName);
printf("\t\t-------------------------------------------------------\n");

printf("\t\tRemove this record (y/n): ");
scanf("%s", &reply);
if(reply == 'y') {
printf("\t\tEnter Client ID Number: ");
scanf("%d", &delete_num);
EXEC SQL DELETE FROM central WHERE client_id = delete_num;
}
else printf("Exiting...record not removed.\n");
  exit(0);
}


    ----------- Sisters of Charity Medical Center ----------
                    Department of Psychiatry
                              ----
 Thomas Good, System Administrator            <tomg@q8.nrnet.org>
 North Richmond CMHC/Residential Services     Phone: 718-354-5528
 75 Vanderbilt Ave, Quarters 8                Fax:   718-354-5056
 Staten Island, NY   10305


pgsql-interfaces by date:

Previous
From: Tom Good
Date:
Subject: RE: [INTERFACES] ecpg libraries
Next
From: Tom Good
Date:
Subject: ...