Hello Patrick,

I'm sorry, I misunderstood. I thought you only wanted to delete the records from the view. Are you also wanting to delete the records from the backend table?

I don't use Oracle, but (assuming that your view is set up properly) you should be able do a tableupdate() on the view after deleting the records from the view. That will send the changes (deletes in this case) to the backend.

Using SPT to delete the records from the Oracle table would be another simple approach.

>hi Steve -
>
>nope, not a parameterized view. and, as for doing a requey(),
>like i said, i closed the view and re-opened it, which i believe
>will requery (re-construct) the view cursor.
>
>((((((
>this project will be a nightly export of VFP record to Oracle.
>i'm just (trying to) deleting all the records in the Oracle table
>(remote view) and adding all back -- 1) because there aren't very
>many records involved, and 2) because it's simple).
>))))))
>
>i've seen a couple other threads here that discussed SQL pass-through.
>i'm wondering if that is my only recourse for actually deleting records
>from the base Oracle table ?