Incorrect syntax near '('.

**Matt Garven** · Nov 15 '05, 12:05 PM

Re: Incorrect syntax near '('.

try instead:

string update = "UPDATE [PME].[dbo].[Expense] " +
"SET [ID] = @id, [ClientID] = @clientid, " + (etc!)
"WHERE id = @id";

Regards,
Matt

[color=blue]
> string select = "UPDATE [PME].[dbo].[Expense] " +
> "([ID],[ClientID],[Total],[TPS],[TVQ],[Gtotal],[DateFAC],
> [DatePAY],[Description],[fl_type],[fl_status],
> [fl_category],[fl_source],[defaut], [Cheque],
> [fl_taxable], [notaxe], [id]) " +
> " VALUES
> (@id,@clientid, @total,@tps,@tv q,@gtotal,@date fac,@datepay,
> @description,@f ltype,@flstatus ,@flcategory,@f lsource,@defa
> ut,@cheque,@flt axable,@notaxe, @id) " +
> " WHERE id = @id";[/color]

"Carl" <carl@cb-cinc.com> wrote in message
news:14fcf01c38 550$0d5c3350$a6 01280a@phx.gbl. ..[color=blue]
> Can you tell me what is wrong with this syntax ?
>
>
> string select = "UPDATE [PME].[dbo].[Expense] " +
> "([ID],[ClientID],[Total],[TPS],[TVQ],[Gtotal],[DateFAC],
> [DatePAY],[Description],[fl_type],[fl_status],
> [fl_category],[fl_source],[defaut], [Cheque],
> [fl_taxable], [notaxe], [id]) " +
> " VALUES
> (@id,@clientid, @total,@tps,@tv q,@gtotal,@date fac,@datepay,
> @description,@f ltype,@flstatus ,@flcategory,@f lsource,@defa
> ut,@cheque,@flt axable,@notaxe, @id) " +
> " WHERE id = @id";
>
> I receive the following error,
>
> Additional information:
> System.Web.Serv ices.Protocols. SoapException: Server was
> unable to process request. --->
> System.Data.Sql Client.SqlExcep tion: Line 1: Incorrect
> syntax near '('.
> at System.Data.Sql Client.SqlComma nd.ExecuteReade r
> (CommandBehavio r cmdBehavior, RunBehavior runBehavior,
> Boolean returnStream)
> at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
> at WS_PME.DB.SqlGe nericExecute(St ring sqlquery, String
> tablename, String ConfigConnectio nKey, String fonction,
> Object[,] aParameter) in F:\Structure\Pr ojets\VS2003
> \PME\WS_PME\Com ponents\DB_data set.cs:line 181
> at WS_PME.DB.Updat e_Expense(Strin g vClientID, Decimal
> vTotal, Decimal vTPS, Decimal vTVQ, Decimal vGtotal,
> DateTime vDateFac, DateTime vDatePay, String
> vDescription, Int32 vFlType, Int32 vFlStatus, Int32
> vFlCategory, Int32 vFlSource, Boolean vDEFAUT, String
> vCheque, Int32 vTAXABLE, Decimal vNoTaxe, Guid vID) in
> F:\Structure\Pr ojets\VS2003
> \PME\WS_PME\Com ponents\DB_data set.cs:line 298
> at WS_PME.WSPME.Up dateExpense(Str ing vClientID,
> Decimal vTotal, Decimal vTPS, Decimal vTVQ, Decimal
> vGtotal, DateTime vDateFac, DateTime vDatePay, String
> vDescription, Int32 vFlType, Int32 vFlStatus, Int32
> vFlCategory, Int32 vFlSource, Boolean vDEFAUT, String
> vCHEQUE, Int32 vTAXABLE, Decimal vNoTaxe, Guid vID) in
> F:\Structure\Pr ojets\VS2003\PM E\WS_PME\PME.as mx.cs:line 99
> --- End of inner exception stack trace ---
>
>[/color]

**Chris R. Timmons** · Nov 15 '05, 12:06 PM

Re: Incorrect syntax near '('.

"Carl" <carl@cb-cinc.com> wrote in
news:14fcf01c38 550$0d5c3350$a6 01280a@phx.gbl:
[color=blue]
> Can you tell me what is wrong with this syntax ?
>
> string select = "UPDATE [PME].[dbo].[Expense] " +
> "([ID],[ClientID],[Total],[TPS],[TVQ],[Gtotal],[DateFAC],
> [DatePAY],[Description],[fl_type],[fl_status],
> [fl_category],[fl_source],[defaut], [Cheque],
> [fl_taxable], [notaxe], [id]) " +
> " VALUES
> (@id,@clientid, @total,@tps,@tv q,@gtotal,@date fac,@datepay,
> @description,@f ltype,@flstatus ,@flcategory,@f lsource,@defa
> ut,@cheque,@flt axable,@notaxe, @id) " +
> " WHERE id = @id";[/color]

