| 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@hotmail6009.com> wrote in message
news:iH8mb.17405$Tr4.36215@attbi_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_netincome set film_no = 2532290, net_income = 200012,
> inc_year = 2000 where income_id = 67;
>
> Thanks, Tim
>
>[/color]
| 
