The reason you have observed that there are more problems over a network is
that Pdox is not really designed with multiple users on a network in mind.
Add into that Windows disk caching and problems with network redirectors...
Make sure in the AfterPost event handler for each table there is a call to
dbiSaveChanges.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Bevan Edwards
> Sent: Friday, 17 November 2000 12:02
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Can't make secondary index on Paradox table
>
>
>
> Hi Mark,
>
> One more thing just sprang to mind. I had endless problems with indices
> on Paradox tables and eventually tracked it down to having a large
> number of records (100,000+) and the block size set to 2k (by default).
>
> For those few large tables, I specifically changed the BDE Paradox
> Driver settings to 32k block size, re-created the table (Borrowing the
> structure and index definitions from the original table) and then added
> all of the records from the original table to the new table. Since then
> I haven't had any problems with corrupted indices.
>
> I also noticed that this only happened over a slow network, and I never
> seemed to get the problem if the files were on a local drive.
>
> Regards,
>
> Bevan
>
> --
> 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"
>
---------------------------------------------------------------------------
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"
