Hi Tilmann,
first of all for doing arithmetics the column type of
Pos has to bee changed. Replace "Pos LONG NOT NULL,"
by "Pos FIXED(5) NOT NULL," .
There is another option to circumvent this bug
- quote your column name, example:
UPDATE BestAss SET Pos=-Pos WHERE "Pos" >=1
Sincerely,
Dirk Zoettl
P.S: To avoid conflicts with reserved names I propose to
always use quoting of column and table names, since
the list of reserved words in quite large and is
database specific.
____________________________________________________________
"Zabach, Elke" wrote:
>
[...snip...]
>
> 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
>
[...snip...]
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
