Jean Huveneers wrote: > > Hi, > > I've got a problem that looks a lot like PTS 1124113.
Why do you think that could be the same problem? do you update LONG-column + normal column and the normal column is updated not with one value, but using a value expression? How does your update look like? Please provide a vtrace according to http://sapdb.2scale.net/moin.cgi/VTrace but change default to default order in step1 and 6 Elke SAP Labs Berlin > > We are using the latest SAP DB version (7.4.03.31) with ADO > via ODBC from > Delphi on the folowing table: > > CREATE TABLE "DBA"."DBU_FIELD" > ( > "FIELD_ID" Integer NOT NULL, > "CLASS_ID" Integer, > "FIELDTYPE_ID" Integer, > "FIELDKIND_ID" Integer, > "FIELDNAME" Varchar (30) UNICODE, > "LENGTH" Integer, > "PRECISION" Integer, > "LOOKUPCLASS_ID" Integer, > "LOOKUPKEYFIELD_ID" Integer, > "LOOKUPVALUEFIELD_ID" Integer, > "NOT_NULL" Boolean, > "AGTYPE_ID" Integer, > "CONSTRAINT" Long UNICODE, > "SEARCHABLE" Boolean, > "VISIBILITY" Integer, > "FIELDORDER" Integer, > "COMPONENTTEXT_ID" Integer, > "MESSAGETEXT_ID" Integer, > "DESCRIPTION" Varchar (255) UNICODE, > "EDITABLE" Boolean, > PRIMARY KEY ("FIELD_ID") > ) > > When update-ing a record and using negative values for the > integer columns > the back-end responds with a '-3019 Invalid exponent > POS({x})' (when using > different order in the select statement the x changes). > > Can anybody please help me to get a this working (using > multiple update > statement is not an option). > > Regards and thanks, > > Jean Huveneers > > Xillion ICT Solutions B.V. > Marktplein 8 > 6243 BR Geulle > The Netherlands > > tel: +31 (0)43 3659244 > fax: +31 (0)43 3659249 > gsm: +31 (0)6 456 44 357 > www: www.xillion.nl > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
