Send grass-windows mailing list submissions to grass-windows@lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/grass-windows or, via email, send a message with subject or body 'help' to grass-windows-requ...@lists.osgeo.org You can reach the person managing the list at grass-windows-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than "Re: Contents of grass-windows digest..." Today's Topics: 1. RE: db.execute not working (Louis Becker) ---------------------------------------------------------------------- Message: 1 Date: Mon, 11 Oct 2010 11:15:08 +0200 From: "Louis Becker" <louis.bec...@leo.na> Subject: RE: [GRASS-windows] db.execute not working To: "Glynn Clements" <gl...@gclements.plus.com> Cc: grass-windows@lists.osgeo.org Message-ID: <21a6a90e7cd2584db72892049e1de78f02fa4...@mail01.99eight.com> Content-Type: text/plain; charset="us-ascii" Hi Glynn Yes, the problem is the select statement. I have now been able to update a table by dropping the quotation marks. Thanks Louis Becker > -----Original Message----- > From: Glynn Clements [mailto:gl...@gclements.plus.com] > Sent: 07 October 2010 10:42 > To: Louis Becker > Cc: grass-windows@lists.osgeo.org > Subject: RE: [GRASS-windows] db.execute not working > > > Louis Becker wrote: > > > DBMI-SQlite driver error: > > Error in sqlite3_step() > > not an error > > > > ERROR: Error while executing: 'select * from Coverage2011_4 > > ' > > I don't know if it's related, but you probably shouldn't be using > db.execute for a select statement. You would normally use db.select > for queries. > > -- > Glynn Clements <gl...@gclements.plus.com> DISCLAIMER This message is intended solely for the individual(s) and entity(s) to which it is addressed. It is confidential and may contain legally privileged information. Any unauthorized review, use, copying, storage, disclosure or distribution of this e-mail and any attachments is strictly prohibited. If you are not the named recipient or have otherwise received this communication in error, please destroy this message from your system and kindly notify the sender by e-mail. ------------------------------ _______________________________________________ grass-windows mailing list grass-windows@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-windows End of grass-windows Digest, Vol 50, Issue 5 ********************************************