>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?
try the insert wo/ that column. in sql server, doing an insert to a table that has an identity col (i think similar), you don't explicitly mention the col and it does the work for you.