Using Local Advantage version 10.10.0.6 on XP writing in Delphi 2005.

I can restructure tables in terms of adding columns but having issue when trying to change the width of a column from 30 to 100 characters. The column is not indexed.

Code to restructure is Restructure('','','Description2,Description2,Char,100');

but getting message ...raised exception class EADSDatabaseError with message 'tblNomixM: Error 5041: The requested object was not found. .\ccolumn.cpp, 4995'. Process stopped. Used Step or Run to continue.

Have checked column name and it is as per the database.

Any suggestions welcomed.

asked 16 Jul '13, 06:25

B%20C's gravatar image

B C
46558
accept rate: 0%

edited 26 Feb '15, 09:22

Jens%20M%C3%BChlenhoff's gravatar image

Jens Mühlenhoff
1.3k51037


Some possible scenarios for this error:

  1. The index of the data dictionary file is corrupt or out of date. You can delete the .ai file and try again.
  2. The meta data of the table in the data dictionary does not match the actual table structure. This can be the case if using DBF table and the table is restructured while not connected to the database. You can use this SQL command in ARC to check the meta data in the data dictionary "SELECT * FROM system.columns WHERE Parent = 'MyTable'". If the meta data does not match the actual table structure, you can remove the table from the data dictionary and add it back to correct the problem.
link

answered 17 Jul '13, 08:49

Alex%20Wong's gravatar image

Alex Wong
5.3k2488
accept rate: 42%

edited 17 Jul '13, 08:51

That was the issue - thanks a lot. Table structure and meta data was out of sync.

Went through each table with the select statement and found offending table.

Exported to a New Table. Removed the old one. Added the new table into the dictionary and all is OK.

link

answered 18 Jul '13, 18:36

B%20C's gravatar image

B C
46558
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:

×271
×79
×4

Asked: 16 Jul '13, 06:25

Seen: 7,999 times

Last updated: 26 Feb '15, 09:22

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.