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 ?
patrick