Tilmann Starke wrote:
> 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
Oh noooo!
Sorry, it's my fault.
There is an internally used syntax construct starting with WHERE POS OF
in the code.
And now the stupid code does not realize that pos in your case ist not the
POS mentioned above, but a normal columnname.
Thank you for reporting. I will fix it.
In the meantime there are two choices
- rename pos to something else
- use WHERE 1<=pos
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
