Re: simple UPDATE not working

From: Peter Carlson <peter@xxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 03 Apr 2007 08:41:28 -0600

Should have wrote that I tried that too :)
UPDATE peter set last='Peter' where id=3
fails as well

Peter

Stephen Howe wrote:

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

References:
- simple UPDATE not working
  - From: Peter Carlson
- Re: simple UPDATE not working
  - From: Stephen Howe

Prev by Date: Re: simple UPDATE not working
Next by Date: Re: simple UPDATE not working
Previous by thread: Re: simple UPDATE not working
Next by thread: Re: simple UPDATE not working
Index(es):
- Date
- Thread

Relevant Pages

Re: Simple code worked fine with SQL2005, but now has a problem with SQL2000.
... be anal about spaces semi colons and single quotes. ... cnSQL = New ... fails with the error ... "Format of the initialization string does not conform to specification ...
(microsoft.public.dotnet.framework.aspnet)
Re: mdb access to names containing ""
... Replace' Replaces single quotes with doubled single ... >>Kevin Spencer ... >>Microsoft MVP ... >>> error or fails when names containing ' are processed. ...
(microsoft.public.frontpage.programming)
Re: Dlookup function criteria w/wo single quotes
... Pamphlet is a text field. ... When I use single quotes it works fine but I get into trouble because ... And yes it was the same database in both cases. ... A client site runs the FAILS version ok with MS Access 2003 11.6566.8132, ...
(microsoft.public.access.modulesdaovba)
Re: How to get vector elements to be interpreted as comma-separated arguments to a function?
... but only with the single quotes around the colon ... fails, ... % ans = 7 ...
(comp.soft-sys.matlab)