Syntax Problem

ravikumar00008 · Jul 20, 2012

HI,

This is the query i am using to update the records.

But when i am executing,getting sql syntax error.

Please correct the syntax of the query.

[pre]

Code:

sSQL = &#34;UPDATE TblTest &#34; & _
&#34;set [Month] = &#39;&#34; & SplitMonth & &#34;&#39; , [Year] = &#39;&#34; & SplitYear & &#34;&#39; , [Protocol#] = &#39;&#34; & ColA & &#34;&#39;&#34; & _
&#34; [Project Name]= &#39;&#34; & ColB & &#34;&#39; , [Project Coord]= &#39;&#34; & ColC & &#34;&#39; , [Lot#]= &#39;&#34; & ColD & &#34;&#39;&#34; & _
&#34; [Date Rec&#39;d]= &#39;&#34; & ColE & &#34;&#39; , [Date ready to measure]= &#39;&#34; & ColF & &#34;&#39; , [Date Measured]= &#39;&#34; & ColG & &#34;&#39;&#34; & _
&#34; [Qty of Lenses Measured]= &#39;&#34; & ColH & &#34;&#39; , [BC]= &#39;&#34; & ColI & &#34;&#39; , [CT]= &#39;&#34; & ColJ & &#34;&#39;&#34; & _
&#34; [Power]= &#39;&#34; & ColK & &#34;&#39; , [Diameter]= &#39;&#34; & ColL & &#34;&#39; , [Lens Cross Sections]= &#39;&#34; & ColM & &#34;&#39;&#34; & _
&#34; [Qty of Lenses x-sectioned]= &#39;&#34; & ColN & &#34;&#39; , [Others]= &#39;&#34; & ColO & &#34;&#39; , [CompletionDate]= &#39;&#34; & ColP & &#34;&#39;&#34; & _
&#34; [Turn Around Time(# of Days)]= &#39;&#34; & ColQ & &#34;&#39;&#34; & _
&#34; Where [ID]  = &#39;&#34; & SqlID & &#34;&#39;&#34;

[/pre]

Regards

Kumar

SirJB7 · Jul 20, 2012

Hi, ravikumar00008!

Without the TblTest definition (fields and types) and without the variables definition (field, types and values), there's no much that can be done, except for missing commas after fields:

Protocol#, Lot#, [Date Measured], CT, [Lens Cross Sections], CompletionDate

Regards!

ravikumar00008 · Jul 24, 2012

Hi SirJB7,

Thanks for the help.

yes the lack of commas is the problem.

here is the correct code.

[pre]

Code:

sSQL = &#34;UPDATE TblLabParams &#34; & _
&#34;set [Month] = &#39;&#34; & SplitMonth & &#34;&#39; , [Year] = &#39;&#34; & SplitYear & &#34;&#39; , [Protocol] = &#39;&#34; & ColA & &#34;&#39;&#34; & _
&#34; ,[ProjectName]= &#39;&#34; & ColB & &#34;&#39; , [ProjectCoordinator]= &#39;&#34; & ColC & &#34;&#39; , [Lot]= &#39;&#34; & ColD & &#34;&#39;&#34; & _
&#34; ,[DateRecord]= &#39;&#34; & ColE & &#34;&#39; , [DateReadyToMeasure]= &#39;&#34; & ColF & &#34;&#39; , [DateMeasured]= &#39;&#34; & ColG & &#34;&#39;&#34; & _
&#34; ,[QtyOfLensMeasured]= &#39;&#34; & ColH & &#34;&#39; , [BC]= &#39;&#34; & ColI & &#34;&#39; , [CT]= &#39;&#34; & ColJ & &#34;&#39;&#34; & _
&#34; ,[Power]= &#39;&#34; & ColK & &#34;&#39; , [Diameter]= &#39;&#34; & ColL & &#34;&#39; , [LensCrossSections]= &#39;&#34; & ColM & &#34;&#39;&#34; & _
&#34; ,[QtyOfLensXSectioned]= &#39;&#34; & ColN & &#34;&#39; , [Others]= &#39;&#34; & ColO & &#34;&#39; , [CompletionDate]= &#39;&#34; & ColP & &#34;&#39;&#34; & _
&#34; ,[TurnAroundTime]= &#39;&#34; & ColQ & &#34;&#39;&#34; & _
&#34; Where [ID] = &#39;&#34; & SqlID & &#34;&#39;&#34;

[/pre]
Regards

Kumar

SirJB7 · Jul 24, 2012

Hi, ravikumar00008!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!

Syntax Problem

ravikumar00008

New Member

SirJB7

Excel Rōnin

ravikumar00008

New Member

SirJB7

Excel Rōnin