Solved

Updating indexes

Posted on 2001-09-11
4
146 Views
Last Modified: 2010-04-06
My app contains a very simple flat database that users can record data in. After the user has added a record, if a search is run on the table, the error 'Index out of date' is reported.

I thought I could get round this by adding a line saying

<tablename>.IndexDefs.Update

after the Post command when a new record is added, but it isn't making any difference.

Can anyone help?

(Sorry - I only have 40 points left)
0
Comment
Question by:riccohb
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
Motaz earned 40 total points
ID: 6473669
That's a very easy problem, on creating your index check Maintained property.

Motaz
0
 
LVL 7

Expert Comment

by:Motaz
ID: 6473673
btw. What database type did you use?
0
 

Author Comment

by:riccohb
ID: 6473695
Thanks for that.

I'm using Paradox 7.
0
 
LVL 7

Expert Comment

by:Motaz
ID: 6473707
Thanks for the points:)
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question