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