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 ?