ecpg-gets()
От | Tom Good |
---|---|
Тема | ecpg-gets() |
Дата | |
Msg-id | Pine.LNX.3.95.980409160012.3290B-100000@mailhost.nrnet.org обсуждение исходный текст |
Список | pgsql-interfaces |
Hi all...this code compiles but when you get to the gets() function call it jumps ahead to the next printf()...it does not pass go and it doesn't enter any values into the attribute...it simply leaps ahead to the next stanza. Anyone seen this before - or got a quick fix? Thanks, Tom ------------------------------------ #include <stdio.h> #include <string.h> EXEC SQL BEGIN DECLARE SECTION; int ClientID; /* client_id */ char FirstName[16]; /* client_fname */ char LastName[16]; /* client_lname */ char AliasName[26]; /* a_lias */ char HomeStat[31]; /* home_stat */ int HomeLess; /* home_less */ char NameTag[16]; /* usr buffer */ char Hmm[80]; /* usr buffer */ EXEC SQL END DECLARE SECTION; EXEC SQL INCLUDE sqlca; main() { EXEC SQL CONNECT 'registry'; EXEC SQL WHENEVER sqlerror sqlprint; EXEC SQL WHENEVER not found sqlprint; system("tput clear"); printf("\n\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\tClient ID Lastname Firstname"); printf("\n\t----------------------------------------------"); printf("\n\t%d %s %s\n", ClientID, LastName, FirstName); EXEC SQL COMMIT; printf("\n\tEnter Any Known Alias (or N/A): "); scanf("%s", &AliasName); EXEC SQL UPDATE central SET a_lias = :AliasName WHERE client_lname = :NameTag; EXEC SQL COMMIT; printf("\tEnter Homeless Status (i.e, `Not Homeless'): "); fflush(stdout); gets(Hmm); EXEC SQL UPDATE central SET home_stat = :Hmm WHERE client_lname = :NameTag; EXEC SQL COMMIT; printf("\tEnter OMH Homeless Code: "); scanf("%d", &HomeLess); EXEC SQL UPDATE central SET home_less = :HomeLess WHERE client_lname = :NameTag; EXEC SQL COMMIT; return (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 по дате отправления: