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