Subject Re: unable to create index on .dbf having 30 fields and 100000 From Ken Mayer, dBase, LLC <kmayer@dbasellc.com> Date Wed, 1 Sep 2021 21:20:26 -0700 Newsgroups dbase.getting-started On 9/1/2021 8:38 PM, Milind Nighojkar wrote: > Ken Mayer, dBase, LLC Wrote: > Hi Ken, > > It hangs however ther is no error flashed. i > I have attached the screen . It says no response.. > > After restart I can see .ndx created however have a fear if it ciould be courrpted. I am using in the application for some stautory purpose. So felt not to take the risk. It sounds like it is just taking a very long time, and you should let it go. Unfortunately the BDE doesn't communicate well with dBASE in situations like this. You don't state what version of dBASE you're using. If you open dBASE itself, and in the Command Window, type: ? version(1) This will provide details about the version, and so on. The reason I suggest it, is that if it is Visual dBASE up through dBASE 2019, you should be able to do something like: _app.AllowYieldOnMsg := true Which will allow dBASE to communicate better, and perhaps not look like it is "hung" when it is doing something like this. It still won't look like anything is happening, but ... Wondering if there is a reason you're using the .NDX format for indexes, starting with dBASE IV the preferred version of indexes was to use the .MDX format, which automatically updates the indexes as you add/edit records, and more (and allows multiple indexes in one file, rather than having separate .NDX files for each). Ken -- *Ken Mayer*, dBase, LLC Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm