Oliver Peters <oliver....@web.de> wrote: >> Can't your application check the return code when running INSERT, and >> not perform a DELETE if INSERT failed? > > don't know, if I can do this with OpenOffice (Base) - but I think I'd > to program this (Starbasic) and I'm not really fit in programming (I > only script from time to time in awk). So my first idea was to solve > the problem in SQL - I assume your answer is that there's no way to > do it only with sqlite?
I'm not sure what you mean by "only with sqlite". SQLite doesn't do anything by itself, it requires a host application to drive it. How exactly do you run SQL statements? Is there no indication in your SQLite binding of whether the statement succeeded or failed? If your application ignores errors from INSERT and proceeds with DELETE anyway, there's nothing SQLite can do to stop you. It can only assume that you know what you are doing, and do what you tell it to do. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
