Hi,
I have two questions about transactions.
This is part of my C code.
EXEC SQL CONNECT TO ...
for (i=2; i<x: i++) { strncpy(oid_c, entries[i].val, 10); /* get oid */ oid_rec = atoi(oid_c); EXEC SQL BEGIN WORK;
EXECSQL DELETE FROM phonebook WHERE oid = :oid_rec; EXEC SQL COMMIT WORK;
}
EXEC SQL DISCONNECT;
1. Why i get the following message when I run this code?
NOTICE: BeginTransactionBlock and not in default state
2. How should I lock the table phonebook during this transaction?
Thank you,
-Margarita
-------------------------------
Margarita Barvinok
System Administrator II
University of Michigan
Department of Biology
-------------------------------
