Rainer, As I said, it is not that terribly hard to migrate to SQL Server in an existing project . . . although, that partially depends on how the project is organized and the number of tables/queries and connections you have involved.
Something to think about, though, is that the BDE has been deprecated for some time now for a reason and Pradox tables, while fairly easy to set up and use through the BDE are not nearly as robust as SQL Server. At 06:45 PM 6/3/2007, you wrote: >Thanks for the responses! > >While I was waiting, I tried harder to cure the table corruption problem >I was having. And I found a soluton: Every few 1,000 records, set >Table.Active false and then True. This flushes some internal cache >(apparently), functioning like a "Commit Transaction" operation. Now, >as I understand things, this should not have been necessary, but ... >well, it allows my 250,000 record updates to work. > >I'll definitely migrate to SQL for new work; but I don't want to redo a >year's work. > >Thanks, >Rainer > >_______________________________________________ >Delphi-DB mailing list >Delphi-DB@elists.org >http://www.elists.org/mailman/listinfo/delphi-db Ralph D. Wilson II Systems Analyst Home: (210) 497-2643 Cell: (210) 387-7744 Fax: (210) 497-5726 [EMAIL PROTECTED] [EMAIL PROTECTED] _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
