Hi all,
what does this error mean to me?
I have created one simple table using
CREATE TABLE BestAss
(
Pos LONG NOT NULL,
ArtNr CHAR(32) ,
QKz INT NOT NULL,
ErfArtNr CHAR (32) ,
PosBez1 CHAR(60) DEFAULT '',
PosBez2 LONG VARCHAR ,
MengeBest FLOAT ,
AnzNkSt INT ,
ME CHAR(10) ,
DatWunsch DATE ,
LiefNr CHAR(10) ,
CONSTRAINT BestAss_PKEY PRIMARY KEY (Pos)
)
and inserted some data with
INSERT INTO BestAss
VALUES('1','01.01.010','1','01.01.010','SKALPELLKLINGEN FIG.
10','','1','0','STK.',NULL,'')
INSERT INTO BestAss
VALUES('2','01.01.011','1','01.01.011','SKALPELLKLINGEN FIG.
11','','1','0','STK.',NULL,'')
so far, so good. The I tried to make a renumber on the field named
'Pos':
UPDATE BestAss SET Pos=-Pos WHERE Pos>=1
and the the error message appears:
37000: [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access
violation;-5015 POS(40) Missing keyword:OF.
Why this? I tried it with an ODBC-Connection and also with SQL Studio.
Seems to be a bug?
Using: SAP DB 7.3.0.20 on S.u.S.E 7.2, ODBC driver 7.3.0.21
Thanks in advance,
Tilmann Starke
SOFTWORK GmbH
Help to prevent global warming by writing cool software.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
