(NB originally reported on http://scn.sap.com/message/16127623 - that doesn't appear to be a very active forum :)

I've run into a serious problem after upgrading a client from Advantage v8 to v11, and would appreciate it if you could see what is causing this error, and hopefully come up with a fix for it.

I've been able to replicate the problem with a very small example:

Step 1:

Run this SQL to create table BAD.DBF:

/ Table Type of Bad.dbf is CDX/

Create Table Bad(
   PO Char( 9 ),
   GRADINGORD Numeric( 2 ,0 )
);

INSERT INTO "Bad" VALUES( 'X00259008', NULL );

Create Index PO on Bad( PO );
//Create Index DPONUM on Bad( );

The "Export table structure" utility in Arc32 doesn't cope with this next index expression, but it can be created manually in Arc32:

Step 2:

use Arc32 to manually create an index called "DPONUM", with the following index expression:

Descend(SubStr(po,4))

Step 3:

try to update the table by running the following SQL:

UPDATE Bad
SET gradingord=6
WHERE po='X00259008';

Resulting error:

poQuery: Error 7200:  AQE Error:  State = HY000;   NativeError = 4004;  [iAnywhere Solutions][Advantage SQL][ASA] Error 4004:  Advantage Expression Engine evaluator stack overflow.

asked 31 Jul '15, 05:49

Doug%20Woodrow's gravatar image

Doug Woodrow
1215512
accept rate: 0%


I've found a fix for this problem:

Change the index expression to "Descend(SubStr(po,4,6))".

But I still find it worrying that ADS v11 is not fully backwards compatible with v8.

link

answered 31 Jul '15, 05:51

Doug%20Woodrow's gravatar image

Doug Woodrow
1215512
accept rate: 0%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×325
×30

Asked: 31 Jul '15, 05:49

Seen: 1,787 times

Last updated: 31 Jul '15, 05:51

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.