Hi Mark,
I had a similar problem at a client's site with quite a large table
(about 100,000 rows).
After much fiddling around, I eventually used an app called tutil.exe to
repair the table and it rebuilt all of the indices - problem solved.
I believe that app is available on several of the major Delphi sites.
Regards,
Bevan
> Mark Howard wrote:
>
> Hi
>
> I have a problem at one site.
>
> They had a problem with one table in their database.
> We have deleted the index files
> Using the DBD we have reset the primary index comprised an integer,
> alpha and autoincrement field. The .PX file was created.
> We have defined a secondary index made up of only the Autoincrement
> field, given it a name and saved the table.
> the DBD reported no errors.
> However when we look at the structure again, no secondary index
> appears.
> And no additional files have been created.
>
> I can go through these steps on my system and it works OK.
>
> This matter is quite urgent and I would appreciate any help in
> tracking down the cause and finding a solution.
>
> TIA
>
> Mark
>
>
>
--
Bevan Edwards mailto:[EMAIL PROTECTED]
Achieve Software Limited http://www.achieve.co.nz
Phone: (64-9) 444-4210 ICQ: 732011
Fax: (64-9) 444-4201
Mobile: (64-21) 979-603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
