Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

Updating indexes

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
riccohb
Asked:
riccohb
  • 3
1 Solution
 
MotazCommented:
That's a very easy problem, on creating your index check Maintained property.

Motaz
0
 
MotazCommented:
btw. What database type did you use?
0
 
riccohbAuthor Commented:
Thanks for that.

I'm using Paradox 7.
0
 
MotazCommented:
Thanks for the points:)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now