Arriyel,
Hmmmm ... well, the slow speed is a bit harder to diagnose. Where is your server located? On another machine or locally? If it's another machine, is that machine set up, hardware-wise, properly for a server? (lots of RAM and diskspace and fast processors). It shouldn't take that long unless you are testing against a very large database on your local machine (which wouldn't have a server configuration).
~~Bonnie
>Hi,
>
>I tried your suggestion and it works since I see all the records I updated in the remote view appear in the SQL table. Problem is that it is still very slow. I updated 25 records and it took 25+ seconds before the tableupdate() returned control to VFP. I'm testing it with a larger table (>400 records) and it is taking longer that I expected since I started it 10m minutes ago and it still hasn't finished.
>
>Do you have any other ideas?
>
>Thanks;
>Arriyel
>
>>Arriyel,
>>
>>
>then doing a tableupdate() but it would only add 10 records or less with the rest missing. Is there a setting on the SQL server I need to set?>>
>>Yes, for a remote view you probably need to use the following command:
>>
>>
>>DBSETPROP("MyView", "View", "MaxRecords", -1)
>>
>>
>>I believe it may default to 10 MaxRecords.
>>
>>HTH,
>>~~Bonnie