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 по дате отправления:

Предыдущее
От: Constantin Teodorescu
Дата:
Сообщение: Re: libpgtcl instructions - undefined symbol crypt
Следующее
От: David Hartwig
Дата:
Сообщение: New pg_type for large object