ecpg - `exec sql delete' failing
От | Tom Good |
---|---|
Тема | ecpg - `exec sql delete' failing |
Дата | |
Msg-id | Pine.LNX.3.95.980403164223.2163A-100000@mailhost.nrnet.org обсуждение исходный текст |
Ответы |
Re: [INTERFACES] ecpg - `exec sql delete' failing
|
Список | 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 по дате отправления: