Petros,
If you want that your code validation still in VFP code, you can do it through remote view.
You need to design a remote view in which the original data source is SQL Server.
The remote view behave similar to the native Visual FoxPro table.
You can still use the VFP table command such as "use", "delete", "insert".
Note that your remote view should have a buffer.
For detail information about remote view, go to this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgtskAccessingRemoteData.aspBut it is better if you can do it using Transaction SQL command.
I think you can do it using T-SQL but you need a person that have more experience writing SQL script. For complex algorithm you can use Cursor with the following syntax: declare @variablename cursor for select field1, field2, ... from tablename.
Note that using cursor is not a good approach since it is slow compare to using direct select, insert, update, delete SQL statement. If you have a person who have a good knowledge in writing SQL statement I believe that he can achieve the result.
Rene
Hello all,
Due to 2GB limitation of Visual FoxPro 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 Visual FoxPro good commands) You cannot avoid them !!!
We started writing SQL server SP to handle these algoritms but we find out we cannot reach Visual FoxPro times.
Now we are thinking to leave the database in SQL Server and validate / process the data, with Visual FoxPro 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