<div>
That mean PolicyNo and Mod index don't exists in Table<br />
So you had not create those index in your database
</div>


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

<div>
mahdi78, I attached a screen shot of the table, as you can see, PolciyNo and Mod are in the table<br />
<br />
??<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2010/02_w06/229575/Mod.doc" target="_blank" class="file-inline" title="table structure (44 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Mod.doc</a>
</div>


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

??

Mod.doc [https://filedb.experts-exchange.com/incoming/2010/02_w06/229575/Mod.doc]

Mod.doc

<div>
Can you attach an empty W_apv.DB file?
</div>


Index.jpg

<div>
Somehow the table structure changed???? &nbsp;This solution fixed the error, thank you!
</div>


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

<div>
<div class="content wysiwyg-content">
I am getting error(s) when I try to run an application. &nbsp;The error states it cannot work with a closed dataset and also that there is no index for policyno and mod for my table &quot;tableapv&quot; &nbsp;But when I look at the tableapv with my object inpector it shows the indexfieldnames with policyno and mod. &nbsp;It just started doing this, I was running the app fine earlier in the day &nbsp;I attached screen shots with the errors as well as the dataset and table properties through the object inpsector. thanks &nbsp;<br />
<a href="https://filedb.experts-exchange.com/incoming/2010/02_w06/229554/delphi.doc" target="_blank" class="file-inline" title="screen shots of errors/code (95 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>delphi.doc</a>
</div>
</div>


delphi.doc

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 4 closed dataset/no index help

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.