Обсуждение: Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)

Поиск
Список
Период
Сортировка

Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)

От
Tom Good
Дата:
Hello again -

In the ongoing struggle to get ecpg to delete a tuple:

my main() has been pared to what you see below...no effect.
Meanwhile if I run
registry=>\i /home/tomg/killrec.sql;
I get:
DELETE FROM central WHERE client_id = 10002
DELETE 1
EOF

I dunno...
(thanks!)
Tom

-------------------------------------------------------------------
main() {
EXEC SQL CONNECT 'registry';

  if(sqlca.sqlcode) {
    printf("Error connecting to database server.\n");
    exit(0);
  }

EXEC SQL DELETE FROM central WHERE client_id = 10002;
  exit(0);
}