The following SQL statement works fine in Microsoft Query 32:

insert into PYUWBA.DEDUCTION_TYPE
(DEDUCTION_TYPE.DEDN_TYPE_ID, DEDUCTION_TYPE.DEDN_TYPE_NAME, DEDUCTION_TYPE.DEDN_TYPE_ABBREV, DEDUCTION_TYPE.DEDN_TYPE_PRIORITY, DEDUCTION_TYPE.MANDATORY_IND, DEDUCTION_TYPE.ROW_ENTRY_LOGONID, DEDUCTION_TYPE.ROW_ENTRY_DTG )
VALUES (PYUWBA.DEDN_TYPE_ID_SEQ.NEXTVAL, 'Name', 'JOKE', 3000, 'N', 'sqc','13-FEB-97')

The pyuwba.dedn_type_id_seq is not a table, it appears to be a contraint or rule of some sort on the remote Oracle database.

The SQL statement fails in VFP 5.0, stating the object (pyuwba.dedn_type_id_seq) cannot be found.

The object is not visible to me when creating a remote view.

Any suggestions?