Hey guys ----
Switch over to SQLEXEC() and execute an SQL DELETE?
>>Does anyone know how to delete all the records from a remote view. I have a table with 4500 records. I used DELETE ALL from a remote view of that table (I must use a remote view) but it takes like five minutes to perform that operation. I need a faster way to do this but I can't use the table directly.
>>Thank you.
>
>How do you have the table buffered? Are you using ROW or TABLE buffering? If you are using ROW buffering, try table buffering the sucker and then doing the tableupdate.
>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05