I know I can recover the last_insert_rowid() in SQLite in the SQL
query itself; is there an equivalant SQL function to sqlite_changes or
sqlite_last_statement_changes (from 2.8.15)? If, for example, an
insert doesn't take place, I get the last id of the insert *before*
this one. What I would really like is to be able to determine whether
the last insert actually inserted something or not, but from within
the SQL query.
If not, is there any good way, without, for example, querying the
number of rows in the database, saving the count in C, executing the
change, then requerying the number and comparing it to the original
count?
--Keith
--
******************************************************
- Ever notice how 'big' isn't, compared to 'small'?
- Sounds like a Wookie; acts like mad cow.
- I'm not a professional; I just get paid to do this.
- Rules for programming:
1. Get it working, right?
2. Get it working right.
- Things I've learned about multithreaded programming:
123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt
rhheiianndgge dwi hnpi rctohhg eri aslm omscitanalgt
iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd 'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
******************************************************
