Using Local Advantage version 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

accept rate: 0%

edited 26 Feb '15, 09:22

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

Jens Mühlenhoff

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.

answered 17 Jul '13, 08:49

Alex%20Wong's gravatar image

Alex Wong
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.


answered 18 Jul '13, 18:36

B%20C's gravatar image

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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



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.