>Is this any faster than creating a view of the table, buffering the view, and then inserting records into the view from memvars and then doing a table update command to write the record?
>
>Is there a way to get the error type if for some reason the insert fails?
>
>Its too late to change for this project, but I am hoping to get another similar project in the near future.
>
>Plus (I just thought of this) then to see what was written, I would have to requery the view, right? Unless of course I wrote the records to a local copy first, and then made my update routine do the SPT to do the insert. hmmmm...
>
>
>
It sure looks like a lot of work with the view. But maybe (don't know for a fact because I don't normally use remote views) it is faster if all of the records are sent back at one time. Although SQL pass-through is supposed to be faster than remote views.
You can get error info for failed SQL pass-through statements with AERROR().