Re: simple UPDATE not working
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Tue, 3 Apr 2007 15:28:19 +0100
sSql = "UPDATE peter set last=\"Peter\" where id=3";
db.Execute(sSql);
Should that not be
sSql = "UPDATE peter set last='Peter' where id=3";
single quotes not double quotes for SQL strings
Stephen Howe
.
- Follow-Ups:
- Re: simple UPDATE not working
- From: Peter Carlson
- Re: simple UPDATE not working
- References:
- simple UPDATE not working
- From: Peter Carlson
- simple UPDATE not working
- Prev by Date: simple UPDATE not working
- Next by Date: Re: simple UPDATE not working
- Previous by thread: simple UPDATE not working
- Next by thread: Re: simple UPDATE not working
- Index(es):
