?
Solved

Updating indexes

Posted on 2001-09-11
4
Medium Priority
?
150 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
Motaz earned 160 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

777 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