delphi 4 closed dataset/no index help

farminsure
farminsure used Ask the Experts™
on
I am getting error(s) when I try to run an application.  The error states it cannot work with a closed dataset and also that there is no index for policyno and mod for my table "tableapv"  But when I look at the tableapv with my object inpector it shows the indexfieldnames with policyno and mod.  It just started doing this, I was running the app fine earlier in the day  I attached screen shots with the errors as well as the dataset and table properties through the object inpsector. thanks  
delphi.doc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
That mean PolicyNo and Mod index don't exists in Table
So you had not create those index in your database

Author

Commented:
mahdi78, I attached a screen shot of the table, as you can see, PolciyNo and Mod are in the table

??

Mod.doc

Commented:
Can you attach an empty W_apv.DB file?
Commented:
You had not create those index, so you must select PolciyNo and Mod as Index by double clicking at key zone of PolciyNo and Mod fields
Check attached image
Index.jpg

Author

Commented:
Somehow the table structure changed????  This solution fixed the error, thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial