SQL ERROR - UPDATE PROBLEM - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL ERROR - UPDATE PROBLEM

Author

Topic

zoom
Starting Member

4 Posts

Posted - 2003-12-01 : 05:53:31

HI!
I HAVE PROBLEM WHEN EXECUTE 'UPDATE' IN MY COBOL-PROGRAM.

EXEC SQL
UPDATE TESTTAB
SET B1 = :W-ZERO
WHERE A1 = :W-AKT-NAMN
END-EXEC.
WHEN EXECUTE THIS I GET THIS MESSAGE
+000000137
[MICROSOFT][ODBC SQL SERVER DRIVER][SQL SERVER]MUST DECLARE THE
VARIABLE '@P1WHERE'.

SO I CHANGE MY CODE TO

EXEC SQL
UPDATE TESTTAB
SET ( B1 = :W-ZERO )
WHERE ( A1 = :W-AKT-NAMN )
END-EXEC.
WHEN EXECUTE THIS I GET THIS MESSAGE
+000000170
[MICROSOFT][ODBC SQL SERVER DRIVER][SQL SERVER]LINE 1: INCORRECT
SYNTAX NEAR '('.
HAVE TRIED EVERYTHING NOW (I THINK)
RUNNING ON XP/SQL SERVER 2000.
I HOPE SOMEONE CAN HELP ME / MY BEST REGARDS

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-12-01 : 06:36:48

EXEC SQL
UPDATE TESTTAB
SET B1 = 'W-ZERO'
WHERE A1 = 'W-AKT-NAMN'
END-EXEC.

EXEC SQL
UPDATE TESTTAB
SET B1 = 'W-ZERO'
WHERE A1 = 'W-AKT-NAMN'
END-EXEC.

zoom
Starting Member

4 Posts

Posted - 2003-12-01 : 08:47:23

STILL NOT WORKING BUT IT SEEMS I HAVE COME ONE STEP FORWARD.
NOW GET ERROR 245, SYNTAX ERROR CONVERTING THE VARCHAIR VALUE ' W-ZERO ' TO A COLUM OF DATA SMALL INT.
BUT W-ZERO IS DECLARED AS INTEGER !

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2003-12-01 : 09:30:19

'W-ZERO' Is being applied as a literal not as a varible.
Replace
SET B1 = 'W-ZERO'
With
SET B1 = W-ZERO

Jim
Users <> Logic

zoom
Starting Member

4 Posts

Posted - 2003-12-01 : 09:51:32

OKEY, NOW I GOT ERROR 207 SAYS INVALID COLUMN NAME 'W'
IS IT SOME KIND OF VIRUS ??

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2003-12-01 : 10:31:28

Sorry I forgot SQL does not like - in Variable names.

Try

SET B1 = [W-ZERO]

Jim
Users <> Logic

zoom
Starting Member

4 Posts

Posted - 2003-12-02 : 07:35:30

sorry, that doesnt work either.
must be some trouble with the connection between the program
and sql. looking for service packs now.

SamC
White Water Yakist

3467 Posts

Posted - 2003-12-02 : 08:00:55

quote:
Originally posted by zoom

sorry, that doesnt work either.

Wondering what doesn't work - any error message? Jim's suggestions were syntax errors in the query. W-ZERO is read as: Column W minus Column Zero. Don't look for the service packs yet.

How about posting the column names and types used in testtab?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources