YAN HONG YE <yanhong...@mpsa.com> wrote: > I need a function to run step 2 in sql cmd, but I don't know how to write in > the sql environment. > > 1. BEGIN TRANSACTION; > 2. if today is mondy to fridy,then run 3-6 > ELSE run 6. > 3. prepare and step stmt A (SELECT * FROM foo WHERE rowid=1), A is not > finalized or reset; > 4. execute stmt B (DELETE FROM foo WHERE rowid=1), B is prepared, executed > and finalized; > 5. access column data via stmt A > 6. COMMIT
I'm confused. What kind of a programming language you are using which allows you to prepare, step, and access columns of an SQLite statement, but doesn't allow you to obtain today's date nor implement condition checks? Apart from that, what exactly do you hope to achieve by trying to access values in a row *after* you've just deleted it? This doesn't make any sense whatsoever, whether attempted on a weekday or a weekend. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
