also that query will update all rows in the commentlist table. is that what you want to do? Woody
--- On Mon, 7/7/08, Stephen Oberholtzer <[EMAIL PROTECTED]> wrote: From: Stephen Oberholtzer <[EMAIL PROTECTED]> Subject: Re: [sqlite] Bad UPDATE Problems in Mobile6 device To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Monday, July 7, 2008, 11:50 PM On Mon, Jul 7, 2008 at 7:26 AM, Bob Dennis <[EMAIL PROTECTED]> wrote: > Hi > I am getting odd results with a simple update query in a Mobile 6 device. > It only works sometimes , but never reports an error. > The same code works fine in PocketPC and Mobile5 devices. > > UPDATE 'CommentList' SET xFlag = 3 > > I wondered if anyone else has seen this, and why would a query not work > without giving an error. > This leaves me very worried. > > Any ideas greatfully received. Well, you shouldn't be putting your table names in single-quotes. Double-quotes are okay, although even they're not necessary in this case -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