Carl,

Are you trying to do an UPDATE or INSERT? The command you've written
appears to be a strange combination of both. Is this command being
sent to an SQL server, or some other kind of database?

Chris.
-------------
C.R. Timmons Consulting, Inc.

C.R. Timmons Consulting, Inc.

http://www.crtimmonsinc.com/

**Kristofer Gafvert** · Nov 15 '05, 12:07 PM

Re: Incorrect syntax near '('.

Hello,

You are using wrong SQL syntax. I assume that this is an update, although
you've mixed the UPDATE and INSERT syntax.

It should be:
UPDATE yourTable
SET
column1 = 'value1',
column2 = 'value2'
WHERE
id = @id

column1 and column2 are examples of column names, you should substitute this
to your column names (i was lazy writing...)

Hope this helps

--
Regards,
Kristofer Gafvert
http://www.ilopia.com - FAQ & Tutorials for Windows Server 2003, and SQL
Server 2000
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.

"Carl" <carl@cb-cinc.com> wrote in message
news:14fcf01c38 550$0d5c3350$a6 01280a@phx.gbl. ..[color=blue]
> Can you tell me what is wrong with this syntax ?
>
>
> string select = "UPDATE [PME].[dbo].[Expense] " +
> "([ID],[ClientID],[Total],[TPS],[TVQ],[Gtotal],[DateFAC],
> [DatePAY],[Description],[fl_type],[fl_status],
> [fl_category],[fl_source],[defaut], [Cheque],
> [fl_taxable], [notaxe], [id]) " +
> " VALUES
> (@id,@clientid, @total,@tps,@tv q,@gtotal,@date fac,@datepay,
> @description,@f ltype,@flstatus ,@flcategory,@f lsource,@defa
> ut,@cheque,@flt axable,@notaxe, @id) " +
> " WHERE id = @id";
>
> I receive the following error,
>
> Additional information:
> System.Web.Serv ices.Protocols. SoapException: Server was
> unable to process request. --->
> System.Data.Sql Client.SqlExcep tion: Line 1: Incorrect
> syntax near '('.
> at System.Data.Sql Client.SqlComma nd.ExecuteReade r
> (CommandBehavio r cmdBehavior, RunBehavior runBehavior,
> Boolean returnStream)
> at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
> at WS_PME.DB.SqlGe nericExecute(St ring sqlquery, String
> tablename, String ConfigConnectio nKey, String fonction,
> Object[,] aParameter) in F:\Structure\Pr ojets\VS2003
> \PME\WS_PME\Com ponents\DB_data set.cs:line 181
> at WS_PME.DB.Updat e_Expense(Strin g vClientID, Decimal
> vTotal, Decimal vTPS, Decimal vTVQ, Decimal vGtotal,
> DateTime vDateFac, DateTime vDatePay, String
> vDescription, Int32 vFlType, Int32 vFlStatus, Int32
> vFlCategory, Int32 vFlSource, Boolean vDEFAUT, String
> vCheque, Int32 vTAXABLE, Decimal vNoTaxe, Guid vID) in
> F:\Structure\Pr ojets\VS2003
> \PME\WS_PME\Com ponents\DB_data set.cs:line 298
> at WS_PME.WSPME.Up dateExpense(Str ing vClientID,
> Decimal vTotal, Decimal vTPS, Decimal vTVQ, Decimal
> vGtotal, DateTime vDateFac, DateTime vDatePay, String
> vDescription, Int32 vFlType, Int32 vFlStatus, Int32
> vFlCategory, Int32 vFlSource, Boolean vDEFAUT, String
> vCHEQUE, Int32 vTAXABLE, Decimal vNoTaxe, Guid vID) in
> F:\Structure\Pr ojets\VS2003\PM E\WS_PME\PME.as mx.cs:line 99
> --- End of inner exception stack trace ---
>
>[/color]

**Carl** · Nov 15 '05, 12:12 PM

Re: Incorrect syntax near '('.

The issue as been fixes using the following syntax,

string select = "UPDATE Expense " +
"SET ID = @id,ClientID = clientid,Total = @total,TPS =
@tps,TVQ = @tvq,Gtotal = @gtotal,DateFAC = @datefac," +
"DatePAY = @datepay,Descri ption = @description,fl _type =
@fltype,fl_stat us = @flstatus,fl_ca tegory = @flcategory,"
+
"fl_source = @flsource,defau t = @defaut,Cheque = @cheque,
fl_taxable = @fltaxable,nota xe = @notaxe " +
"WHERE id = @id";

Thanks for all the answers...

Carl,

Incorrect syntax near '('.

Incorrect syntax near '('.

Comment

Comment

Comment

Comment