SQL Update Query Problem

[Tim Hinkel]

I am getting the following error while connecting to a MS SQL Server 7 using
ODBC connecting thru a PERL application. The sql statement works perfectly
in Query Analyzer. Income_id is a int identity column, net_income is money
and the rest of the columns are integers. Any thoughts on how I can correct
this problem?

170: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '='.:
update form10_netincom e set film_no = 2532290, net_income = 200012,
inc_year = 2000 where income_id = 67;

Thanks, Tim

[Shervin Shapourian]

Re: SQL Update Query Problem

Tim,

Your code looks perfectly correct. Use Profiler to see what is sent to
server. I'm afraid your script is getting truncated somewhere.

Shervin

"Tim Hinkel" <thinkel@hotmai l6009.com> wrote in message
news:iH8mb.1740 5$Tr4.36215@att bi_s03...[color=blue]
> I am getting the following error while connecting to a MS SQL Server 7[/color]
using[color=blue]
> ODBC connecting thru a PERL application. The sql statement works[/color]
perfectly[color=blue]
> in Query Analyzer. Income_id is a int identity column, net_income is[/color]
money[color=blue]
> and the rest of the columns are integers. Any thoughts on how I can[/color]
correct[color=blue]
> this problem?
>
> 170: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect[/color]
syntax[color=blue]
> near '='.:
> update form10_netincom e set film_no = 2532290, net_income = 200012,
> inc_year = 2000 where income_id = 67;
>
> Thanks, Tim
>
>[/color]