Perhaps, but I think autoCommit is the default with ooSQLite and so far I have not found the syntax for Rollback or Commit to try that - are they implemented in ooSQLite? or must the hooks be used? However, in playing with the sample programs included with ooSQLite, it appears that the DELETE is working there - so it must be something else in my program. Art Heimsoth
> This is just a guess: Do a COMMIT perhaps? > > > Earl Hodil > Open Software Technologies > > > On Jan 2, 2013, at 8:13 PM, Art Heimsoth <artst...@artheimsoth.com> > wrote: > >> I must be doing something wrong, but within my ooDialog program I >> have not been able to delete a row. I display a list of names in >> the main dialog, obtained with a SELECT statement, then pass the >> selected name to a child method where a couple of other tables >> are checked and then that row is attempted to be deleted with the >> DELETE statement, but a SELECT statement immediately following >> shows the row is still in the database.. My statement passed to >> the SQL method to execute is: DELETE FROM table WHERE upper(name) >> = "SOME NAME"; The select statement immediately following is: >> SELECT name FROM table WHERE upper(name) = "SOME NAME"; and it is >> retrieved from the table.. Any ideas? Thanks.. >> >> -- >> Art Heimsoth - artst...@artheimsoth.com >> ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 _______________________________________________ Oorexx-users mailing list Oorexx-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oorexx-users
