SQL update statement in VB

Article View: comp.databases.ms-sqlserver

Article #74

Back to comp.databases.ms-sqlserver Previous Next

#74

From: Mac
Date: Wed, 04 May 2005 16:41

20 lines
1681 bytes

I am trying to update price with cost times 100.

I am getting an error.

I would appreciate if someone please correct my code.

Thx




strcnn = "DRIVER=SQL SERVER; SERVER=" & SQLSVRSTR & ";" & _
   "UID=sa;PWD=TEST;DATABASE=" & SQLDBStr & ";"
Set cn = New ADODB.Connection
cn.Open strcnn
mprodcl = prod.txtpclass
markup = 100
strsql = "Update mytable SET mytable.price = " & mytable.cost & "*" & markup 
& ""
cn.Execute strsql

Technical Details

Message-ID: <1X6ee.7511$db7.5870@trnddc01>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc01.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 104de1,61d217a15791e81c,start
X-Google-Thread: ff490,61d217a15791e81c,start
X-Google-Thread: 10f695,61d217a15791e81c,start
X-Google-Thread: 10b213,61d217a15791e81c,start
X-Google-Attributes: gid104de1,gidff490,gid10f695,gid10b213,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc01.POSTED!53ab2750!not-for-mail
From: "Mac" <mac@hotmail.com>
Newsgroups: comp.databases.ms-sqlserver,comp.lang.visual.basic.misc,cz.comp.microsoft.sql,microsoft.public.sqlserver.server,microsoft.public.vb.controls
Subject: SQL update statement in VB
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <1X6ee.7511$db7.5870@trnddc01>
Date: Wed, 04 May 2005 16:41:33 GMT
NNTP-Posting-Host: 66.13.113.18
X-Complaints-To: abuse@verizon.net
X-Trace: trnddc01 1115224893 66.13.113.18 (Wed, 04 May 2005 12:41:33 EDT)
NNTP-Posting-Date: Wed, 04 May 2005 12:41:33 EDT