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