Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ////////////////////////////////////////////////////////////////
- // Re-create emp table with auto-increment field
- ////////////////////////////////////////////////////////////////
- cout << endl << "Auto increment test" << endl;
- db.execDML("drop table emp;");
- db.execDML(
- "create table emp(empno integer primary key, empname char(20));");
- cout << nRows << " rows deleted" << endl;
- for (i = 0; i < 5; i++)
- {
- char buf[128];
- sprintf(buf,
- "insert into emp (empname) values ('Empname%06d');", i+1);
- db.execDML(buf);
- cout << " primary key: " << db.lastRowId() << endl;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement