Hello all,


Due to 2GB limitation of VFP we moved our database to SQL Server 2000.

Our applications handle large data volumns of about 5,000,000 incoming records per week which we have to load them Validate them (with very complex statistical algorithms) and Process them.

In order to apply these algoritms you need record by record scans, SQL statemnts, loops, if statements, temporary cursors etc.. (all the VFP good commands) You cannot avoid them !!!

We started writing SQL server SP to handle these algoritms but we find out we cannot reach VFP times.

Now we are thinking to leave the database in SQL Server and validate / process the data, with VFP COM object which will extract based on filter the data need to process and update back the final results to SQL Server.

Any ideas will be very helpful

Thanks in advance