Update Query is not Working / Updateting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Carlos Garcia via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 12 Apr 2005 16:00:52 GMT

Hello,

I need some help with the query below. It is not update the table with the
value 'Carlos'. I read another comment about this regards here and I have
included the Temp, but It did not work for me. Thank you in advance for
your help. Thanks.

strSQLNova = "UPDATE " & TableUpdate & ", Temp" _
& " SET " & TableUpdate & "." & TableField _
& " = 'Carlos' ;"
'oDB.Execute strSQLNova

--
Message posted via http://www.accessmonster.com
.

Follow-Ups:
- Re: Update Query is not Working / Updateting
  - From: Carlos Garcia via AccessMonster.com

Prev by Date: Query not returning nulls
Next by Date: Re: Ranking Records in a Select Query
Previous by thread: Query not returning nulls
Next by thread: Re: Update Query is not Working / Updateting
Index(es):
- Date
- Thread

Relevant Pages

Re: Accessing class variable at class creation time
... class instance but instead from code running at class definition time. ... Regards, ... Carlos ... Prev by Date: ...
(comp.lang.python)
Re: What language should I use?
... Best regards, ... Carlos J. Quintero ... Prev by Date: ...
(microsoft.public.vsnet.general)
Re: Whats the difference between a function and a sub?
... > it's necessary, but as a general rule, it is harder to maintain code that ... Best regards, ... Carlos J. Quintero ... Prev by Date: ...
(microsoft.public.dotnet.languages.vb)
RE: SQLDTS File Transfer Protocol Task
... Post a query to sqldtsftp@xxxxxxxxxxxxxxxxxxxxx ... thanks and regards ... Chandra ... Prev by Date: ...
(microsoft.public.sqlserver.dts)
Re: Looking for sample code
... > A query that uses the following definition for a table: ... > UPDATEs. ... Prev by Date: ...
(comp.databases.oracle.tools)